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 21647

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

13 15878

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 11777

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 8451

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 17757

What is materialised View?

2 4846

Give an example of Full Outer Join?

1 4761

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

3086

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 11933

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 9609

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 2172

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

How do you track your progress in a sprint?

1


How do I remove a table in word but keep the text?

307


Differentiate between datastage and informatica?

690


Is India a mixed economy? What do you know about mixed economy?

593


how to embed flash in html? : Adobe flash

476






I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.

1421


Why efficiency in thermal power plant is low?

630


Define the term “percolate down”?

558


What is Trade Recovery Estimate and how can we calculate it?

1486


What is purpose of abstract class?

561


How to create a simple node js application?

233


Describe coalesce() operation. When can you coalesce to a larger number of partitions? Explain.

232


Do you know C or any other language?

670


Explain how to create custom 404 page in codeigniter?

334


What do you understand by avr?

598