Answer Posted / ram babu mandal(software engin

Yes, first I connect the as sysdba after that we insert
data in the dual table as

sql>conn / as sysdba
connected
sql>desc dual;
insert into dual values('A');
(1)row inserted

but I found some problems after that ,We use
sql> seelct * from dual;

Only one value displayed
that was default 'x' as system defined data not displayed
other data a like 'A'.


Dummy
-------
x

Only x record display in the dual table.

What is set operator oracle?

978

---

Why packages are used in oracle?

1066

---

What is the difference between $oracle_base and $oracle_home?

1089

---

Explain cascading triggers.

1073

---

what is normalisation?what are its uses?

2273

---

What are the set operators union, union all, minus & intersect meant to do?

987

---

what is dynamic SGA and static SGA

4417

---

How to get a list of all background sessions in the database?

993

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3050

---

What is oracle open database communication (odbc)?

1028

---

What is a nested table?

1057

---

Explain the importance of .pll extension in oracle?

1009

---

please explain.. DB architecture ...

2018

---

How to do paging with oracle?

995

---

What are the common oracle dba tasks?

1145

---