how many columns can a plsql table have
- 13 Answers
- 19071 Views
- NIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
A plsql table can hold to a maximum of 1000 columns.
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / arvind kumar yadav
a table can have 1000 column in oracle 11g
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / subbareddy k
A table can have 1000 columns and 255 rows upto Oracle 8i.I
don't know in Oracle 9i.Please give proper answer
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vishal
A plsql table can hold to a maximum of 1000 columns.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / susil kumar rout
Generally pl/sql table can create at the run time.
It is virtual table contains 2 columns
1-binary index.
2-data type upon which pl/sql table is created.
example-
Type typename is table of emp.ename%type
index by binary_integer;
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the diff between Oracle and SQL Server
Point out the difference between user tables and data dictionary?
how to get second highest sal of emp table
Define Transaction ?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
what are pseudocolumns?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Give the constructs of a package, function or a procedure.
How to best split csv strings in oracle 9i?
What is autonomous transaction?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
is database gud carrier option??
Oracle General 
