SQL PLSQL Interview Questions
Questions Answers Views Company eMail

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

Cap Gemini, MTS,

3 6464

How to find only %th Highest Sal

Symphony, Infogain,

6 7404

How will you make performance better for application including front end and back

Metric Stream,

2 7425

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?


2 7739

What are the Diff B/W Cursor and REF Cursor


3 9403

difference between table level constraint and column level and advantages of table level constraint


4 7072

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

Metric Stream, Doyensys, Infosys,

5 13253

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 5922

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 


2 2640

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.


4 6574

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 1992

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 3632

when normalization is required


3 4566

can i create trigger on synonym is it possible or not please help me


4 6989

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????


3 8081

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?


What action do you have to perform before retrieving data from the next result set of a stored procedure ?


What is Temp Table and type of temp table?


What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?


write a query that returns first characters of each word in Oracel/Sql pl sql


What is Materialized View? In What Scenario we Use Materialized View?


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5


when MSQL8.0 is in market


What is your daily office routine?


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...


What is Histogram?


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10


What packages(if any) has oracle provided for use by developers?