How to get list of all tables from a database?

0 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

What is the use of partition by in sql?

0 Answers  

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

How do you modify a trigger?

0 Answers  

---

What is the difference between an inner join and an outer join?

0 Answers  

---

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

---

Is pl sql still used?

0 Answers  

---