Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQL table and the PLSQL
table?
- 3 Answers
- 18634 Views
- Mastek, I also Faced
- E-Mail Answers
Answer Posted / shivakanth reddy
In case sql table we use PRIMARY KEY to avoid duplicates and
null values.
But in case of PL/SQL PRIMARY KEY is used as an index to
ann array for accessing rows.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is faster join or subquery?
Explain the purpose of %type and %rowtype data types with the example?
What is sql scripting?
What are the commands used in sql?
What is primary key and foreign key?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What operating systems are supported by oracle sql developer?
Can we change the table name in sql?
Why does sql need a server?
What is indexing in sql and its types?
what is 'mysqlcheck'? : Sql dba
describe transaction-safe table types in mysql : sql dba
What packages are available to pl/sql developers?
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...
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
