Answer Posted / ajit nayak

SELECT TO_CHAR(LAST_ANALYZED,'DD-MON-YYYY HH12:MI:SS'),COLUMN_NAME
FROM COLS
WHERE TABLE_NAME = 'EMP';

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2182

---

How to execute the package in oracle?

1086

---

How to update values on multiple rows in oracle?

1037

---

Write a trigger example in oracle?

1069

---

How to manage transaction isolation level?

1009

---

Can multiple cursors being opened at the same time?

1066

---

How to do paging with oracle?

1004

---

Explain the blob datatype?

1078

---

How to create a table index in oracle?

1135

---

What is the difference between $oracle_base and $oracle_home?

1090

---

How to delete an existing row from a table in oracle?

1072

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

---

What is the difference between primary key and unique key and foreign key in oracle?

984

---

What is the meaning of recursive hints in oracle?

1046

---

Explain the use of record length option in exp command.

1067

---