Answer Posted / reddy

create type obj1 as object(addr1 varchar2(30),addr2 varchar2(30)); create type bbb as table of obj1; create tableemployee(no number(9),name varchar2(19), address bbb);

Explain a data segment?

1015

---

How to change program global area (pga) in oracle?

1032

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1934

---

What are the different windows events activated at runtime ?

2833

---

What is where clause in oracle?

981

---

Can group functions be used in the order by clause in oracle?

939

---

What is enter substitution variable in oracle?

982

---

How to define a data field as not null?

1060

---

How to create a new table in your schema?

1028

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2088

---

How to unlock the sample user account in oracle?

916

---

How to insert a new row into a table in oracle?

1089

---

What is a directory object?

1023

---

How to run the anonymous block again?

1065

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2086

---