770 + Interview Questions in Oracle Interview Questions in Oracle Tutorial Page 2 InterviewSolution

51.	How To Define A Cursor Variable?
Answer» 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 your own generic REF CURSOR type using the TYPE ... statement. Use the SYSTEM defined REF CURSOR type: SYS_REFCURSOR. The follwoing tutorial exercise DEFINES 3 cursor variables in 3 different ways: CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; TYPE any_ref IS REF CURSOR; emp_cur emp_ref; any_cur any_ref; sys_cur SYS_REFCURSOR; BEGIN NULL; END; / 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: The follwoing tutorial exercise defines 3 cursor variables in 3 different ways:

51.

How To Define A Cursor Variable?

Answer»

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 your own generic REF CURSOR type using the TYPE ... statement.
Use the SYSTEM defined REF CURSOR type: SYS_REFCURSOR.

The follwoing tutorial exercise DEFINES 3 cursor variables in 3 different ways:

CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; TYPE any_ref IS REF CURSOR; emp_cur emp_ref; any_cur any_ref; sys_cur SYS_REFCURSOR; BEGIN NULL; END; /

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:

The follwoing tutorial exercise defines 3 cursor variables in 3 different ways:

Discussion

52.	How To Open A Cursor Variable?
Answer» A CURSOR variable must be opened with a specific query statement before you can fetch DATA fields from its data rows. To OPEN a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise: CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; TYPE any_ref IS REF CURSOR; emp_cur emp_ref; any_cur any_ref; sys_cur SYS_REFCURSOR; BEGIN OPEN emp_cur FOR SELECT * FROM employees; OPEN any_cur FOR SELECT * FROM employees; OPEN sys_cur FOR SELECT * FROM employees; CLOSE sys_cur; CLOSE any_cur; CLOSE emp_cur; END; / A cursor variable must be opened with a specific query statement before you can fetch data fields from its data rows. To open a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise:

52.

How To Open A Cursor Variable?

Answer»

A CURSOR variable must be opened with a specific query statement before you can fetch DATA fields from its data rows. To OPEN a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise:

CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; TYPE any_ref IS REF CURSOR; emp_cur emp_ref; any_cur any_ref; sys_cur SYS_REFCURSOR; BEGIN OPEN emp_cur FOR SELECT * FROM employees; OPEN any_cur FOR SELECT * FROM employees; OPEN sys_cur FOR SELECT * FROM employees; CLOSE sys_cur; CLOSE any_cur; CLOSE emp_cur; END; /

A cursor variable must be opened with a specific query statement before you can fetch data fields from its data rows. To open a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise:

Discussion

53.	How To Loop Through A Cursor Variable?
Answer» Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample SCRIPT shows you how to loop through a cursor variable: CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; emp_cur emp_ref; emp_rec employees%ROWTYPE; BEGIN OPEN emp_cur FOR SELECT * FROM employees WHERE manager_id = 101; LOOP FETCH emp_cur INTO emp_rec; EXIT WHEN emp_cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE('NAME = ' \|\| emp_rec.first_name \|\| ' ' \|\| emp_rec.last_name); END LOOP; CLOSE emp_cur; END; / Name = Nancy Greenberg Name = JENNIFER Whalen Name = Susan Mavris Name = Hermann Baer Name = SHELLEY Higgins Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample script shows you how to loop through a cursor variable:

53.

How To Loop Through A Cursor Variable?

Answer»

Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample SCRIPT shows you how to loop through a cursor variable:

CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; emp_cur emp_ref; emp_rec employees%ROWTYPE; BEGIN OPEN emp_cur FOR SELECT * FROM employees WHERE manager_id = 101; LOOP FETCH emp_cur INTO emp_rec; EXIT WHEN emp_cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE('NAME = ' || emp_rec.first_name || ' ' || emp_rec.last_name); END LOOP; CLOSE emp_cur; END; / Name = Nancy Greenberg Name = JENNIFER Whalen Name = Susan Mavris Name = Hermann Baer Name = SHELLEY Higgins

Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample script shows you how to loop through a cursor variable:

Discussion

54.	How To Pass A Cursor Variable To A Procedure?
Answer» A cursor variable can be passed into a procedure like a NORMAL variable. The sample script below gives you a good example: CREATE OR REPLACE PROCEDURE FYI_CENTER AS sys_cur SYS_REFCURSOR; PROCEDURE emp_print(cur SYS_REFCURSOR) AS emp_rec employees%ROWTYPE; BEGIN LOOP FETCH cur INTO emp_rec; EXIT WHEN cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE('Name = ' \|\| emp_rec.first_name \|\| ' ' \|\| emp_rec.last_name); END LOOP; END; BEGIN OPEN sys_cur FOR SELECT * FROM employees WHERE manager_id = 101; emp_print(sys_cur); CLOSE sys_cur; END; / Name = NANCY Greenberg Name = Jennifer Whalen Name = Susan Mavris Name = Hermann BAER Name = Shelley Higgins A cursor variable can be passed into a procedure like a normal variable. The sample script below gives you a good example:

54.

How To Pass A Cursor Variable To A Procedure?

Answer»

A cursor variable can be passed into a procedure like a NORMAL variable. The sample script below gives you a good example:

CREATE OR REPLACE PROCEDURE FYI_CENTER AS sys_cur SYS_REFCURSOR; PROCEDURE emp_print(cur SYS_REFCURSOR) AS emp_rec employees%ROWTYPE; BEGIN LOOP FETCH cur INTO emp_rec; EXIT WHEN cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE('Name = ' || emp_rec.first_name || ' ' || emp_rec.last_name); END LOOP; END; BEGIN OPEN sys_cur FOR SELECT * FROM employees WHERE manager_id = 101; emp_print(sys_cur); CLOSE sys_cur; END; / Name = NANCY Greenberg Name = Jennifer Whalen Name = Susan Mavris Name = Hermann BAER Name = Shelley Higgins

A cursor variable can be passed into a procedure like a normal variable. The sample script below gives you a good example:

Discussion

55.	Why Cursor Variables Are Easier To Use Than Cursors?
Answer» Cursor VARIABLES are easier to use than cursors because: Cursor variables are easier to define. No need to give a specific QUERY statement. Cursor variables are easier to open. You can specify the query dynamically at the TIME of open. Cursor variables can be passed into procedures or FUNCTIONS. Cursor variables are easier to use than cursors because:

55.

Why Cursor Variables Are Easier To Use Than Cursors?

Answer»

Cursor VARIABLES are easier to use than cursors because:

Cursor variables are easier to define. No need to give a specific QUERY statement.
Cursor variables are easier to open. You can specify the query dynamically at the TIME of open.
Cursor variables can be passed into procedures or FUNCTIONS.

Cursor variables are easier to use than cursors because:

Discussion

56.	What Is The Simplest Tool To Run Commands On Oracle Servers?
Answer» The SIMPLEST tool to connect to an Oracle server and run commands to MANAGE data is SQLPlus. It is an Oracle database CLIENT tool that works as a command-line user interface to the database server. SQLPlus allows you: Format, perform calculations on, store, and print from query results. Examine table and object definitions. Develop and run BATCH scripts. Perform database administration. The simplest tool to connect to an Oracle server and run commands to manage data is SQLPlus. It is an Oracle database client tool that works as a command-line user interface to the database server. SQLPlus allows you:

56.

What Is The Simplest Tool To Run Commands On Oracle Servers?

Answer»

The SIMPLEST tool to connect to an Oracle server and run commands to MANAGE data is SQL*Plus. It is an Oracle database CLIENT tool that works as a command-line user interface to the database server. SQL*Plus allows you:

Format, perform calculations on, store, and print from query results.
Examine table and object definitions.
Develop and run BATCH scripts.
Perform database administration.

The simplest tool to connect to an Oracle server and run commands to manage data is SQL*Plus. It is an Oracle database client tool that works as a command-line user interface to the database server. SQL*Plus allows you:

Discussion

57.	What Is A Sql*loader Control File?
Answer» A SQLLOADER control file a text that defines how DATA files should be loaded into the database. It allows you to specify: Where is the input data file. The FORMAT of the input date file. The TARGET table where the data should be loaded. How input data fields should be mapped to target table columns. Select criteria to select input records for LOADING. Where to output errors. A SQLLoader control file a text that defines how data files should be loaded into the database. It allows you to specify:

57.

What Is A Sql*loader Control File?

Answer»

A SQL*LOADER control file a text that defines how DATA files should be loaded into the database. It allows you to specify:

Where is the input data file.
The FORMAT of the input date file.
The TARGET table where the data should be loaded.
How input data fields should be mapped to target table columns.
Select criteria to select input records for LOADING.
Where to output errors.

A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify:

Discussion

58.	What Is An External Table?
Answer» An external table is a table defined in the database with DATA stored OUTSIDE the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data ACCESS drivers. Currently, Oracle SUPPORTS two data access drivers: ORACLE_LOADER and ORACLE_DATAPUMP. External tables can be used to LOAD data from external files into database, or unload data from database to external files. An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access drivers. Currently, Oracle supports two data access drivers: ORACLE_LOADER and ORACLE_DATAPUMP. External tables can be used to load data from external files into database, or unload data from database to external files.

58.

What Is An External Table?

Answer»

An external table is a table defined in the database with DATA stored OUTSIDE the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data ACCESS drivers. Currently, Oracle SUPPORTS two data access drivers: ORACLE_LOADER and ORACLE_DATAPUMP.

External tables can be used to LOAD data from external files into database, or unload data from database to external files.

An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access drivers. Currently, Oracle supports two data access drivers: ORACLE_LOADER and ORACLE_DATAPUMP.

External tables can be used to load data from external files into database, or unload data from database to external files.

Discussion

59.	How To Load Data Through External Tables?
Answer» If you have data STORED in external files, you can load it to DATABASE through an external table by the steps below: CREATE an external table with columns matching data fields in the external file. Create a regular table with the same columns. Run an INSERT INTO ... SELECT statement to load data from the external file to the regular table through the external table. If you have data stored in external files, you can load it to database through an external table by the steps below:

59.

How To Load Data Through External Tables?

Answer»

If you have data STORED in external files, you can load it to DATABASE through an external table by the steps below:

CREATE an external table with columns matching data fields in the external file.
Create a regular table with the same columns.
Run an INSERT INTO ... SELECT statement to load data from the external file to the regular table through the external table.

If you have data stored in external files, you can load it to database through an external table by the steps below:

Discussion

60.	What Are The Restrictions On External Table Columns?
Answer» When creating external table COLUMNS, you NEED to watch out some RESTRICTIONS: "PRIMARY KEY" is not allowed. "NOT NULL" is not allowed. "DEFAULT value" is not allowed. When creating external table columns, you need to watch out some restrictions:

60.

What Are The Restrictions On External Table Columns?

Answer»

When creating external table COLUMNS, you NEED to watch out some RESTRICTIONS:

"PRIMARY KEY" is not allowed.
"NOT NULL" is not allowed.
"DEFAULT value" is not allowed.

When creating external table columns, you need to watch out some restrictions:

Discussion

61.	What Is A Directory Object?
Answer» A directory object is a logical alias for a physical directory PATH name on the operating system. Directory OBJECTS can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good EXAMPLES: >sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> CREATE DIRECTORY test_dir AS '/oraclexe/test'; Directory created. SQL> GRANT READ ON DIRECTORY test_dir TO hr; Grant succeeded. SQL> GRANT WRITE ON DIRECTORY test_dir TO hr; Grant succeeded. SQL> CREATE DIRECTORY temp_dir AS '/oraclexe/temp'; Directory created. SQL> DROP DIRECTORY temp_dir; Directory dropped. A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples:

61.

What Is A Directory Object?

Answer»

A directory object is a logical alias for a physical directory PATH name on the operating system. Directory OBJECTS can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good EXAMPLES:

>sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> CREATE DIRECTORY test_dir AS '/oraclexe/test'; Directory created. SQL> GRANT READ ON DIRECTORY test_dir TO hr; Grant succeeded. SQL> GRANT WRITE ON DIRECTORY test_dir TO hr; Grant succeeded. SQL> CREATE DIRECTORY temp_dir AS '/oraclexe/temp'; Directory created. SQL> DROP DIRECTORY temp_dir; Directory dropped.

A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples:

Discussion

62.	What Is The Data Pump Export Utility?
Answer» Oracle DATA Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded there. The dump file set is made up of ONE or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format. During an import operation, the Data Pump Import utility uses these files to LOCATE each database object in the dump file set. Because the dump files are written by the server, rather than by the CLIENT, the data BASE administrator (DBA) must create directory objects. Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded there. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format. During an import operation, the Data Pump Import utility uses these files to locate each database object in the dump file set. Because the dump files are written by the server, rather than by the client, the data base administrator (DBA) must create directory objects.

62.

What Is The Data Pump Export Utility?

Answer»

Oracle DATA Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility.

The dump file set can be imported on the same system or it can be moved to another system and loaded there. The dump file set is made up of ONE or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format. During an import operation, the Data Pump Import utility uses these files to LOCATE each database object in the dump file set. Because the dump files are written by the server, rather than by the CLIENT, the data BASE administrator (DBA) must create directory objects.

Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility.

The dump file set can be imported on the same system or it can be moved to another system and loaded there. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format. During an import operation, the Data Pump Import utility uses these files to locate each database object in the dump file set. Because the dump files are written by the server, rather than by the client, the data base administrator (DBA) must create directory objects.

Discussion

63.	What Is The Data Pump Import Utility?
Answer» Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the Data Pump Export utility. Import can also be used to load a target database directly from a source database with no INTERVENING dump files. This allows export and import operations to RUN concurrently, MINIMIZING total elapsed time. This is KNOWN as a network import. Data Pump Import enables you to specify whether a job should move a subset of the data and metadata from the dump file set or the source database (in the case of a network import), as determined by the import mode. This is done using data filters and metadata filters, which are implemented through Import commands. Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the Data Pump Export utility. Import can also be used to load a target database directly from a source database with no intervening dump files. This allows export and import operations to run concurrently, minimizing total elapsed time. This is known as a network import. Data Pump Import enables you to specify whether a job should move a subset of the data and metadata from the dump file set or the source database (in the case of a network import), as determined by the import mode. This is done using data filters and metadata filters, which are implemented through Import commands.

63.

What Is The Data Pump Import Utility?

Answer»

Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the Data Pump Export utility. Import can also be used to load a target database directly from a source database with no INTERVENING dump files. This allows export and import operations to RUN concurrently, MINIMIZING total elapsed time. This is KNOWN as a network import.

Data Pump Import enables you to specify whether a job should move a subset of the data and metadata from the dump file set or the source database (in the case of a network import), as determined by the import mode. This is done using data filters and metadata filters, which are implemented through Import commands.

Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the Data Pump Export utility. Import can also be used to load a target database directly from a source database with no intervening dump files. This allows export and import operations to run concurrently, minimizing total elapsed time. This is known as a network import.

Data Pump Import enables you to specify whether a job should move a subset of the data and metadata from the dump file set or the source database (in the case of a network import), as determined by the import mode. This is done using data filters and metadata filters, which are implemented through Import commands.

Discussion

64.	What Are Data Pump Export And Import Modes?
Answer» 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. Use the FULL parameter to specify this mode. Schema: Enables you to export and import all OBJECTS that belong to a schema. Use the SCHEMAS parameter to specify this mode. This is the default mode. Table: Enables you to export and import specific tables and partitions. Use the TABLES parameter to specify this mode. Tablespace: Enables a PRIVILEGED user to move a set of tablespaces from one Oracle database to another. Use the TABLESPACES parameter to specify this mode. Tablespace: Enables a privileged user to move metadata from the tables within a specified set of tablespaces from one Oracle database to another. Use the TRANSPORT_TABLESPACES parameter to specify this mode. 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:

64.

What Are Data Pump Export And Import Modes?

Answer»

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. Use the FULL parameter to specify this mode.
Schema: Enables you to export and import all OBJECTS that belong to a schema. Use the SCHEMAS parameter to specify this mode. This is the default mode.
Table: Enables you to export and import specific tables and partitions. Use the TABLES parameter to specify this mode.
Tablespace: Enables a PRIVILEGED user to move a set of tablespaces from one Oracle database to another. Use the TABLESPACES parameter to specify this mode.
Tablespace: Enables a privileged user to move metadata from the tables within a specified set of tablespaces from one Oracle database to another. Use the TRANSPORT_TABLESPACES parameter to specify this mode.

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:

Discussion

65.	How To Export Several Tables Together?
Answer» If you don't want to export the entire schema and only want to export several TABLES only, you can use the "expdp" COMMAND with the "TABLES" parameter as shown in the following tutorial exercise: >cd oraclexeapporacleproduct10.2.0serverBIN >expdp hr/fyicenter TABLES=employees,departments DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Starting "HR"."SYS_EXPORT_TABLE_01": hr/****** TABLES=employees,departments DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Estimate in progress using BLOCKS method... Processing OBJECT type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 128 KB Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CON... Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTI... Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF... Processing object type TABLE_EXPORT/TABLE/TRIGGER Processing object type TABLE_EXPORT/TABLE/STATISTICS/TAB... . . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows . . exported "HR"."EMPLOYEES" 15.76 KB 107 rows Master table "HR"."SYS_EXPORT_TABLE_01" loaded/unloaded ********************************************************* Dump FILE set for HR.SYS_EXPORT_TABLE_01 is: C:ORACLEXEHR_DUMPTABLES.DMP Job "HR"."SYS_EXPORT_TABLE_01" successfully completed. If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise:

65.

How To Export Several Tables Together?

Answer»

If you don't want to export the entire schema and only want to export several TABLES only, you can use the "expdp" COMMAND with the "TABLES" parameter as shown in the following tutorial exercise:

>cd oraclexeapporacleproduct10.2.0serverBIN >expdp hr/fyicenter TABLES=employees,departments DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Starting "HR"."SYS_EXPORT_TABLE_01": hr/******** TABLES=employees,departments DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Estimate in progress using BLOCKS method... Processing OBJECT type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 128 KB Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CON... Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTI... Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF... Processing object type TABLE_EXPORT/TABLE/TRIGGER Processing object type TABLE_EXPORT/TABLE/STATISTICS/TAB... . . exported "HR"."DEPARTMENTS" 6.632 KB 27 rows . . exported "HR"."EMPLOYEES" 15.76 KB 107 rows Master table "HR"."SYS_EXPORT_TABLE_01" loaded/unloaded *********************************************************** Dump FILE set for HR.SYS_EXPORT_TABLE_01 is: C:ORACLEXEHR_DUMPTABLES.DMP Job "HR"."SYS_EXPORT_TABLE_01" successfully completed.

If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise:

Discussion

66.	What Happens If The Imported Table Already Exists?
Answer» If the import process TRIES to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following EXERCISE SHOWS you a good example: &GT;CD oraclexeapporacleproduct10.2.0serverBIN >impdp hr/fyicenter TABLES=employees DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Master table "HR"."SYS_IMPORT_TABLE_01" loaded/unloaded Starting "HR"."SYS_IMPORT_TABLE_01": hr/** TABLES=employees DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Processing object type TABLE_EXPORT/TABLE/TABLE ORA-39151: Table "HR"."EMPLOYEES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example:

66.

What Happens If The Imported Table Already Exists?

Answer»

If the import process TRIES to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following EXERCISE SHOWS you a good example:

&GT;CD oraclexeapporacleproduct10.2.0serverBIN >impdp hr/fyicenter TABLES=employees DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Master table "HR"."SYS_IMPORT_TABLE_01" loaded/unloaded Starting "HR"."SYS_IMPORT_TABLE_01": hr/** TABLES=employees DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log Processing object type TABLE_EXPORT/TABLE/TABLE ORA-39151: Table "HR"."EMPLOYEES" exists. All dependent metadata and data will be skipped due to table_exists_action of skip Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example:

Discussion

67.	How To Import One Table Back From A Dump File?
Answer» If you only want to import ONE table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following TUTORIAL exercise shows you how to import the "fyi_links" table from a dump file created by a schema export: &GT;cd oraclexeapporacleproduct10.2.0serverBIN >sqlplus /nolog SQL> connect HR/fyicenter SQL> DROP TABLE fyi_links; Table dropped. SQL> exit; >impdp hr/fyicenter TABLES=fyi_links DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=tables.log Master table "HR"."SYS_IMPORT_TABLE_01" loaded/unloaded STARTING "HR"."SYS_IMPORT_TABLE_01": hr/** TABLES=fyi_links DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=tables.log Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "HR"."FYI_LINKS" 6.375 KB 4 rows Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CON... Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTI... Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TAB... Job "HR"."SYS_IMPORT_TABLE_01" successfully completed. If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file created by a schema export:

67.

How To Import One Table Back From A Dump File?

Answer»

If you only want to import ONE table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following TUTORIAL exercise shows you how to import the "fyi_links" table from a dump file created by a schema export:

&GT;cd oraclexeapporacleproduct10.2.0serverBIN >sqlplus /nolog SQL> connect HR/fyicenter SQL> DROP TABLE fyi_links; Table dropped. SQL> exit; >impdp hr/fyicenter TABLES=fyi_links DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=tables.log Master table "HR"."SYS_IMPORT_TABLE_01" loaded/unloaded STARTING "HR"."SYS_IMPORT_TABLE_01": hr/** TABLES=fyi_links DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=tables.log Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "HR"."FYI_LINKS" 6.375 KB 4 rows Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CON... Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTI... Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TAB... Job "HR"."SYS_IMPORT_TABLE_01" successfully completed.

If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file created by a schema export:

Discussion

68.	What Are The Original Export And Import Utilities?
Answer» Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and SOFTWARE configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file. An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different SITE. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a NETWORK. The files can also be used as backups in addition to NORMAL backup procedures. Export and Import utilities are now being REPLACED by Data Pump Export and Import utilities in Oracle 10g. But you can still use them. Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file. An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures. Export and Import utilities are now being replaced by Data Pump Export and Import utilities in Oracle 10g. But you can still use them.

68.

What Are The Original Export And Import Utilities?

Answer»

Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and SOFTWARE configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file.

An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different SITE. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a NETWORK. The files can also be used as backups in addition to NORMAL backup procedures.

Export and Import utilities are now being REPLACED by Data Pump Export and Import utilities in Oracle 10g. But you can still use them.

Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file.

An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.

Export and Import utilities are now being replaced by Data Pump Export and Import utilities in Oracle 10g. But you can still use them.

Discussion

69.	What Is Open Database Communication (odbc)?
Answer» ODBC, OPEN Database Communication, a standard API (APPLICATION program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle OFFERS ODBC DRIVERS to allow Windows applications to connect Oracle server through ODBC. ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect Oracle server through ODBC.

69.

What Is Open Database Communication (odbc)?

Answer»

ODBC, OPEN Database Communication, a standard API (APPLICATION program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle OFFERS ODBC DRIVERS to allow Windows applications to connect Oracle server through ODBC.

ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect Oracle server through ODBC.

Discussion

70.	How Can Windows Applications Connect To Oracle Servers?
Answer» A Windows application can connect to an Oracle server directly, if it KNOWS how to use the Oracle TNS technology. A Windows application can connect to an Oracle server indirectly through Windows ODBC MANAGER, becaused offers ODBC drivers to SUPPORT the ODBC API. The diagram below shows how MS Access can connect to an Oracle server through the ODBC driver: A Windows application can connect to an Oracle server directly, if it knows how to use the Oracle TNS technology. A Windows application can connect to an Oracle server indirectly through Windows ODBC manager, becaused offers ODBC drivers to support the ODBC API. The diagram below shows how MS Access can connect to an Oracle server through the ODBC driver:

70.

How Can Windows Applications Connect To Oracle Servers?

Answer»

A Windows application can connect to an Oracle server directly, if it KNOWS how to use the Oracle TNS technology. A Windows application can connect to an Oracle server indirectly through Windows ODBC MANAGER, becaused offers ODBC drivers to SUPPORT the ODBC API. The diagram below shows how MS Access can connect to an Oracle server through the ODBC driver:

A Windows application can connect to an Oracle server directly, if it knows how to use the Oracle TNS technology. A Windows application can connect to an Oracle server indirectly through Windows ODBC manager, becaused offers ODBC drivers to support the ODBC API. The diagram below shows how MS Access can connect to an Oracle server through the ODBC driver:

Discussion

71.	How To Create Tables For Odbc Connection Testing?
Answer» If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL&GT; CONNECT system/retneciyf Connected. SQL> CREATE USER fyi IDENTIFIED BY retneciyf ACCOUNT UNLOCK; User created. SQL> GRANT CREATE SESSION TO fyi; Grant succeeded. SQL> GRANT CREATE TABLE TO fyi; Grant succeeded. SQL> ALTER USER fyi DEFAULT TABLESPACE USERS; 85 User altered. SQL> ALTER USER dev QUOTA 4M ON USERS; User altered. SQL> connect fyi/retneciyf; Connected. SQL> CREATE TABLE dev_faq (id NUMBER); SQL> INSERT INTO dev_faq VALUES (3); SQL> INSERT INTO dev_faq VALUES (5); SQL> INSERT INTO dev_faq VALUES (7); If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here:

71.

How To Create Tables For Odbc Connection Testing?

Answer»

If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here:

SQL&GT; CONNECT system/retneciyf Connected. SQL> CREATE USER fyi IDENTIFIED BY retneciyf ACCOUNT UNLOCK; User created. SQL> GRANT CREATE SESSION TO fyi; Grant succeeded. SQL> GRANT CREATE TABLE TO fyi; Grant succeeded. SQL> ALTER USER fyi DEFAULT TABLESPACE USERS; 85 User altered. SQL> ALTER USER dev QUOTA 4M ON USERS; User altered. SQL> connect fyi/retneciyf; Connected. SQL> CREATE TABLE dev_faq (id NUMBER); SQL> INSERT INTO dev_faq VALUES (3); SQL> INSERT INTO dev_faq VALUES (5); SQL> INSERT INTO dev_faq VALUES (7);

If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here:

Discussion

72.	How To Check The Oracle Tns Settings?
Answer» If you have installed an ORACLE SERVER or an Oracle CLIENT tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers. For example, if you have Oracle XE server installed, you will have the tnsnames.ora located at oraclexeapporacleproduct10.2.0serverNETWORKADMIN. It should contain a connect identifier called XE defined as: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost) (PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers. For example, if you have Oracle XE server installed, you will have the tnsnames.ora located at oraclexeapporacleproduct10.2.0serverNETWORKADMIN. It should contain a connect identifier called XE defined as:

72.

How To Check The Oracle Tns Settings?

Answer»

If you have installed an ORACLE SERVER or an Oracle CLIENT tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers.

For example, if you have Oracle XE server installed, you will have the tnsnames.ora located at
oraclexeapporacleproduct10.2.0serverNETWORKADMIN. It should contain a connect identifier called XE defined as:

XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost) (PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )

If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers.

For example, if you have Oracle XE server installed, you will have the tnsnames.ora located at
oraclexeapporacleproduct10.2.0serverNETWORKADMIN. It should contain a connect identifier called XE defined as:

Discussion

73.	How To Connect Asp Pages To Oracle Servers?
Answer» How To Connect ASP Pages to Oracle Servers? If you are running WINDOWS IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC DRIVERS. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web server. Then you can USE ADODB objects to connect to the Oracle server over the ODBC driver in your ASP pages. The tutorial example below gives you a good example: <% Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "DSN=FYI_DSN;UID=fyi;PWD=retneciyf" Set oRS = oConn.Execute("SELECT * FROM dev_faq") Response.write("<p&GT;Data from Oracle server via ODBC:") Response.write("<pre>") Do While NOT oRS.EOF Response.Write(oRS("ID") & vbcrlf) oRS.MoveNext Loop Response.write("</pre>") oRS.close oConn.close %> How To Connect ASP Pages to Oracle Servers? If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web server. Then you can use ADODB objects to connect to the Oracle server over the ODBC driver in your ASP pages. The tutorial example below gives you a good example:

73.

How To Connect Asp Pages To Oracle Servers?

Answer»

How To Connect ASP Pages to Oracle Servers? If you are running WINDOWS IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC DRIVERS. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web server.

Then you can USE ADODB objects to connect to the Oracle server over the ODBC driver in your ASP pages. The tutorial example below gives you a good example:

<% Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "DSN=FYI_DSN;UID=fyi;PWD=retneciyf" Set oRS = oConn.Execute("SELECT * FROM dev_faq") Response.write("<p&GT;Data from Oracle server via ODBC:") Response.write("<pre>") Do While NOT oRS.EOF Response.Write(oRS("ID") & vbcrlf) oRS.MoveNext Loop Response.write("</pre>") oRS.close oConn.close %>

How To Connect ASP Pages to Oracle Servers? If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web server.

Then you can use ADODB objects to connect to the Oracle server over the ODBC driver in your ASP pages. The tutorial example below gives you a good example:

Discussion

74.	What Is A Database Instance? Explain?
Answer» A database instance (Server) is a set of MEMORY structure and BACKGROUND processes that access a set of database files. The processes can be shared by all of the users. The memory structure that is used to STORE the most QUERIED data from database. This helps up to improve database performance by decreasing the AMOUNT of I/O performed against data file. A database instance (Server) is a set of memory structure and background processes that access a set of database files. The processes can be shared by all of the users. The memory structure that is used to store the most queried data from database. This helps up to improve database performance by decreasing the amount of I/O performed against data file.

74.

What Is A Database Instance? Explain?

Answer»

A database instance (Server) is a set of MEMORY structure and BACKGROUND processes that access a set of database files. The processes can be shared by all of the users.

The memory structure that is used to STORE the most QUERIED data from database. This helps up to improve database performance by decreasing the AMOUNT of I/O performed against data file.

A database instance (Server) is a set of memory structure and background processes that access a set of database files. The processes can be shared by all of the users.

The memory structure that is used to store the most queried data from database. This helps up to improve database performance by decreasing the amount of I/O performed against data file.

Discussion

75.	What Is A Deadlock? Explain?
Answer» Two processes waiting to UPDATE the rows of a table, which are LOCKED by other processes then deadlock arises. In a database environment this will often HAPPEN because of not ISSUING the proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically. These locks will be released AUTOMATICALLY when a commit/rollback operation performed or any one of this processes being killed externally. Two processes waiting to update the rows of a table, which are locked by other processes then deadlock arises. In a database environment this will often happen because of not issuing the proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically. These locks will be released automatically when a commit/rollback operation performed or any one of this processes being killed externally.

75.

What Is A Deadlock? Explain?

Answer»

Two processes waiting to UPDATE the rows of a table, which are LOCKED by other processes then deadlock arises.

In a database environment this will often HAPPEN because of not ISSUING the proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically.

These locks will be released AUTOMATICALLY when a commit/rollback operation performed or any one of this processes being killed externally.

Two processes waiting to update the rows of a table, which are locked by other processes then deadlock arises.

In a database environment this will often happen because of not issuing the proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically.

These locks will be released automatically when a commit/rollback operation performed or any one of this processes being killed externally.

Discussion

76.	What Is The Fastest Way Of Accessing A Row In A Table?
Answer» USING ROWID, CONSTRAINTS. Using ROWID, CONSTRAINTS.

76.

What Is The Fastest Way Of Accessing A Row In A Table?

Answer»

USING ROWID, CONSTRAINTS.

Using ROWID, CONSTRAINTS.

Discussion

77.	How Do You Implement One-to-one, One-to-many And Many-to-many Relationships While Designing Tables?
Answer» One-to-One relationship can be implemented as a single table and rarely as two tables with PRIMARY and foreign key relationships. One-to-Many relationships are implemented by SPLITTING the DATA into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables FORMING the composite primary key of the junction table. One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

77.

How Do You Implement One-to-one, One-to-many And Many-to-many Relationships While Designing Tables?

Answer»

One-to-One relationship can be implemented as a single table and rarely as two tables with PRIMARY and foreign key relationships.

One-to-Many relationships are implemented by SPLITTING the DATA into two tables with primary key and foreign key relationships.

Many-to-Many relationships are implemented using a junction table with the keys from both the tables FORMING the composite primary key of the junction table.

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.

One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.

Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Discussion

78.	Switch To Dos Prompt?
Answer» SQL&GT; HOST. SQL> host.

78.

Switch To Dos Prompt?

Answer»

SQL&GT; HOST.

SQL> host.

Discussion

79.	To See Current User Name?
Answer» SQL&GT; SHOW USER. Sql> show user.

79.

To See Current User Name?

Answer»

SQL&GT; SHOW USER.

Sql> show user.

Discussion

80.	Do You Know What Are User Profiles In Apps. Any Examples You Can Give?
Answer» User Profile : It is a SET of changeable options through which your application runs.User profile can be DEFINED at VARIOUS LEVELS. They are: System. Application. RESPONSIBILITY. User. User Profile : It is a set of changeable options through which your application runs.User profile can be defined at various levels. They are:

80.

Do You Know What Are User Profiles In Apps. Any Examples You Can Give?

Answer»

User Profile : It is a SET of changeable options through which your application runs.User profile can be DEFINED at VARIOUS LEVELS. They are:

System.
Application.
RESPONSIBILITY.
User.

User Profile : It is a set of changeable options through which your application runs.User profile can be defined at various levels. They are:

Discussion

81.	How Many Concurrent Programs You Have Customized, Can You Name Some Of Them?
Answer» Have to SEE the standra REPORTS and POSSIBLE CUSTOMIZATIONS. Have to see the standra reports and possible customizations.

81.

How Many Concurrent Programs You Have Customized, Can You Name Some Of Them?

Answer»

Have to SEE the standra REPORTS and POSSIBLE CUSTOMIZATIONS.

Have to see the standra reports and possible customizations.

Discussion

82.	How To Make The Project As .exe File In Oracle Forms & Reports(d2k)?
Answer» Developer/2000 doesn't MAKE exe files. Think of your Dev 2k project like an access database, you DEVELOP the forms and REPORTS and then when you deploy them you also install the Forms & Reports Runtimes on the clients MACHINE. Forms, when compiled have the .fmx extension as opposed to the normal .fmb extension. Developer/2000 doesn't make .exe files. Developer/2000 doesn't make exe files. Think of your Dev 2k project like an access database, you develop the forms and reports and then when you deploy them you also install the Forms & Reports Runtimes on the clients machine. Forms, when compiled have the .fmx extension as opposed to the normal .fmb extension. Developer/2000 doesn't make .exe files.

82.

How To Make The Project As .exe File In Oracle Forms & Reports(d2k)?

Answer»

Developer/2000 doesn't MAKE exe files. Think of your Dev 2k project like an access database, you DEVELOP the forms and REPORTS and then when you deploy them you also install the Forms & Reports Runtimes on the clients MACHINE. Forms, when compiled have the *.fmx extension as opposed to the normal *.fmb extension.

Developer/2000 doesn't make .exe files.

Developer/2000 doesn't make exe files. Think of your Dev 2k project like an access database, you develop the forms and reports and then when you deploy them you also install the Forms & Reports Runtimes on the clients machine. Forms, when compiled have the *.fmx extension as opposed to the normal *.fmb extension.

Developer/2000 doesn't make .exe files.

Discussion

83.	Do You Know What Is Applysys In Oracle Application Database Schema, What Is Apps?
Answer» Applsys is a SCHEMA as APPS and applsyspub.this schema contains the INFORMATION about the FND or forndation tables. Applsys is a schema as apps and applsyspub.this schema contains the information about the FND or forndation tables.

83.

Do You Know What Is Applysys In Oracle Application Database Schema, What Is Apps?

Answer»

Applsys is a SCHEMA as APPS and applsyspub.this schema contains the INFORMATION about the FND or forndation tables.

Applsys is a schema as apps and applsyspub.this schema contains the information about the FND or forndation tables.

Discussion

84.	Which Flexfields You Have Customized?
Answer» CLIENT can CUSTOMIZE DESCRIPTIVE FLEX FIELDS. Client can customize Descriptive Flex Fields.

84.

Which Flexfields You Have Customized?

Answer»

CLIENT can CUSTOMIZE DESCRIPTIVE FLEX FIELDS.

Client can customize Descriptive Flex Fields.

Discussion

85.	How I Can Use Srw.run_report In Reports6i?
Answer» You can USE srw.run_report as followssrw.run_report('module=modulename.rdf destype= SCREEN paramform= YES'); You can use srw.run_report as followssrw.run_report('module=modulename.rdf destype= screen paramform= yes');

85.

How I Can Use Srw.run_report In Reports6i?

Answer»

You can USE srw.run_report as followssrw.run_report('module=modulename.rdf destype= SCREEN paramform= YES');

You can use srw.run_report as followssrw.run_report('module=modulename.rdf destype= screen paramform= yes');

Discussion

86.	What Is The Placeholder Column? What Is The Format Trigger?
Answer» A placeholder column is used to hold the value of certain calculation or a VARIABLE that is being carried out in a formula column. A place holder can be DEFINED as anumber, character or date TYPE, depending upon the type of value which will be stored into it. A format trigger is used when we want to display a particular field, if certain conditions are met. A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, depending upon the type of value which will be stored into it. A format trigger is used when we want to display a particular field, if certain conditions are met.

86.

What Is The Placeholder Column? What Is The Format Trigger?

Answer»

A placeholder column is used to hold the value of certain calculation or a VARIABLE that is being carried out in a formula column. A place holder can be DEFINED as anumber, character or date TYPE, depending upon the type of value which will be stored into it.

A format trigger is used when we want to display a particular field, if certain conditions are met.

A placeholder column is used to hold the value of certain calculation or a variable that is being carried out in a formula column. A place holder can be defined as anumber, character or date type, depending upon the type of value which will be stored into it.

A format trigger is used when we want to display a particular field, if certain conditions are met.

Discussion

87.	I Need To Run A Report At Scheduled Timings Only. I Don't Want To Run The Report On Sundays. How To Do This?
Answer» While SUBMITTING the request you can SELECT schedule button and SPECIFY Run The JOB Option On Specific Days and Select all Days except Sunday. While Submitting the request you can select schedule button and specify Run The Job Option On Specific Days and Select all Days except Sunday.

87.

I Need To Run A Report At Scheduled Timings Only. I Don't Want To Run The Report On Sundays. How To Do This?

Answer»

While SUBMITTING the request you can SELECT schedule button and SPECIFY Run The JOB Option On Specific Days and Select all Days except Sunday.

While Submitting the request you can select schedule button and specify Run The Job Option On Specific Days and Select all Days except Sunday.

Discussion

88.	What Is The Page Protect In Reports?
Answer» It indicates that whether you want to KEEP a OBJECT and its entire CONTENTS on the same logical page. Setting its PROPERTY to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page. It indicates that whether you want to keep a object and its entire contents on the same logical page. Setting its property to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page.

88.

What Is The Page Protect In Reports?

Answer»

It indicates that whether you want to KEEP a OBJECT and its entire CONTENTS on the same logical page. Setting its PROPERTY to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page.

It indicates that whether you want to keep a object and its entire contents on the same logical page. Setting its property to 'yes' if the object and its entire contents cannot fit in the page it will be moved to next logical page.

Discussion

89.	I Want To Setup Additional Organizations, Do I Have To Setup Multiorg?
Answer» No, you do not need to SETUP MULTIORG. You do not have to be multi-org to have MULTIPLE organizations only if you intend to have multiple SETS of BOOKS. No, you do not need to setup multiorg. You do not have to be multi-org to have multiple organizations only if you intend to have multiple sets of books.

89.

I Want To Setup Additional Organizations, Do I Have To Setup Multiorg?

Answer»

No, you do not need to SETUP MULTIORG. You do not have to be multi-org to have MULTIPLE organizations only if you intend to have multiple SETS of BOOKS.

No, you do not need to setup multiorg. You do not have to be multi-org to have multiple organizations only if you intend to have multiple sets of books.

Discussion

90.	What Is Multi Org Architecture?
Answer» The Multiorg Architecture is meant to ALLOW multiple companies or SUBSIDIARIES to store their records within a single database. The multiple Organization architecture allows this by partitioning data through views in the APPS SCHEMA. Multiorg also allows you to maintain multiple sets of books. Implementation of multiorg generally includes defining more than one BUSINESS GROUP. The Multiorg Architecture is meant to allow multiple companies or subsidiaries to store their records within a single database. The multiple Organization architecture allows this by partitioning data through views in the APPS schema. Multiorg also allows you to maintain multiple sets of books. Implementation of multiorg generally includes defining more than one Business Group.

90.

What Is Multi Org Architecture?

Answer»

The Multiorg Architecture is meant to ALLOW multiple companies or SUBSIDIARIES to store their records within a single database. The multiple Organization architecture allows this by partitioning data through views in the APPS SCHEMA. Multiorg also allows you to maintain multiple sets of books.

Implementation of multiorg generally includes defining more than one BUSINESS GROUP.

The Multiorg Architecture is meant to allow multiple companies or subsidiaries to store their records within a single database. The multiple Organization architecture allows this by partitioning data through views in the APPS schema. Multiorg also allows you to maintain multiple sets of books.

Implementation of multiorg generally includes defining more than one Business Group.

Discussion

91.	Give The Structure Of The Procedure?
Answer» PROCEDURE name (parameter LIST.....) is LOCAL variable declarations: BEGIN EXECUTABLE statements. Exception. exception handlers END; PROCEDURE name (parameter list.....) is local variable declarations:

91.

Give The Structure Of The Procedure?

Answer»

PROCEDURE name (parameter LIST.....) is LOCAL variable declarations:

BEGIN EXECUTABLE statements. Exception. exception handlers END;

PROCEDURE name (parameter list.....) is local variable declarations:

Discussion

92.	What Are The Two Parts Of A Procedure?
Answer» PROCEDURE SPECIFICATION and Procedure BODY. Procedure Specification and Procedure Body.

92.

What Are The Two Parts Of A Procedure?

Answer»

PROCEDURE SPECIFICATION and Procedure BODY.

Procedure Specification and Procedure Body.

Discussion

93.	What Is Pl/sql Table?
Answer» Objects of type TABLE are CALLED "PL/SQL tables", which are MODELED as (but not the same as) DATABASE tables, PL/SQL tables USE a primary PL/SQL tables can have one column and a primary key. Cursors. Objects of type TABLE are called "PL/SQL tables", which are modeled as (but not the same as) database tables, PL/SQL tables use a primary PL/SQL tables can have one column and a primary key. Cursors.

93.

What Is Pl/sql Table?

Answer»

Objects of type TABLE are CALLED "PL/SQL tables", which are MODELED as (but not the same as) DATABASE tables, PL/SQL tables USE a primary PL/SQL tables can have one column and a primary key. Cursors.

Objects of type TABLE are called "PL/SQL tables", which are modeled as (but not the same as) database tables, PL/SQL tables use a primary PL/SQL tables can have one column and a primary key. Cursors.

Discussion

94.	What Is A Cursor ? Why Cursor Is Required?
Answer» Cursor is a NAMED private SQL area from where information can be ACCESSED. Cursors are REQUIRED to process rows INDIVIDUALLY for queries returning multiple rows. Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

94.

What Is A Cursor ? Why Cursor Is Required?

Answer»

Cursor is a NAMED private SQL area from where information can be ACCESSED. Cursors are REQUIRED to process rows INDIVIDUALLY for queries returning multiple rows.

Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

Discussion

95.	Explain The Two Type Of Cursors?
Answer» There are two types of CURSORS, Implicit CURSOR and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. USER defined cursors are CALLED Explicit Cursors. They can be declared and used. There are two types of cursors, Implicit Cursor and Explicit Cursor. PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

95.

Explain The Two Type Of Cursors?

Answer»

There are two types of CURSORS, Implicit CURSOR and Explicit Cursor.

PL/SQL uses Implicit Cursors for queries. USER defined cursors are CALLED Explicit Cursors. They can be declared and used.

There are two types of cursors, Implicit Cursor and Explicit Cursor.

PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.

Discussion

96.	What Are The Pl/sql Statements Used In Cursor Processing?
Answer» DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or RECORD TYPES, CLOSE cursor name. DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

96.

What Are The Pl/sql Statements Used In Cursor Processing?

Answer»

DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or RECORD TYPES, CLOSE cursor name.

DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

Discussion

97.	What Is An Oracle Stored Procedure?
Answer» A STORED procedure is a SEQUENCE of statements that perform SPECIFIC FUNCTION. A stored procedure is a sequence of statements that perform specific function.

97.

What Is An Oracle Stored Procedure?

Answer»

A STORED procedure is a SEQUENCE of statements that perform SPECIFIC FUNCTION.

A stored procedure is a sequence of statements that perform specific function.

Discussion

98.	What Are The Return Values Of Functions Sqlcode And Sqlerrm?
Answer» SQLCODE returns the latest CODE of the error that has occurred. SQLERRM returns the RELEVANT error message of the SQLCODE. SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

98.

What Are The Return Values Of Functions Sqlcode And Sqlerrm?

Answer»

SQLCODE returns the latest CODE of the error that has occurred.

SQLERRM returns the RELEVANT error message of the SQLCODE.

SQLCODE returns the latest code of the error that has occurred.

SQLERRM returns the relevant error message of the SQLCODE.

Discussion

99.	What Is Raise_application_error?
Answer» Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from STORED sub-program or DATABASE TRIGGER. Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from stored sub-program or database trigger.

99.

What Is Raise_application_error?

Answer»

Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from STORED sub-program or DATABASE TRIGGER.

Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from stored sub-program or database trigger.

Discussion

100.	What Is A Database Trigger? Name Some Usages Of Database Trigger?
Answer» Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events TRANSPARENTLY, ENFORCE complex business rules Derive column values automatically, IMPLEMENT complex security AUTHORIZATIONS. Maintain replicate tables. Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.

100.

What Is A Database Trigger? Name Some Usages Of Database Trigger?

Answer»

Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events TRANSPARENTLY, ENFORCE complex business rules Derive column values automatically, IMPLEMENT complex security AUTHORIZATIONS. Maintain replicate tables.

Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.

Discussion

Explore topic-wise InterviewSolutions in .

How To Define A Cursor Variable?

How To Open A Cursor Variable?

How To Loop Through A Cursor Variable?

How To Pass A Cursor Variable To A Procedure?

Why Cursor Variables Are Easier To Use Than Cursors?

What Is The Simplest Tool To Run Commands On Oracle Servers?

What Is A Sql*loader Control File?

What Is An External Table?

How To Load Data Through External Tables?

What Are The Restrictions On External Table Columns?

What Is A Directory Object?

What Is The Data Pump Export Utility?

What Is The Data Pump Import Utility?

What Are Data Pump Export And Import Modes?

How To Export Several Tables Together?

What Happens If The Imported Table Already Exists?

How To Import One Table Back From A Dump File?

What Are The Original Export And Import Utilities?

What Is Open Database Communication (odbc)?

How Can Windows Applications Connect To Oracle Servers?

How To Create Tables For Odbc Connection Testing?

How To Check The Oracle Tns Settings?

How To Connect Asp Pages To Oracle Servers?

What Is A Database Instance? Explain?

What Is A Deadlock? Explain?

What Is The Fastest Way Of Accessing A Row In A Table?

How Do You Implement One-to-one, One-to-many And Many-to-many Relationships While Designing Tables?

Switch To Dos Prompt?

To See Current User Name?

Do You Know What Are User Profiles In Apps. Any Examples You Can Give?

How Many Concurrent Programs You Have Customized, Can You Name Some Of Them?

How To Make The Project As .exe File In Oracle Forms &amp; Reports(d2k)?

Do You Know What Is Applysys In Oracle Application Database Schema, What Is Apps?

Which Flexfields You Have Customized?

How I Can Use Srw.run_report In Reports6i?

What Is The Placeholder Column? What Is The Format Trigger?

I Need To Run A Report At Scheduled Timings Only. I Don't Want To Run The Report On Sundays. How To Do This?

What Is The Page Protect In Reports?

I Want To Setup Additional Organizations, Do I Have To Setup Multiorg?

What Is Multi Org Architecture?

Give The Structure Of The Procedure?

What Are The Two Parts Of A Procedure?

What Is Pl/sql Table?

What Is A Cursor ? Why Cursor Is Required?

Explain The Two Type Of Cursors?

What Are The Pl/sql Statements Used In Cursor Processing?

What Is An Oracle Stored Procedure?

What Are The Return Values Of Functions Sqlcode And Sqlerrm?

What Is Raise_application_error?

What Is A Database Trigger? Name Some Usages Of Database Trigger?

How To Make The Project As .exe File In Oracle Forms & Reports(d2k)?