Answer Posted / nilesh

Column level constraints are applicable to that column
only, whereas table level conatraints are used to define
composite keys like primary key for the combination of two
or more columns in a table

How to drop a stored function?

1131

---

What is a read write transaction in oracle?

1072

---

What are the differences between number and binary_float in oracle?

1095

---

How to connect to a local oracle 10g xe server?

985

---

What is a sub query and what are the different types of subqueries?

1115

---

What is a oracle database?

1048

---

What is the data type of dual table?

986

---

how the indexes are stored in the Oracle Database?

2267

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2054

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2088

---

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

1127

---

Can a formula column be obtained through a select statement ?

2310

---

How to drop a stored procedure in oracle?

1045

---

How to connect to the server with user account: sys?

1010

---

what is the difference between substr and instr function in oracle?

1074

---