Answer Posted / karthik

SELECT 'NISHI' NAME FROM DUAL;

COLUMN NAME FORMAT A1
/

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2204

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1795

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046

---

How to define a data source name (dsn) in odbc manager?

968

---

How to select some rows from a table in oracle?

1008

---

What are the oracle differences between nvl and coalesce

1069

---

How to export several tables together?

990

---

How to compare dates in oracle sql?

1043

---

How to loop through data rows in the implicit cursor?

1016

---

How to convert a date to char in oracle? Give one example.

1003

---

Explain overloading. Can functions be overloaded?

937

---

How to rebuild an index in oracle?

976

---

How do I know if oracle client is installed on windows?

956

---

How to create a table index?

1063

---

How to handle a single quote in oracle sql?

975

---