Answer Posted / shafi.oracledba

to extract the ddl statement use the alter command to extract

Please explain oracle data types with examples?

1008

---

What are the ansi data types supported in oracle?

910

---

What are the differences between blob and clob in oracle?

1044

---

Whats the benefit of dbms_stats over analyze?

1952

---

What is define in oracle?

1022

---

How to change system global area (sga) in oracle?

969

---

What are the restrictions on external table columns?

1006

---

What is the difference between substr & instr functions?

1139

---

How to update values in a table in oracle?

972

---

Is oracle an operator?

892

---

Point out the difference between user tables and data dictionary?

942

---

What is an external table?

968

---

How to execute a stored program unit?

1019

---

What is the difference between a primary key & a unique key?

1049

---

How many categories of data types?

949

---