Explain the use of control file?

1076

How to write date and time interval literals in oracle?

990

How to build data dictionary view an new database?

972

How to insert a new row into a table in oracle?

1117

What the is the diff between local index and global index. give some example.

1595

How to apply filtering criteria at group level in oracle?

1004

How to create a new tablespace in oracle?

945

What is index-organized table in Oracle?

1032

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1876

What is the purpose of tables, private synonyms and public synonyms in Oracle?

996

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1719

When do you get a .pll extension in oracle? Explain its importance

996

How to execute the package in oracle?

1051

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1991

How to download oracle database 10g xe?

966