Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IBM SQL PLSQL Interview Questions
Questions Answers Views Company eMail

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

 21 21892

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

 13 16000

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

 6 11877

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

 6 8531

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

 4 17873

What is materialised View?

 2 4880

Give an example of Full Outer Join?

1 4813

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

 3104

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

 8 12016

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 9666

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.

 1 2213

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

What is extended stored procedures?

561

What is managed object context and what are its functions?

435

explain project planning board

629

what are relationships?

598

What is cluster control?

439




I am doing a engineering contract with GOI. I have purchased certain material from outside Maharashtra and paid CST on that material @ 5.25%. Please intimate whether I will be liable for VAT or VAT on works contract or not.

1583

What is the message size limit in an Azure Storage queue?

317

What is the difference between a value table and a check table?

1371

What is the order in which the sql query is executed?

521

How is mysql database stored?

531

What is visual c++ used for?

577

What's Merchant Banking?

658

Why do we need apache spark?

191

What is wet leg condition and why is it used?

1552

Why we do load and performance testing?

746