Interested to Buy Any Domain ? << Click Here >> for more details...
how many columns can a plsql table have
- 13 Answers
- 21813 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 |
Can we create trigger on materialized view in oracle?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
13. Display the second to fifth characters in each client name.
Can a field be used in a report without it appearing in any data group ?
What is set verify off in oracle?
what is null value?
How a tablespace is related to data files?
What is a materialised view?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is sequence?
Explain what are the advantages of views?
Can we call a trigger inside a function and function inside a trigger? Give example.
Oracle General 
