Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

How do I spool to a csv formatted file using sqlplus?

1033

What exactly do quotation marks around the table name do?

963

How to do paging with oracle?

999

How do I limit the number of rows returned by an oracle query after ordering?

1169

How do I reset a sequence in oracle?

1098

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1017

Calculate difference between 2 date / times in oracle sql?

1040

How to create id with auto_increment on oracle?

990

How to create a temporary table in oracle?

1268

Difference between oracle's plus (+) notation and ansi join notation?

1101

Explain about integrity constraint?

1122

What is literal?

1004

What are the uses of a database trigger?

994

Name the various constraints used in oracle?

1019

Where do you use decode and case statements?

993

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert a string to a date in oracle database?

1053

Explain the characteristics of oracle dba?

1120

6. Display the client name and order date for all orders using the traditional method.

2306

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

How to set up autotrace for a user account?

1059

How to run queries on external tables?

1047

How to add another datafile to a tablespace?

1040

Can we protect our pl/sql source code?

1043

How to insert multiple rows with one insert statement in oracle?

1086

What is java oracle used for?

1021

How to fetch the row which has the max value for a column?

1001

How to create a stored procedure in oracle?

1103

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1033

What is the database name in oracle?

1021

How to define and use table alias names in oracle?

943

For More Un-Answered { Oracle General } Questions Click Here