What are the different datatypes available in PL/SQL?
What do you mean by stored procedures? How do we use it?
what is clause? : Sql dba
What is the difference between row level and statement level trigger?
What is transaction control language (tcl)?
using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
what is a trigger? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
What are the advantages of stored procedure?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how many sql dml commands are supported by 'mysql'? : Sql dba
how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900
Can a table have two primary keys?