Answer Posted / gurupatham

Column Level Constraints refers Only One Column .Which does
not have the column name at declaration time .
Ex : Create table emp
( empno number primary Key,
--,
--);

Table Level constraints refers one or more than one column .
Which does have column name at declaration time.
Ex: Create table emp
( empno number ,
--,
--,
Constraints pk_con primary Key(empno));

All constraints can be created as Column and Table level
expect Not Null constraints .
Not Null constraints can only be created as column level
constraints . Does not have constraints name.

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4483

---

Explain an index?

1103

---

Point the difference between translate and replace?

1037

---

How to create a stored procedure in oracle?

1042

---

Will you be able to store pictures in the database?

1078

---

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....

2019

---

What is the difference between truncate & delete command?

1146

---

How many categories of data types?

954

---

Explain oracle’s server parameter file.

960

---

How to check database size in Oracle?

1142

---

Explain the characteristics of oracle dba?

1080

---

What is transport network substrate (tns) in oracle?

1003

---

Which is better Oracle or MS SQL? Why?

6292

---

How do I start tns listener?

999

---

What do you mean by merge in oracle and how can you merge two tables?

922

---