using comand prompt how can import table data and table space with example

2 Answers  

---

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

---

Can we create table in function?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

---

Define tables and fields in a database

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

what is index? : Sql dba

0 Answers  

---

What is difference between inner join and self join?

0 Answers  

---

What are three advantages to using sql?

0 Answers  

---

What are instead of triggers?

0 Answers  

---

what is rdbms? : Sql dba

0 Answers  

---