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

Explain the working of primary key?

1038

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

1005

---

Does truncate release storage space?

1015

---

How global cursor can be declare with dynamic trigger ?

2148

---

What is the non-clustered index in sql?

1012

---

What is function and procedure in pl sql?

975

---

What is nvarchar in sql?

887

---

Is left join same as inner join?

1023

---

Is join an inner join?

898

---

How much ram can sql express use?

934

---

Mention what pl/sql package consists of?

939

---

What are the different parts of a package?

1043

---

Explain the difference between rename and alias?

966

---

What is auto increment feature in sql?

1069

---

How to look at the current sql*plus system settings?

1082

---