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

How to create an oracle database manually?

1127

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2332

---

Explain parameter file in oracle.

1080

---

How to display row numbers with the records?

1132

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1223

---

What are the general rules on data consistency?

1056

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2365

---

How to create id with auto_increment on oracle?

1036

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2342

---

How to count groups returned with the group by clause in oracle?

1119

---

How to connect to oracle using service name instead of sid?

1067

---

What does sharding mean?

1052

---

What is the dynamic sql in oracle?

1124

---

What is primefaces used for?

1094

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2077

---