Does it possible to pass object (or) table as an argument
to a remote procedure?
Answer / gogu s k
It is possible to pass table as argument to a procedure. This
feature used with Dynamic sql along ref cursor concept.In
dataware house environment tables are passed as argument to
|Is This Answer Correct ?||16 Yes||0 No|
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
What is an Exception ? What are types of Exception ?
When the mutating error will comes? and how it will be resolved?
what is explain plan?
Can a procedure in a package be overloaded?
Write a query to find second highest salary of an employee.
What is Difference Between delete and Truncate?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
What is an intersect?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.