Answer Posted / saraswathi muthuraman

SELECT OWNER,OBJECT_NAME,To_char(CREATED,'MON//DD/YYYY'),
to_char(CREATED,'HH:MM PM') from ALL_OBJECTS WHERE
OBJECT_TYPE ='TABLE' AND OBJECT_NAME ='EMP_TEST';

Result:

Saras EMP_TEST
JUN//01/2010 11:06 AM

what is the difference between myisam static and myisam dynamic? : Sql dba

772

---

What is meant by truncate in sql?

754

---

Does user triggers have entry for trigger with compilation errors?

797

---

What is a clob in sql?

730

---

How do you add a column to a table?

772

---

---

Can you have more than one trigger on a table?

712

---

Can instead of triggers be used to fire once for each statement on a view?

716

---

How global cursor can be declare with dynamic trigger ?

1945

---

What are the most important characteristics of pl/sql?

785

---

how to present a past time in hours, minutes and seconds? : Sql dba

741

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

958

---

How to select 10 records from a table?

841

---

How do I make my sql query run faster?

664

---

What is the primary key?

700

---

how to get a list of all tables in a database? : Sql dba

692

---