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 ? | 13 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 difference between substr and instr function in oracle?
Explain about achiever in sql?
How to count duplicated values in a column in oracle?
What is oracle rownum?
What is java oracle used for?
What does `(+)` do in a where clause?
What is meant by redo log buffer ?
What is the function of Optimizer ?
what is the syntax of SELECT command?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
How do we get field detail of a table?
what is dynamic SGA and static SGA