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 16127

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

13 12565

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 8589

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 6686

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.

3 13632

What is materialised View?

2 3843

Give an example of Full Outer Join?

1 4011

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


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 9386

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 8355

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 686

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

Un-Answered Questions

What is a faceless component?


What is meant by the term super user?


Please give a specific example of when you have delivered excellent customer service.


What is modbus?


How do I rename a mysql database?


How do you maintain promotions in sap is retail?


Explain your approach to managing important projects?


What is mvc in java?


What is difference between drop and delete?


Explain what is di (dependency injection) and how an object or function can get a hold of its dependencies?


Explain an idle thread?


What are the threats to internet security?


What is the process for the removal of salts from brackish water or seawater to make it usable?


Why can't we use antifrictional bearing in place of journal bearing in a 660mw plant


What is the use of struts?