IBM SQL PLSQL Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

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 26894

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

13 18930

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 13624

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 10234

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 19687

What is materialised View?

2 5666

Give an example of Full Outer Join?

1 5410

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

3516

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 14093

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 10541

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 2984

Post New IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions

IBM SQL PLSQL Interview Questions (41)

Un-Answered Questions

What are system requirement for laravel 5.0?

681

how to workable concrete cube test M-25 design mix

3403

A client wants to preserve the reference to the ejbhome object of an enterprise bean instance and use it later. Which of the following can be serialized for this purpose?

937

What are the different properties the metadata translates into to make up the bean definition?

324

What is the phytoplankton?

288

What is the use of Canvas Element in HTML5?

827

I APPLIED SBIPO EXAM PLZ SEND ME THE INTERVIEW QUESTIONS AND GD TOPICS AND WRITTENEXAM QUESTIONS

2067

What is robotic process automation (rpa)?

What is Thresholding?

1177

What size is 1x and 2x?

687

Hi All, Can any one post a MS-DOS command/ utility tool, that modifies large size(nGBs) log file into MBs form the begining of log file? I will appreciate if any one give correct answer to this question. Thanks

1983

Hi, I am using OutputCheckPoint and I am storing the value in the data table. The stored value for column:bedroom:"Bed:4" The another value for column:bathroom:"Bath:2 Full,1 Partial" I need only the no 4 from the first column. I need only the no 2,1 from the second column. I used split array,but it also show array(0) has the value"bed:4" ..... Even though I highlight only 4,It is seleting the full value "bed 4".How can I get only the nos Thank you Uma

1688

Which satellite first relayed television?

718

What is braced excavation all about?

1113

What happens when the page containing angular based application loads?

723