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.

Why do we need integrity constraints in a database?

1076

---

What is oracle sid?

1005

---

How to create lov dynamically at runtime & attach to text field?

1239

---

How to upsert (update or insert into a table)?

1043

---

Where do we use decode and case statements?

1060

---

What is a initialization parameter file in oracle?

1082

---

How to drop an existing view in oracle?

992

---

What are the various types of snapshots ?

1082

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1165

---

Explain the use of indexes option in imp command.

1262

---

How to handle a single quote in oracle sql?

1097

---

Why oracle is used?

1107

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2386

---

Calculate difference between 2 date / times in oracle sql?

1098

---

What is an oracle function?

1242

---