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

Please explain oracle left join with an example?

958

---

How to create a table interactively?

996

---

What is null value in oracle?

1035

---

What is oracle sid?

887

---

what is the difference between restoring and recovering?

961

---

Please explain joins in oracle?

1007

---

What is catalog in Oracle?

1264

---

Explain temporal data types in oracle

1040

---

How to unlock the sample user account in oracle?

916

---

What are the uses of linked server and explain it in detail?

1001

---

How to use an explicit cursor without open statements?

1011

---

types of indexes and the rationale behind choosing a particular index for a situation.

2443

---

Is postgres faster than oracle?

969

---

How to retrieve data from an explicit cursor?

1006

---

What are the different pseudo commands? Explain in general?

1019

---