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 is the difference between $message and $$message? : Sql dba

977

---

how can we destroy the cookie? : Sql dba

993

---

What is sqlca in powerbuilder?

993

---

What is crud diagram?

927

---

How do I view a table in sql?

993

---

What is numeric function sql?

1042

---

What steps server process has to take to execute an update statement?

961

---

What are records give examples?

990

---

State some properties of relational databases?

1037

---

What is on delete set null?

1070

---

Differentiate between pl/sql and sql?

1129

---

How do I count duplicates in sql?

1084

---

What is package in pl sql with an examples?

1018

---

Can we create a trigger on view?

879

---

What is pls_integer in pl sql?

1072

---