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

How to build data dictionary view an new database?

0 Answers  

---

How to divide query output into groups in oracle?

0 Answers  

---

What is the difference between normal and corelated subqueries?

2 Answers  

---

What is a Tablespace?

5 Answers  

---

How to save query output to a local file?

0 Answers  

---

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,

---

How to create additional tablespaces for an new database?

0 Answers  

---

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

0 Answers  

---

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

---