Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 18051

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

 13 13768

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 9704

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 7366

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 14869




What is materialised View?

 2 4163

Give an example of Full Outer Join?

1 4315

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

 2818

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 10350

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 8846

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 1284

Post New IBM SQL PLSQL Interview Questions




IBM SQL PLSQL Interview Questions


Un-Answered Questions

What types of loops exist in php?

271

What are the two most important methods on the Report?

1

How do you deal with difficult or angry patients? : insurance health

199

What are different types of shell?

245

What is the most important feature of java? What is an interface?

259




How to do dependency injection in laravel controllers?

203

What is scala closure?

1

By passing current through a wire wrapped around an iron rod, william sturgeon invented the?

264

Explain calling sub procedure.

324

What is difference between flush and commit in hibernate?

45

Define connect statement?

1

What is transaction atomicity?

266

How can the disposition of sysout datasets be set for an entire jobstream?

385

What is oops abap?

1

Explain soap encoding?

260