What is the maximum line size that dbms_output can handle?



What is the maximum line size that dbms_output can handle?..

Answer / Vakeel Chand

"The maximum line length for DBMS_OUTPUT in Oracle depends on the client and database settings. By default, it is 80 characters, but this limit can be modified using ALTER SESSION or INIT.ORA parameters."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What are the advantages of database system?

1 Answers  


What is data model and types?

1 Answers  


what is the difference between delete and truncate?

4 Answers  


What is the use of FILE option in IMP command ?

1 Answers  


Define atomicity and aggregation.

1 Answers  


What is index hunting?

1 Answers  


What is the use of OWNER option in EXP command ?

1 Answers  


Enlist various transaction phases.

1 Answers  


when All datafiles related to a Tablespace are removed ?

1 Answers  


How to Perform Data Cleaning and Preprocessing?

1 Answers  


What is the best database to use?

1 Answers  


What are the advantages of using Query Strings?

1 Answers   MCN Solutions,


Categories