how many columns can a plsql table have

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create lov dynamically at runtime & attach to text field?

666


Explain the difference between a procedure and a function? What do you understand by those terms?

625


What is the usage of analyze command in oracle?

615


List out the difference between commit, rollback, and savepoint?

622


Please explain joins in oracle?

550






Use of an integrity constraint is better to validate data. Explain

547


Explain integrity constraints?

670


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

548


State and explain about oracle instance?

551


What is a system tablespace?

602


What is the database name in oracle?

536


What is max rowid in oracle?

560


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

998


Query to retrieve record for a many to many relationship ?

2081


How to use an explicit cursor without open statements?

616