Interested to Buy Any Domain ? << Click Here >> for more details...
how many columns can a plsql table have
- 13 Answers
- 21007 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 index associated with a constraint?
What is a Tablespace?
How to invoke the data pump import utility?
which language is used to develop the oracle........?
Can a formula column be obtained through a select statement ?
What is the difference between SQL and SQL Server?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What is the purpose of save points in oracle database?
Which are the five query types available in oracle?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
Explain oracle’s server parameter file.
When do you get a .pll extension in oracle? Explain its importance
Oracle General 
