Answer Posted / sanjay gupta

U can by connecting as sysdba

but it displays all rows

insert into dual values('A');
insert into dual values('B');
commit;
select * from dual;
Dummy
-------
x
A
B
in same session and will display x in different session only

Is java required for oracle client?

1000

---

How to add a new column to an existing table in oracle?

1139

---

Please explain compound trigger in oracle?

1057

---

Explain an exception and its types?

1073

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1847

---

How to define a variable to match a table column data type?

988

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2186

---

How to pass parameters to procedures in oracle?

1042

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2623

---

When do you get a .pll extension in oracle? Explain its importance

1042

---

What are the different types of database objects?

1062

---

How to execute the package in oracle?

1082

---

How to use "in out" parameter properly?

1048

---

What is query image?

981

---

What is a nested table?

1059

---