Oracle General Interview Questions
Questions Answers Views Company eMail

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

1 3684

How to set up autotrace for a user account?

584

How to run the anonymous block again?

588

How to see the table columns used in an index?

583

How to drop an index?

533

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

526

How to define an external table with a text file?

570

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

597

How to define a sub function?

656

How to define a data field as not null?

624

How to enter a new row into a table interactively?

539

How to build data dictionary view an new database?

522

How to get a create statement for an existing table?

562

How to pass parameters to procedures?

542

How to use "in" parameter properly?

608


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between post-database commit and post-form commit?

505


What is the usage of analyze command in oracle?

601


What are the oracle differences between nvl and coalesce

500


What is private procedure oracle?

519


How to import one table back from a dump file?

576






How to connect ms access to oracle servers?

540


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1651


Is the After report trigger fired if the report execution fails ?

2391


How can we view last record added to a table?

589


Difference between open_form and call_form in oracle.

664


How to use existing values in update statements using oracle?

538


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1462


What is the sid in oracle?

523


How to use "while" statements in oracle?

724


How to drop a stored procedure in oracle?

578