select * from <Tab_name1> where rownum <=6 minus select* from &l

we have 10 records. It's occured error in 6th record how
can u find and how to rectify that?

Question Posted / srilekha

Answer Posted / srilekha

select * from <Tab_name1> where rownum <=6
minus
select* from <Tab_name1> where rownum<6;

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you differentiate between mediator and osb?

1142

q)what are the validations in sql*loader

2405

How many schemas we have? how many you have used?

2069

Is soa a part of oracle fusion middleware?

1090

What is a value set? List its various types.

1099

how can i print random rows in plsql table

2499

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

How is choreography different from orchestration?

1135

What do you understand by concurrent programs?

1100

Can we create tables in apps schema?

1143

List the types of flexfield?

1044

Do you know what is applysys in oracle application database schema, what is apps?

1177

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2107

what is global tempory table?

7210

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2386