Answer / yam

to see the framework of table use

DESCRIBE tablename;
or DESC tablename

Answer / sudheer kumar mikkilineni

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

---

Can we use update in sql function?

0 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

---

What is pl/sql tables?

7 Answers   TCS,

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

---

What is pl sql collection?

0 Answers  

---