Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

Infosys,

4 6892

Can we use out parameter in function?

Infosys,

4 10764

What will be the output for the below Query Select 'High' from dual where null = null;

Infosys, Satyam,

12 19725

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 4029

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 6050

how many no of table can be join in a sql query.

4 6821

When do we create bitmap indexes

CTS,

2 7756

define sql

Zensar,

3 3455

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

TCS,

1 3870

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

TCS,

6 9496

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

TCS,

3 5338

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

Accenture,

5 10268

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

BeBo Technologies,

8 9884

How to count the no of records of a table without using COUNT function?

TCS, Tesco,

11 18963

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

JDA,

4 5616


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Define SQL and state the differences between SQL and other conventional programming Languages?

158


Why are cursors used?

107


what is schema? : Sql dba

138


what is 'mysqlimport'? : Sql dba

141


how would you enter characters as hex numbers? : Sql dba

140






What is the purpose of cursors in pl/sql?

146


How do I get sql certification?

109


What is partition by in sql?

109


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

145


Can a composite key be null?

102


Why partition by is used in sql?

116


Does pl sql work in mysql?

108


what is the stuff function and how does it differ from the replace function? : Sql dba

142


how to shut down the server with 'mysqladmin'? : Sql dba

131


How to write a query to show the details of a student from students table whose

153