Answer Posted / vaibhavi_dixit

Dual table is know as magic table, which has only one
columns with name as "DUMMY" and a row with value X.
One can describe DUAL with desc dual; command.
It is mainly used for testing some math expressions or some
character functions like
select (2+2) from dual;
It is automatically created,assigned to SYS but accessible
to all users.

VD

Can we use having without group by in sql?

938

---

How would you pass hints to the sql processor?

942

---

What is a dynamic query?

982

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1035

---

Which software is used for pl sql programming?

941

---

What is join view in sql?

911

---

How many indexes can be created on a table in sql?

1007

---

how can we submit a form without a submit button? : Sql dba

932

---

How do I view a view in sql?

901

---

What is sql select statement?

987

---

How do I write a sql query in pgadmin 4?

940

---

What is package in pl sql?

979

---

Does sql support programming?

1020

---

What is pl sql architecture?

934

---

what is a record in a database ? : Sql dba

1014

---