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

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

How to join two tables in a single query using oracle?

0 Answers  

---

Compare and contrast between sql and sql server and explain its various functions?

0 Answers  

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

What is the order of defining local variables and sub procedures/functions?

0 Answers  

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

which is the best training centre for learning oracle?

13 Answers  

---

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 Answers  

---

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

---

What are the trigger associated with image items ?

1 Answers   Oracle,

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

0 Answers   Zensar,

---

Explain the family trees and connection by clause

0 Answers  

---