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 21980

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

 13 16059

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 11908

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 8560

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 17929

What is materialised View?

 2 4887

Give an example of Full Outer Join?

1 4822

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

 3110

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 12077

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 9678

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 2238

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered Questions

Is rtx 2060 good for deep learning?

1

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6485

Which bidding strategy should you use to achieve this goal?

5

What is water powerpoint?

105

What is the use of idl2java [options] {filename}?

1031




Explain about Page-Remove method?

245

How do you create a workspace in excel?

296

What Does Lokup Does In Tables & Arrays?

741

is data integration and etl programming is same? : Sas-di

577

Hat are the minimum system requirements to run photoshop?

25

What is the translucent?

535

Which interfaces are implemented by hashmap?

519

What is the purpose of a web-client?

571

what is session in java?

756

What is echo command in batch file?

593