< 1 2 3 4 5 6 7 > >>   Sort: Date

What Are Data Pump Export and Import Modes
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes: Full: Exports and imports a full database. U...
2007-05-01, 7730👍, 0💬

Can one change the mouse pointer in Forms?
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms allows one to change the mouse pointer. Example: SET_APPLICATION_PROPERTY(CURSO R_STYLE,BUSY); The following cursor styles are supported: * BUSY - Specifies a busy symbol * CROSSHAIR - Specifies a crossh...
2011-04-19, 7714👍, 0💬

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

How To Delete a User Account
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fy...
2007-05-02, 7587👍, 0💬

What Is the Difference between Formal Parameters and Actual Parameters
What Is the Difference between Formal Parameters and Actual Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Formal parameter and actual parameter are two different terms related parameters used in the procedures and functions: A formal parameter is a term used to ref...
2007-04-25, 7586👍, 0💬

How To Manage Transaction Isolation Level
How To Manage Transaction Isolation Level? - Oracle DBA FAQ - Introduction to PL/SQL Transaction isolation level can be managed in a procedure by using the SET TRANSACTION and COMMIT statements. Here is a sample script on how to manage transaction isolation level: SQL> CREATE OR REPLACE PROCEDURE HR...
2007-04-26, 7478👍, 0💬

How To Change System Global Area (SGA)
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your serve...
2007-04-24, 7384👍, 0💬

What Are the Parameter Modes Supported by PL/SQL
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions PL/SQL supports 3 parameter modes on procedure/function parameters: IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function....
2007-04-25, 7347👍, 0💬

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following select statement returns the number of rows in the "department" table: ...
2007-04-20, 7347👍, 0💬

How To Process Query Result in PL/SQL
How To Process Query Result in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL You can run queries (SELECT statements) in a PL/SQL code blocks, and process the results a loop as shown in the following script example: SQL> set serveroutput on; SQL> BEGIN 2 FOR row IN 3 (SELECT * FROM employees WHER...
2007-04-26, 7301👍, 0💬

What Happens to Indexes If You Drop a Table
What Happens to Indexes If You Drop a Table? - Oracle DBA FAQ - Managing Oracle Table Indexes If you drop a table, what happens to its indexes? The answer is that if a table is dropped, all its indexes will be dropped too. Try the following script to see yourself: CREATE TABLE student (id NUMBER(5) ...
2007-05-02, 7233👍, 0💬

How To Assign Debug Privileges to a User
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default dat...
2007-04-28, 7204👍, 0💬

What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML Statements If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, Oracle server will g...
2007-04-21, 7181👍, 0💬

What Are Named Parameters
What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Named parameters are actual parameters specified not by position but by providing formal parameter names when calling the procedure or function. The main advantage of named parameters is that the caller d...
2007-04-21, 7143👍, 0💬

How Oracle Handles Dead Locks
How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle server automatically detects dead locks. When a dead lock is detected, Oracle server will select a victim transaction, and fail its statement that is blocked in the dead lock to break the dead lock. The...
2007-04-17, 7143👍, 0💬

How To Use "IN OUT" Parameter Properly
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Here are the rules about IN OUT parameters: A formal IN OUT parameter acts like an initialized variable. An actual IN OUT parameter must be a variable. An actual IN OUT parameter passes a cop...
2007-04-21, 7066👍, 0💬

How To Retrieve the Count of Updated Rows
How To Retrieve the Count of Updated Rows? - Oracle DBA FAQ - Working with Database Objects in PL/SQL After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following t...
2007-04-27, 6984👍, 0💬

Can one execute dynamic SQL from Forms?
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg: FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')'); Just note that FORMS_DDL will force an implicit COMMIT and may de-synchronize the Oracle Forms COMMIT mechanism.
2011-04-12, 6970👍, 0💬

Can Sub Procedure/Function Be Called Recursively
Can Sub Procedure/Function Be Called Recursively? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions PL/SQL allows sub procedures or functions to be called recursively. The tutorial example below shows you how to calculate factorial values with a recursive sub function: SQL> CREATE...
2007-04-25, 6931👍, 0💬

How To Select All Columns of All Rows from a Table
How To Select All Columns of All Rows from a Table? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements The simplest query statement is the one that selects all columns of all rows from a table: "SELECT * FROM table_name;". The (*) in the SELECT clause tells the query to return all columns....
2007-04-21, 6560👍, 0💬

How To View Existing Locks on the Database
How To View Existing Locks on the Database? - Oracle DBA FAQ - Understanding SQL Transaction Management As can see from the pervious tutorial exercise, performance of the second session is greatly affected by the data lock created on the database. To maintain a good performance level for all session...
2007-04-17, 6510👍, 0💬

How To Save Query Output to a Local File
How To Save Query Output to a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" comman...
2007-04-29, 6492👍, 0💬

What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - Oracle DBA FAQ - Understanding SQL Basics Both CHAR and NCHAR are fixed length character data types. But they have the following differences: CHAR's size is specified in bytes by default. NCHAR's size is specified in characters by default. A charact...
2016-06-25, 6478👍, 0💬

What Are Transaction Isolation Levels Supported by Oracle
What Are Transaction Isolation Levels Supported by Oracle? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle supports two transaction isolation levels: READ COMMITTED (the default option). If the transaction contains DML that requires row locks held by another transaction, then the ...
2007-04-17, 6304👍, 0💬

< 1 2 3 4 5 6 7 > >>   Sort: Date