how many columns can a plsql table have
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 |
How to run create database statement?
What a SELECT FOR UPDATE cursor represent.?
which statement is running fastly ie insert or delete?
What is SQL Tuning Advisor in Oracle?
What are cursor?where are they used?
Explain the use of show option in imp command.
How does Oracle guarantee data integrity of data changes?
What is a connect identifier?
What is a sub query? What are its various types?
What is an oracle tablespace?
How to use values from other tables in update statements using oracle?
Explain do view contain data?