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;

What is different types of joins?

1078

---

what is meant by magic query

2230

---

How to create additional tablespaces for an new database?

1078

---

How to use subqueries in the from clause in oracle?

1165

---

What is oracle sid?

1004

---

Can we create database in oracle using command line ?

1132

---

What is pragma autonomous transaction in oracle?

1123

---

What is a nested table?

1111

---

What to do if the startbd.bat failed to start the xe instance?

1126

---

How to define a specific record type?

1136

---

How to connect to oracle using service name instead of sid?

1067

---

How many types of table in Oracle?

1172

---

What are operators in oracle?

1101

---

How to divide query output into groups in oracle?

1032

---

what is the scripts in data base?

2222

---