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

how to return query output in html format? : Sql dba

851

---

how to decrement dates by 1 in mysql? : Sql dba

760

---

What are the steps for performance tuning.

1036

---

Explain 3 basic parts of a trigger.

1037

---

what is try_catch block in procedure

1393

---

---

How do I count records in sql?

731

---

Does sql require a server?

711

---

How do I filter in sql profiler?

732

---

What is pivot table in sql?

740

---

define sql insert statement ? : Sql dba

750

---

What is pl sql in dbms?

695

---

What is execution plan in sql?

762

---

how would you get the current date in mysql? : Sql dba

724

---

What are the types of records?

744

---

What is the difference between database trigger and stored procedure?

740

---