Answer Posted / ajit nayak

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

How do I know if oracle is installed on windows?

908

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1986

---

State some uses of redo log files?

981

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1028

---

How do we create privileges in oracle?

1028

---

Differentiate between pre-select and pre-query?

1083

---

How to use null as conditions in oracle?

1054

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1763

---

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

969

---

List the various oracle database objects?

1039

---

Explain the use of log option in exp command.

1096

---

How to create a new oracle data file?

1017

---

What the is the diff between local index and global index. give some example.

1616

---

How to export your own schema?

994

---

Explain do view contain data?

982

---