Can We Restore a Table that accidantly dropped.
Answer Posted / chintan_db
create table dropedemo(a number(10)); --will create table
commit;
insert into dropedemo values (dbms_random.value(0,100)) ; --
data inserted
commit;
drop table dropedemo; --drope table
flashback table dropedemo to before drop; --will restore
table
select * from dropedemo;
--will create magic and give u proof of data is back
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we modify approve purchase order?if yes what is navigation?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is auto invoicing? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is db_recovery_file_dest in oracle? When do you need to set this value?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
How would you determine what sessions are connected and what resources they are waiting for?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Difference between negative and positive adjustments : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f