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 loop in pl sql?

1040

---

What are all the different normalization?

1044

---

How to add a column ‘salary’ to a table employee_details?

1013

---

What are different types of triggers?

1114

---

What is pl/sql language case sensitive?

1131

---

How do you select unique values in sql?

1003

---

What is sql and how does it work?

1178

---

Write a unique difference between a function and a stored procedure.

1003

---

Which join is default?

958

---

Is primary key a clustered index?

969

---

What makes a good primary key?

1046

---

What is an exception in PL/SQL? What are the two types of exceptions?

1313

---

Explain what is a subquery ?

1191

---

Does user triggers have entry for trigger with compilation errors?

1039

---

What is primary and foreign key?

1064

---