problem with oracle 10g

**debasisdas** · Jun 6 '07, 04:20 AM

This problem arises when you INSERT or when you SELECT.

**debasisdas** · Jun 6 '07, 04:33 AM

Hi it seems u r new to oracle

When u use SQL*PLUS as your editor to connect to oracel server.

By default it can display 80 CHARACTERS per line
and 14 LINES per PAGE.

which u can check by using

SQL>SHOW LINE LINES

and

SQL>SHOW PAGES

To change the default setting use For ex.

SQL>SET LINE 200 PAGES 50

line size can be 1 through 32767

and that of pages size max upto 50000

Try this out

Hope it helps u in solving your problem.

**kittu532** · Jun 6 '07, 03:58 PM

Hi Das,

Thanks for your help,iam really new to oracle.Any way thanks for your help once again.......... .........

**kittu532** · Jun 6 '07, 04:00 PM

Hi,
And do have any idea about how to store the excel file information into oracle database through java........... ............

i will be very thankfull if help me...........

problem with oracle 10g

problem with oracle 10g

Comment

Comment

Comment

Comment