How write primary and foreign key relationship between two
tables without using constraints? u can use any of
procedure/function/trigger and any sql?
How to revise and re-run the last sql command?
How many types of cursors are available in pl/sql?
What is procedure in pl sql?
how can we find the number of rows in a table using mysql? : Sql dba
What is TABLE SPACE?
How can triggers be used for the table auditing?
write a query to delete similar records in particular fields(columns) in different tables
Why do we create views in sql?
How many joins in sql?
what are the advantages a stored procedure? : Sql dba
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
Cite the differences between execution of triggers and stored procedures?