i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,

---

What is Oracle table?

1 Answers  

---

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 filter out duplications in the returning rows using oracle?

0 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

what is the difference between data migration and production migration.

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

Can the query output be sorted by multiple columns in oracle?

0 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

What is merge in oracle?

0 Answers  

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers  

---

What is an oracle and why it is used?

0 Answers  

---