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)?

2636

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?

13


What is meant by the term super user?

107


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

2930


What is modbus?

149


How do I rename a mysql database?

84






How do you maintain promotions in sap is retail?

1


Explain your approach to managing important projects?

133


What is mvc in java?

92


What is difference between drop and delete?

61


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

120


Explain an idle thread?

122


What are the threats to internet security?

149


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

113


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

1011


What is the use of struts?

72