Answer Posted / gourvendra singh

if you need to take tha backup of the database on ur hard
disk then u can use the following query:

exp userid=system/manager@orcl file=location\abc.dmp full=y
log= abc

How is a process of pl/sql compiled?

1083

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3925

---

Which certification is best for sql?

938

---

How many subqueries can be nested in a statement?

933

---

What are the types pl/sql code blocks?

1067

---

What is delete command in sql?

1051

---

How can a function retun more than one value in oracle with proper example?

1026

---

Is pl sql useful?

931

---

How do you write a subquery?

964

---

what are the type of locks ? : Sql dba

897

---

How do I find duplicates in sql?

877

---

Define a temp table?

965

---

Explain raise_application_error.

1042

---

What are the possible values that can be stored in a boolean data field?

947

---

what is sp_pkeys? : Transact sql

1102

---