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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 4805

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

Polaris,

6 16052

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 4917

What is cursor

TCS,

4 9714

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

Telesis,

2068

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

7 10768

Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com

2 8067

How to synchronize 2 schema's objects?

Virtusa,

2181

Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??

1 8656

why dont we assign not null constraint as table level constraint.

2738

How i get the client m/c IP address.

2 5262

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2135

how many types of index?

Cap Gemini, TCS,

2 7284

if you update view? where we store the data?

Cap Gemini,

5 11148

Un-Answered Questions { Oracle }

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

Difference between negative and positive adjustments : oracle accounts receivable

1104

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2022

How is rman better than user-managed backup recovery process?

Can we commit inside a function in oracle?

965

Explain the use of table functions.

2485

How do I recompile a procedure in oracle?

964

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

What is the difference between internal & external schema?

757

definition of cluster and non-clustered index?

3035

In what sequence do triggers get fired by oracle forms?

957

How do we create privileges in oracle?

1046

What is the usage of control file in oracle?

1088

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

994

What are the uses of a database trigger?

994

For More Un-Answered { Oracle } Questions Click Here