Interested to Buy Any Domain ? << Click Here >> for more details...
how many columns can a plsql table have
- 13 Answers
- 21541 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 flashback in Oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What are the basic element of Base configuration of an oracle Database ?
Difference between oracle's plus (+) notation and ansi join notation?
What are the trigger associated with image items ?
Does oracle partitioning improve performance?
What types of joins are used in writing subqueries?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What is an oracle?
How to check your oracle database 10g xe installation?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Oracle General 
