Answer Posted / uday shankar chejerla

select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;

How to get last row id?

937

---

Explain the importance of .pll extension in oracle?

950

---

What is the difference between view and materialized view in Oracle?

1090

---

What is redo log?

1003

---

What is the maximum limit on the number of columns in a table?

999

---

What are the types of partitions in oracle?

972

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4477

---

How to define a data field as not null?

1059

---

What is a synonym? What are its various types?

1042

---

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

1617

---

what is meant by magic query

2132

---

How to list all tables in your schema?

989

---

List the parts of a database trigger.

986

---

What is a initialization parameter file in oracle?

986

---

Is the After report trigger fired if the report execution fails ?

2874

---