1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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,

5 9701

Can we use out parameter in function?

Infosys,

4 14314

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

Infosys, Satyam,

12 26505

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 5134

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 8102

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

 4 8348

When do we create bitmap indexes

CTS,

2 8819

define sql

Zensar,

3 5067

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 4713

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 11619

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 6630

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,

6 13571

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

BeBo Technologies,

8 14202

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

TCS, Tesco,

11 24836

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 7106

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is sql a dbms?

517

How many types of literals are available in pl sql?

501

What is sql*loader and what is it used for? : aql loader

604

Which are the different character-manipulation functions in sql?

536

What is number function in sql?

520




how to check myisam tables for errors? : Sql dba

577

Is there a 64 bit version of ssms?

501

What is the difference between union and union all command?

532

Mention what pl/sql package consists of?

524

How do I save the results of sql query in a file?

519

What are the properties of a transaction?

543

What is normalization in a database?

595

what are the limitations of identity column? : Transact sql

592

What is a sql select statement?

556

How to connect a sql*plus session to an oracle server?

609

For More Un-Answered { SQL PLSQL } Questions Click Here