what eliminate duplicate without using roenum and not
Answer Posted / amar_kondla
>create table table_name2 as select * from table_name1;
>drop table table_name1;
> rename tabale_name2 to table_name1;
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Which are the different case manipulation functions in sql?
differentiate between float and double. : Sql dba
how to return query output in html format? : Sql dba
Advantages and disadvantages of stored procedure?
What are the different dml commands in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the example of procedure?
How to display the records between two range in Oracle SQL Plus?
What is a sql trace file?
Explain what is sql*plus?
What is asqueryable?
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...
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How do you optimize a stored procedure query?