Answer Posted / r98

select to_char(sysdate,'ddsp-month-yyyysp') from dual;

How do I trace sql profiler?

919

---

What are the different types of sql commands?

1056

---

What is a native sql query?

971

---

What is trigger explain with example?

980

---

How do I copy a table in sql?

925

---

Why do we create stored procedures & functions in pl/sql and how are they different?

887

---

what is a composite primary key ? : Sql dba

996

---

What is posting?

990

---

How to run sql statements with oracle sql developer?

998

---

How to disable a trigger name update_salary?

1193

---

What is recursive stored procedure?

1045

---

What is substitution variable?

1000

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

955

---

What operators deal with null?

1024

---

what is column? : Sql dba

956

---