define join and explain different type of joins? : Sql dba

996

Which is better varchar or nvarchar?

1048

What does trigger mean in slang?

1119

Can you skip header records while loading? : aql loader

1100

Explain the advantages and disadvantages of stored procedure?

1198

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...

2495

How to assign sql query results to pl sql variables?

1140

What is the use of function "module procedure" in pl/sql?

1233

what are sequences

1812

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1063

How to read/write files from pl/sql?

1081

What do you think about pl/sql?

1110

explain about mysql and its features. : Sql dba

1049

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1390

What is oracle sql called?

972