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

Oracle General Interview Questions

Questions Answers Views Company eMail

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 7181

how to clone 9i Database on to 10g Database.

2383

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 3860

what r tyhe major differences between oracle 9i & 10g?

6 14689

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2261

Is primary key = unique key,not null? If yes,please explain IF No,please explain

Genpact,

8 18332

how to delete all duplicate records from a table using subquery?

ABC, Cap Gemini,

7 23977

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 9607

what is query and types of query

Reliance,

6 9335

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 4923

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 16268

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 4997

What is cursor

TCS,

4 9858

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

2045

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

IBM,

7 10979

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between PFILE and SPFILE in Oracle?

1108

How to define a procedure inside another procedure?

1066

How to drop a stored procedure in oracle?

1104

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2396

How to convert dates to characters in oracle?

1092

Explain cascading triggers.

1118

How to convert csv to table in oracle?

1043

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2872

How do I manually uninstall oracle client?

1148

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2054

How to load data through external tables?

1188

Does oracle charge for java?

1115

What are the roles of dba?

1136

What is the difference between translate and replace?

1116

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2545

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