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));

What is the oracle implicit cursor?

798

---

Calculate difference between 2 date / times in oracle sql?

803

---

what is meant by magic query

1963

---

How to list all user accounts in oracle?

814

---

Explain alias?

905

---

How to turn on or off recycle bin for the session?

829

---

What is a trigger and what are its types?

813

---

Explain oracle’s system global area (sga).

873

---

What are temporal data types in oracle?

857

---

can u plz provide me oca sql dumps please i need them

1701

---

When system tablespace is created?

791

---

How to delete a column in an existing table in oracle?

822

---

List the various oracle database objects?

819

---

What is a trace file and how is it created in oracle?

768

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2047

---