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

What is the difference between oracle media recovery and crash recovery?

671

---

What is the disk migration? what is the steps involved in oracle disk migration?

717

---

Give two methods you could use to determine what DDL changes have been made.

6021

---

key flexfield structure

1599

---

Difference between negative and positive adjustments : oracle accounts receivable

620

---

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

655

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

712

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1851

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1986

---

How do you create a credit note against an invoice? : oracle accounts receivable

644

---

What is the mandatory setup in cyclecount ?

2184

---

Why more redos are generated when the oracle database is in begin backup mode?

661

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2139

---

What is the difference between recovery and restoring of the oracle database?

659

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16356

---