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?

CTS,

2 7739

What are the Diff B/W Cursor and REF Cursor

CTS,

3 9403

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

Doyensys,

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. 

GE,

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.

GE,

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

HCL,

3 4566

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

CGI,

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????

Infosys,

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

200


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

1380


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

1491


What is Temp Table and type of temp table?

677


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

1223






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

6122


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

6852


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

2262


when MSQL8.0 is in market

942


What is your daily office routine?

1161


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

1831


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...

1164


What is Histogram?

385


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

1093


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

3855