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 the importance of sqlcode and sqlerrm?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is sql profiler in oracle?

0 Answers  

---

What happens when a trigger is associated to a view?

0 Answers  

---

---

What are the basic techniques of indexing?

0 Answers  

---

Can we create foreign key without primary key?

0 Answers  

---

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

---

How do you add a column to a table?

0 Answers  

---

Which table is left in left join?

0 Answers  

---

What is the difference between sql and mysql?

0 Answers  

---