select rownum,tablename.* frome tablename;

In table three columns with 1 milion records(here there is
no sequence values) i want add one more column with
sequence values from the first how it is posible?

Question Posted / kondeti srinivas

4 Answers
8339 Views
Tech Soft, I also Faced
E-Mail Answers

Answer Posted / kondeti srinivas

select rownum,tablename.* frome tablename;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is normalisation in sql?

1049

What is pl sql code?

1045

what is the difference between sql and t-sql? : Transact sql

1084

What schema means?

885

What is an implicit commit?

1048

What is scalar data type in pl sql?

1066

What is transaction control language (tcl)?

1130

How many commands are there in sql?

1026

Define implicit and explicit cursors.

1140

What is mutating error?

961

What is synonyms?

1051

What is clause in sql?

1108

What is materialized view in sql?

916

What is case function?

1034

What are different types of functions in sql?

1004