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

please send me oracle pl/sql exp resume. and also faqs...

2494

---

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

1083

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1231

---

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

2510

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

---

which one is currently in used software cmpanies.

2153

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2397

---

How to clone the database using RMAN back

2238

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2862

---

can we use lexical perameter in oracle plsql if yes how

2315

---

what are the API of GL,PO,AP

2267

---

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

17641

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2263

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113

---

can u give guidance abt packages of plsql

2174

---