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

How can I speed up sql query?

529

---

What is sql and how does it work?

553

---

What is pl sql record in oracle?

567

---

Why does sql need a server?

566

---

Is sqlite thread safe?

611

---

---

Can we use delete in merge statement?

517

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1392

---

What is natural join in sql?

537

---

What is sql*plus?

575

---

Define commit, rollback and savepoint?

582

---

What is an invalid partition table?

570

---

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

543

---

explain the advantages and disadvantages of stored procedure? : Sql dba

536

---

How to set up sql*plus output format in oracle?

598

---

Write a sql query to convert all character to uppercase after hypen.

966

---