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
- 8292 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
What is difference between my sql and sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Is sql a dbms?
Write the command to remove all players named sachin from the players table.
Explain the difference between drop and truncate commands in sql?
What are the indexing methods?
Which type of cursor is used to execute the dml statement?
Why do we use joins?
Is join same as left join?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Does view contain data?
What is a memo field?
what is data control language? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
What is varray in pl sql?
