Answer Posted / riddhi

Difference between column level constraints and table level constraints
1)Column level constraint is declared at the time of creating a table but table level constraint is created after table is created.
2)Column Level Constraints refers Only One Column whereas table level constraints refers to one or more than one column
3)not null constraint can't be created as table level constraints because it don't have name.
Column level constraint-

Ex : Create table emp
( empno number primary Key);
Table level constraint

Ex: Create table emp
( empno number);
Constraints pk_con primary Key(empno));

How to execute a stored procedure in oracle?

1028

---

What privilege is needed for a user to create views in oracle?

978

---

What are the different types of modules in oracle forms?

951

---

What are the built-in functions used for sending Parameters to forms ?

3307

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2150

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2307

---

What are the restrictions on external table columns?

991

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2188

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3273

---

How to invoke the data pump import utility?

1080

---

What is a trigger and what are its types in oracle?

998

---

What is difference between sid and service name in oracle?

904

---

What are the differences between date and timestamp in oracle?

972

---

What is a lookup table in oracle?

929

---

How to create a testing table in oracle?

945

---