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

Oracle General (1803)
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 4938

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 16295

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 5007

What is cursor

TCS,

4 9876

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

2050

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,

2119

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

IBM,

7 10998

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

2 8164

How to synchronize 2 schema's objects?

Virtusa,

2239

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

1 8740

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

2800

How i get the client m/c IP address.

2 5362

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

2211

how many types of index?

Cap Gemini, TCS,

2 7405

if you update view? where we store the data?

Cap Gemini,

5 11402

Un-Answered Questions { Oracle }

How many concurrent programs you have customized, can you name some of them?

Explain how to close periods in ar. : oracle accounts receivable

1381

Why more redos are generated when the oracle database is in begin backup mode?

1175

How can I learn oracle dba?

601

How to do paging with oracle?

1054

State the difference between a primary key and foreign key?

999

How you find which is the latest record in SCD type2 transformation?

656

How do we create privileges in oracle?

1103

Can a formula column be obtained through a select statement ?

2382

What is variable? What is Flow of variable?

668

What is the Repository and how many types of repository?

636

How do I manually uninstall oracle client?

1157

How can we force the database to use the user specified rollback segment?

1202

How do I become a database administrator?

626

What is the meaning of recursive hints in oracle?

1103

For More Un-Answered { Oracle } Questions Click Here