how many columns can a plsql table have

Answer Posted / vishal

A plsql table can hold to a maximum of 1000 columns.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sub query? What are its various types?

773


What are the oracle built-in data types?

735


Is there a combination of "like" and "in" in sql?

776


How to turn on or off recycle bin for the instance?

812


What happens if variable names collide with table/column names?

808






How can Oracle users be audited?

830


What is the quickest way to export a table to a flat file?

729


Can select statements be used on views in oracle?

752


Difference between hot backup vs. Cold backup?

758


How to use existing values in update statements using oracle?

768


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1810


Which is faster join or subquery in oracle?

710


How to start a specific oracle instance?

783


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

758


How a tablespace is related to data files?

769