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
8366 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 a temporal data type?

1054

what is error ora-03113: end-of-file on communication channel?

1165

What is a schema? How is it useful in sql servers?

1123

How to run pl sql program in mysql?

1025

What is a scalar value in sql?

1076

What is graph sql?

996

What are variables in pl sql?

1170

Is sqlite good enough for production?

997

Explain the structure of pl/sql in brief.

1095

What is the least restrictive isolation level? : Transact sql

1070

How many types of relationship are there?

1031

how to include character strings in sql statements? : Sql dba

1077

What is microsoft t sql?

950

Why is the cursor important?

1046

what is row? : Sql dba

1230