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.

Explain the use of tables option in exp command.

1052

---

What is coalesce function?

1003

---

What is a user account in oracle?

1065

---

What do you mean by cdb and pdb in oracle 12c?

1006

---

How to use subqueries in the from clause in oracle?

1043

---

Is primary key indexed by default in oracle?

929

---

Difference between oracle's plus (+) notation and ansi join notation?

1031

---

Can we call procedure inside function in oracle?

1018

---

How to count duplicated values in a column in oracle?

982

---

Explain compound trigger in oracle?

986

---

What is oracle instant client?

970

---

What is oracle data type?

901

---

11. Display the client number and name and the client number and name of the person who referred that client.

2274

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2127

---

What privilege is needed for a user to create indexes in oracle?

963

---