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 21872

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

 13 15998

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 11873

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 8530

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 17862

What is materialised View?

 2 4877

Give an example of Full Outer Join?

1 4810

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

 3102

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 9661

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 2209

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

What are the applications of a.i?

514

How do I access C style strings?

986

Which component is used to sort that data?

1

How can you start a apache server with different configurition ( other that httpd.conf)?

477

8. How much supervision have you typically received in your previous job?

1828




What is load in codeigniter?

300

What is difference between atomic and nonatomic in ios?

396

What is an otr and mention its usage in webdynpro?

93

The power supplied to a 50mH inductor from a 120V, 60Hz source will be

4217

what is ur strangth & weekness

1812

What are various procedures for counting physical inventory?

743

What is java used for in technology?

461

what is land scape why we are using this ?

1304

Cholesterol is a compound suspected of causing hardening of the arteries. The formula of cholesterol is C27H46O. a. A sample of cholesterol is isolated from the arterial lining of a 60-year-old American male. What is the formula of this compound? b. Cholesterol is extracted from a chicken’s egg. What is the formula of this compound?

2594

Give a general algorithm for converting a m-array tree to a 2-ary tree.

617