Answer Posted / annu rajput

Data Dictionary contains the informartion about the objects
there are severel data_dictionary in oracle database
for infomation about the tables in database there is a
data dictionary called user_tables
we can get the information about all the tables using the
statement

select * from user_tables;

How to loop through data rows in the implicit cursor?

1052

---

What is data type in oracle?

1097

---

How to use regular expression in pattern match conditions in oracle?

1018

---

How to define an oracle cursor variable?

1009

---

How do I know if oracle client is installed on windows?

1003

---

What is bulk load in oracle?

1051

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2253

---

What is null value in oracle?

1076

---

Differentiate between function and procedure in oracle.

1050

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1123

---

How to count groups returned with the group by clause in oracle?

1049

---

How to get a list of all user accounts in the database?

1074

---

what are steps for interface? where is exchange rate defined in which table?

2122

---

How do we get field detail of a table?

1058

---

Please explain oracle left join with an example?

1020

---