<< < 6 7 8 9 10 11 12 13 14 15 16 > >>   Sort: Date

How Does Oracle Handle Read Consistency
How Does Oracle Handle Read Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle supports two options for you on how to maintain read consistency: READ WRITE (the default option), also called statement-level read consistency. READ ONLY, also called transaction-level read c...
2007-04-18, 5245👍, 0💬

What Is a Database Table
What Is a Database Table? - Oracle DBA FAQ - Managing Oracle Database Tables A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a colum...
2007-05-03, 5243👍, 0💬

How To Define a Cursor Variable
How To Define a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL To define cursor variable, you must decide which REF CURSOR data type to use. There are 3 ways to select a REF CURSOR data type: Define your own specific REF CURSOR types using the TYPE ... RETURN statement. Define yo...
2007-04-28, 5243👍, 0💬

How To Connect the Oracle Server as SYSDBA
How To Connect the Oracle Server as SYSDBA? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank pass...
2007-04-23, 5243👍, 0💬

What To Do If DBA Lost the SYSTEM Password
What To Do If DBA Lost the SYSTEM Password? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If the DBA lost the password of the SYSTEM user account, he/she can go to the Oracle server machine, and run SQL*Plus on server locally with the operating system authentication method to ...
2007-04-28, 5240👍, 0💬

How To Pass Parameters to Procedures
How To Pass Parameters to Procedures? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below s...
2007-04-26, 5240👍, 0💬

How To Execute a Stored Program Unit
How To Execute a Stored Program Unit? - Oracle DBA FAQ - Introduction to PL/SQL If you want to execute a stored program unit, you can use the EXECUTE statement. The example script below shows how to executes a stored program unit: SQL> set serveroutput on; SQL> CREATE PROCEDURE Hello AS 2 BEGIN 3 DB...
2007-04-25, 5236👍, 0💬

How To Write a Query with a Full Outer Join
How To Write a Query with a Full Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to query from two tables with a full outer join, you can use the FULL OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a full outer join from two ...
2007-04-19, 5234👍, 0💬

What Privilege Is Needed for a User to Query Tables in Another Schema
What Privilege Is Needed for a User to Query Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercis...
2007-05-01, 5232👍, 0💬

How To Loop through Data Rows in the Implicit Curosr
How To Loop through Data Rows in the Implicit Curosr? - Oracle DBA FAQ - Working with Cursors in PL/SQL You use the FOR ... IN ... LOOP statement to loop through data rows in the implicit cursor as the following syntax: FOR row IN dml_statement LOOP (statement block with row.field) END LOOP; Here "r...
2007-04-29, 5231👍, 0💬

What Is a Cursor
What Is a Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML...
2007-04-29, 5229👍, 0💬

How To Add a New Column to an Existing Table
How To Add a New Column to an Existing Table? - Oracle DBA FAQ - Understanding SQL DDL Statements If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL> connect HR/fy...
2007-04-22, 5226👍, 0💬

How To Define a Procedure inside Another Procedure
How To Define a Procedure inside Another Procedure? - Oracle DBA FAQ - Introduction to PL/SQL Define a procedure inside another procedure is supported by PL/SQL. The following tutorial script shows you an example: SQL> CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS 2 PROCEDURE DBA_TASK (day VARCHAR2) AS...
2007-04-26, 5225👍, 0💬

What Are DML Statements
What Are DML Statements? - Oracle DBA FAQ - Understanding SQL DML Statements DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in dat...
2007-04-22, 5225👍, 0💬

How To Use Attributes of the Implicit Cursor
How To Use Attributes of the Implicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL Right after executing a DML statement, you retrieve any attribute of the implicit cursor by using SQL%attribute_name, as shown in the following tutorial exercise: CREATE TABLE student (id NUMBER(5) PRIMAR...
2007-04-29, 5223👍, 0💬

What Privilege Is Needed for a User to Connect to Oracle Server
What Privilege Is Needed for a User to Connect to Oracle Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: >.\bin\sq...
2007-05-02, 5219👍, 0💬

How To Insert a Record into a Table
How To Insert a Record into a Table? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can insert a row to this table with this RECORD variable using the INSERT statement as shown in the example below: CREATE TAB...
2007-04-26, 5218👍, 0💬

How To Download Oracle Database 10g XE
How To Download Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are dow...
2007-04-23, 5218👍, 0💬

Can Multiple Columns Be Used in GROUP BY
Can Multiple Columns Be Used in GROUP BY? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department: SQL> SELECT department_id, salary...
2007-04-20, 5218👍, 0💬

What Are the Differences between DATE and TIMESTAMP
What Are the Differences between DATE and TIMESTAMP? - Oracle DBA FAQ - Understanding SQL Basics The main differences between DATE and TIMESTAMP are: DATE stores values as century, year, month, date, hour, minute, and second. TIMESTAMP stores values as year, month, day, hour, minute, second, and fra...
2007-04-24, 5216👍, 0💬

What Is a Data Lock
What Is a Data Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management A data lock is logical flag the Oracle server is placed on data objects to give an exclusive right to a transaction. Statements in other transactions needs to respect data locks based on certain rules. Rules on data loc...
2007-04-17, 5216👍, 0💬

How To Recover a Dropped Table
How To Recover a Dropped Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you accidentally dropped a table, can you recover it back? The answer is yes, if you have the recycle bin feature turned on. You can use the FLASHBACK TABLE ... TO BEFORE DROP statement to recover a dropped table f...
2007-05-03, 5214👍, 0💬

What Is Oracle Server Autotrace
What Is Oracle Server Autotrace? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning: Statement execution path - Shows you the execution loop logic of a DML statement...
2007-04-29, 5214👍, 0💬

How To Assign Data of the Deleted Row to Variables
How To Assign Data of the Deleted Row to Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQ...
2007-04-27, 5214👍, 0💬

<< < 6 7 8 9 10 11 12 13 14 15 16 > >>   Sort: Date