SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND ROENUM=5

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Question Posted / udaya

Answer Posted / udaya

SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5

Is This Answer Correct ?

5 Yes

32 No

Please Help Members By Posting Answers For Below Questions

Under what condition selecting sorted input in aggregator may fail the session?

1108

Target increases every day even though no new record was inserted

1560

How many ways are there to create ports?

1306

What is workflow? What are the components of workflow manager?

1156

Explain in detail about scd type 1 through mapping.

1403

draw informatica architecture 8.6 ?

3858

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1106

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2130

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2375

Explain what is informatica metadata and where is it stored?

1029

How can we update a record in the target table without using update strategy?

1119

What is informatica? Why do we need it?

1079

COM components can be used in Informatica

2365

How many input parameters can exist in an unconnected lookup?

1529

I have a flat file, want to reverse the contents of the flat file

1105