Give the constructs of a package, function or a procedure.
No Answer is Posted For this Question
Be the First to Post Answer
After using set unused can we enable the column again to use? Please give me some answers....
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.
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 do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is the difference between translate and replace in oracle?
What are the components of Logical database structure of ORACLE database?
What privilege is needed for a user to create views in oracle?
how to get the no employee in each department including the dept which has 0 employee
what is the exact definition for pointer?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
How to check the oracle tns settings?