Oracle General Interview Questions
Questions Answers Views Company eMail

How to get a list of all tables in the database?

1 3699

How to set up autotrace for a user account?

596

How to run the anonymous block again?

595

How to see the table columns used in an index?

596

How to drop an index?

544

What happens to the current transaction if the session is killed?

536

How to define an external table with a text file?

579

How to get a list of all user accounts in the database?

616

How to define a sub function?

666

How to define a data field as not null?

631

How to enter a new row into a table interactively?

548

How to build data dictionary view an new database?

532

How to get a create statement for an existing table?

572

How to pass parameters to procedures?

553

How to use "in" parameter properly?

617


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Where is the export dump file located?

571


How to connect to a remote server?

557


How to retrieve data from an cursor to a record?

563


Does oracle database need java?

522


How do I know if oracle is installed on windows?

486






What is meant by joins? List out the types of joins.

526


Differentiate between post-database commit and post-form commit?

543


What do you mean by a database transaction & what all tcl statements are available in oracle?

553


Explain alias?

713


What is a nvl function?

566


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1771


What is blob datatype?

569


how may join possible between (requisition with purchase order)

1699


How to see the table columns used in an index?

596


Can we call procedure inside function in oracle?

612