SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

756

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

ICICI,

3 1123

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

CTS,

1 642




Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

Societe Generale,

1 1399

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 886

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

1 1479

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 981

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 751




7. Where would you look for errors from the database design?

Fintellix,

1 1040

Whis is not false in primary key?

Fintellix,

293

What is Histogram?

NIIT,

385

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 226

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

337

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 are local and global Indexes and where they are useful.

29


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

what is the difference difference between procedure and packages

6482


What are code pages ?

1074


Whis is not false in primary key?

293


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

2456


what is try_catch block in procedure

520






what are sequences

32


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


what is the bond code in materialized view?

1705


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1031


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2167


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

6852


Difference between global and parameter variables?

769


What is AUTH_ID and AUTH_USER in pl/sql ?

756


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

906


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