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

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

1028

---

Explain the payment term in ar. : oracle accounts receivable

1058

---

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

17496

---

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

6688

---

What is the sql query to find the employee who has Nth maximum salary?

5218

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1250

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3486

---

what are the tools used for oracle 10g in real time.

2376

---

Explain about party and customer in ar : oracle accounts receivable

1150

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2219

---

which one is currently in used software cmpanies.

2105

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2410

---

can we use lexical perameter in oracle plsql if yes how

2268

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2208

---

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2103

---