What does `(+)` do in a where clause?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
How to create a stored procedure in oracle?
what is normalisation?what are its uses?
Is there a function to split a string in plsql?
How many categories of data types in oracle?
how to find count rows in table without count function?
What is the exact use of Collections?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How many memory layers are in the shared pool?
Explain what are clusters?
17. Display the order number and average item cost for each order.
Give syntax for SQL and ORACLE joins.