Answer Posted / kamal

SELECT OWNER,OBJECT_NAME,TRUNC(CREATED),TIMESTAMP FROM
DBA_OBJECTS WHERE OBJECT_TYPE ='TABLE' AND OBJECT_NAME
='EMP'

Are stored procedures compiled?

522

---

How do you define a foreign key?

528

---

Explain what is table in a database?

569

---

What does pragma mean?

500

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

613

---

---

What pl/sql package consists of?

631

---

Can a view be mutating? If yes, then how?

570

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

610

---

What is difference between stored function and application function?

590

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

658

---

What is primary key and foreign key with example?

490

---

Is like operator in sql case sensitive?

504

---

what is the difference between char_length and length? : Sql dba

567

---

What is %rowtype in pl sql?

511

---

How do you respond to dementia behavior?

525

---