Answer Posted / posamram

select next_day(last_day(sysdate),'MON')-7 FROM DUAL;

Explain enable novalidate constraint.

1030

---

How to define and use table alias names in oracle?

883

---

What is tns entry?

1058

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

---

What privilege is needed for a user to create indexes in oracle?

963

---

How to select some columns from a table in oracle?

1003

---

What is the parameter mode that can be passed to a procedure?

979

---

master table and child table performances and comparisons in Oracle ?

2068

---

How to define an oracle cursor variable?

973

---

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 an Oracle Instance?

1071

---

How can we delete duplicate rows in a table?

926

---

What is difference between sid and service name in oracle?

904

---

What is a synonym? What are its various types?

1043

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2252

---