Answer Posted / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Does oracle use sql?

992

---

how many ways to get the current time? : Sql dba

1048

---

What is the difference between having clause and where clause?

1116

---

What is an implicit commit?

1104

---

Mention what are the benefits of pl/sql packages?

1159

---

Which normal form is best?

999

---

Why is normalization important?

1083

---

What is the basic structure of an sql?

1159

---

What are the types of sql commands?

1162

---

How do you update f as m and m as f from the below table testtable?

1931

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1094

---

give the syntax of grant and revoke commands? : Sql dba

1219

---

What is a sql driver?

1041

---

What is left join in postgresql?

1092

---

how to create a new table in mysql? : Sql dba

1035

---