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
8547 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 exit statement?

1060

How do you know if a relationship is 2nf?

994

What is the starting oracle error number? What is meant by forward declaration in functions?

1041

Explain unique key in sql.

1060

Explain raise_application_error.

1145

What are the advantages of pl sql over sql?

1071

How does an execution block start and end in pl sql?

997

What is spool?

1109

What are the benefits of triggers?

1217

What is a subquery in sql?

1089

What are sql procedures?

1084

What are different joins used in sql?

1105

what is meant by nl2br()? : Sql dba

1106

Explain what is rdbms?

1085

How do I audit the sql sent to the server?

1057