Oracle Interview / Technical Questions

Oracle Interview / Technical Questions Kindly solve an many as questions you can. It will sharpen your skills and those solutions will help others too.

Page 1 of 28

Last »

Threads in Forum : Oracle Interview / Technical Questions

Forum Tools

Search this Forum

Rating Thread / Thread Starter	Last Post	Replies	Views
Sql - There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with radhika_btech	20-11-09 01:39 PM by manjunath.hota	3	267
need query srikanth125	20-11-09 12:38 PM by manjunath.hota	3	267
Sql - How to display duplicate rows in a table? radhika_btech	22-09-09 06:23 PM by Unregistered	2	3,882
Sql - Given an employee and manager table, write a SQL syntax that could be used to find out an employee's manager's manager, assuming all managers are in the employee table. radhika_btech	17-09-09 07:03 PM by Unregistered	1	830
Oracle SQL PLSQL EASY STUDY GUIDE ramyaselvi16	01-09-09 01:33 AM by ram.rdy55	8	1,167
Java stored procedure abeetham	18-08-09 11:50 AM by abeetham	0	61
Oracle forms and reports 10g gsr29	17-06-09 01:13 PM by sanjumohan	6	3,111
Advantages of SQL Server 7.0 over SQL-Server 6.5 kiran2710	23-02-09 11:03 PM by AjayKumar.Kataram	2	554
emplyees in diffrent departments tredev@gmail.com	28-01-09 11:18 PM by words_foru	1	269
Sql - There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the departmen radhika_btech	17-01-09 11:35 PM by AjayKumar.Kataram	5	1,149
What is difference between stored procedures and application procedures? bhavana	06-01-09 05:16 PM by arunannamalai	1	300
oracle workflow step by step manojit.samanta	09-12-08 11:57 PM by manojit.samanta	0	345
Sql - How to find out the database name from SQL*PLUS command prompt? radhika_btech	15-11-08 05:46 PM by nkandima	5	6,928
If we want to insert 14 fields of information into 14-different tables, is it possible. How it can be done? kiran2710	21-10-08 03:53 PM by kvenkat	2	447
Sql - I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated. radhika_btech	19-09-08 02:05 PM by TILAK	2	1,066
query to find 2nd or 3rd maximum salary from emp table sumahalesh28	12-09-08 02:40 PM by pallavi.patil	5	6,860
Difference between JAVA and Oracle/SAP sharmachiru	06-08-08 02:03 PM by sharmachiru	1	435
Oracle Interview Questions & Answers in Word Format ramyaselvi16	28-07-08 10:52 AM by suresh_m1729@yahoo.co.in	3	1,305
What is the query to display duplicate rows of a table santosh.koora	18-07-08 02:59 PM by santosh.koora	0	582
Sql - What the difference between UNION and UNIONALL? radhika_btech	04-07-08 06:04 PM by sampada_m	4	1,889
What is meant by SORTING and GROUPING bhavana	06-06-08 12:41 PM by naughty21	4	510
What is difference between open_form and call_form? bhavana	05-06-08 02:01 PM by robertj	1	860
Sql - What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP; radhika_btech	09-05-08 10:44 AM by charushila	4	1,985
What is a public synonym bhavana	08-05-08 05:57 PM by sk_kireeti	4	708
What is meant by OUTER JOIN ? bhavana	08-05-08 04:26 PM by charushila	1	438

Page 1 of 28

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

All times are GMT +6.5. The time now is 05:24 PM.