how many columns can a plsql table have
- 13 Answers
- 19267 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 an Integrity Constrains ?
What is a sub query and what are the different types of subqueries?
What are the different types of synonyms?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
Explain an extent?
How to drop a tablespace?
How to run create database statement again?
where do i find oracle interview questions.
What is Public Database Link ?
Display the records between two range?
Can we call a trigger inside a function and function inside a trigger? Give example.
Explain rename?
Oracle General 
