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 sql mysql pl sql oracle?

1067

---

How do you write a complex sql query?

1063

---

What is rename in sql?

972

---

What is a column in a table?

1124

---

Explain the purpose of %type and %rowtype data types with the example?

994

---

What is normalization sql?

1053

---

How many functions are there in sql?

1017

---

What is sql comments?

1074

---

How do I count duplicates in sql?

1103

---

How to use transactions efficiently : transact sql

1056

---

Are subqueries better than joins?

974

---

How do you modify a column in sql?

994

---

How many types of functions are there in sql?

953

---

How do you exit in sql?

1106

---

What are the advantages of stored procedure?

1003

---