Answer Posted / sowmya makkena

select floor(months_between(sysdate,'22-mar-1995')) "age in months" from dual;

what are all the different normalizations? : Sql dba

1122

---

How to get list of all tables from a database?

1211

---

What is the importance of sqlcode and sqlerrm?

1394

---

What are the types of views in sql?

1142

---

Is it possible to create the following trigger: before or after update trigger for each row?

1354

---

Does user triggers have entry for trigger with compilation errors?

1091

---

What is the difference between clustered and non-clustered indexes?

1132

---

How to take user input in pl sql?

1206

---

List the various privileges that a user can grant to another user?

1092

---

What is the difference between join and natural join?

984

---

Do ddl statements need commit?

1023

---

Name three sql operations that perform a sort.

1066

---

What is union and union all keyword in sql?

1111

---

What is the difference between local variables and global variables?

1180

---

How to use distinct and count in sql query? Explain

1086

---