Differentiate between function and procedure in oracle.
No Answer is Posted For this Question
Be the First to Post Answer
What's dateware house and what's clustor with practicle example
what is primary key and foreign key when and where have to use
How to view the tablespaces in the current database?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
How you open and close a cursor variable.Why it is required?
What is oracle join syntax?
Can u make a synonym for deptno=10 only from emp table.
what is insert all statement in sql
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain the use of indexes option in exp command.
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How to define an external table with a text file?