sql/plsql doubts [message #39155] |
Fri, 21 June 2002 05:54 |
Mallik
Messages: 5 Registered: April 2002
|
Junior Member |
|
|
1.how to insert more records at a time in nested tables
2.how can we retrive data from nested tables. if it is possible send the stored procedure.
3.what is advantages of ref & deref operators
4.What is the diffence between nested tables and pl/sql tables,records
5.i am tried to create partition on more than 1 field then
" partition bound list contains too few elements" this error is coming.so is it not possible to create partition on more than 1 field.if so send one example.
6.if i am given condition like this then the following error is displaying
create table ticket_det1(name varchar2(20),ticket_no number(5),sex char(1),age number(3),
fare number(5,2),constraint prim_part1 primary key(ticket_no)) partition by range (ticket_no)
(partition part1 values less than (1000),
partition part2 values less than (3000) and greater than(2000),
partition part3 values less than (5000))
/
error:-"this physical attribute may not be specified for a table partition"
how can we rectify the problem
7.What is the difference between abstract datatypes and object views
|
|
|
|