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 think about pl/sql?

529

---

Why do we use joins in sql?

500

---

Can a view be mutating? If yes, then how?

572

---

What is plpgsql language?

529

---

What is pl sql block in dbms?

524

---

---

Can you have more than one trigger on a table?

530

---

How do I access sql anywhere database?

495

---

How many types of keys are there in sql?

550

---

What is numeric function sql?

540

---

What is foreign key and example?

514

---

What are the popular database management systems in the it industry?

561

---

what is the difference between truncate and delete statement? : Transact sql

542

---

What does stand for in sql?

522

---

What are sql functions? Describe the different types of sql functions?

551

---

what are wild cards used in database for pattern matching ? : Sql dba

546

---