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 ? | 13 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 are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to view all columns in an existing table?
Explain the relationship among Database, Tablespace and Data file?
How do I start tns listener?
Explain integrity constraint?
What are the roles of dba?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to turn on or off recycle bin for the session?