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 |
Which is better Oracle or MS SQL? Why?
How to enter a new row into a table interactively?
find out first highest salary?
10 Answers Verinon Technology Solutions,
How to run queries on external tables?
Is it possible to split the print reviewer into more than one region ?
Why do we use bulk collect in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how to find out largest value in a table
What would you do if a database crashes in production?
Difference between the “verify” and “feedback” command?
What is a tns file?
What is program global area (pga) in oracle?