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

What do you mean by stored procedures?

1014

---

What is difference between sql and mysql?

1133

---

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

1046

---

what is msql? : Sql dba

989

---

Why stored procedure is faster than query?

1062

---

Explain the the update statement in sql?

1038

---

What is example of database?

1057

---

What are the types of records?

988

---

Can triggers stop a dml statement from executing on a table?

1098

---

What is pl sql collection?

970

---

Can we use ddl commands in pl sql?

1162

---

Why does sql need a server?

1044

---

how to create a test table in your mysql server? : Sql dba

1008

---

How to call shell script from pl sql procedure?

1281

---

How to check if a column is nullable before setting to nullable?

1128

---