Answer Posted / shekharjchandra

We can view the structure of the DUAL table by

SQL> DESCRIBE DUAL

or being in SYS user

SYS> SELECT DBMS_METADATA('TABLE','DUAL','SYS') FROM DUAL ;

Before that use below set command

SQL> SET PAGESIZE 100 -- or whatever you like so that you can see whole structure of the create table definition

Regards
J

Mention what plvcmt and plvrb does in pl/sql?

1193

---

How does pl sql work?

1001

---

How do I tune a sql query?

1031

---

How does sql*loader handles newline characters in a record? : aql loader

1087

---

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

1040

---

How to start oracle sql developer?

1068

---

What is cursor in pl sql?

1181

---

Are stored procedures compiled?

976

---

How do I view a view in sql?

990

---

What is a stored procedure in sql with example?

1195

---

what is schema? : Sql dba

1097

---

what are the advantages a stored procedure? : Sql dba

1016

---

What is pivot table in sql?

1163

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1267

---

Do we need to rebuild index after truncate?

1094

---