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 |
Explain oracle data types with examples?
What is varray?
Is oracle a language?
what are pseudocolumns?
How to view the tablespaces in the current database?
How to check your oracle database 10g xe installation?
What is Oracle table?
What would you do if a database crashes in production?
Explain the use of show option in imp command.
What is oracle host variable?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
why should i declare foreign key constraint as self relation instead of binary relation in tables ?