Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 8139 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
how many sql dml commands are supported by 'mysql'? : Sql dba
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What are the different dcl commands in sql?
Can we commit in trigger?
Explain the difference between 'between' & 'and' operators in sql
What is rowid in sql?
Does pl/sql support create command?
Are stored procedures compiled?
Mention what does plv msg allows you to do?
what is the bond code in materialized view?
Explain architecture of sql server notification services?
What are sql*plus environment variables?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Why triggers are used?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
