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 ?||14 Yes||0 No|
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
What is the difference between SQL and PLSQL
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
What is normalization? dec 2009
sql query to get zero records from a table having n no of records
how will i became good database developer?
When do we create bitmap indexes
Explain the usage of WHERE CURRENT OF clause in cursors ?
Explain how procedures and functions are called in a PL/SQL block ?
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
what is the difernece between named and anonymous pl/sql blocks??
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..