problem with oracle 10g

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kittu532
    New Member
    • Jun 2007
    • 17

    problem with oracle 10g

    Hi,
    My name is krishna, here actually iam having problem oracle insert statement...... ...when i used to insert more than15 fields of data in to table the field name are been repeatedly getting printed........ .SO plzz help me...iam using oracle10g...... Thanks......... and this is my query......

    SQL> select * from sample;

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
    fdsfs sdfdsf sdfsd

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
    sdfs sfsd fdsfs

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
    sdfdsf sdfsd sdfs

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
    sfsd fdsfs sdfdsf

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
    sdfsd sdfs sfsd

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
    sdfgsd

    NAME INTIAL LAST
    -------------------- -------------------- --------------------
    FIRST SECOND THIRD
    -------------------- -------------------- --------------------
    FOURTH FIFTH SIXTH
    -------------------- -------------------- --------------------
    SEVENTH EIGTH NINTH
    -------------------- -------------------- --------------------
    TENTH ELEVENTH TWELTH
    -------------------- -------------------- --------------------
    THIRTEENTH
    --------------------
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    This problem arises when you INSERT or when you SELECT.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      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.

      Comment

      • kittu532
        New Member
        • Jun 2007
        • 17

        #4
        Hi Das,

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

        Comment

        • kittu532
          New Member
          • Jun 2007
          • 17

          #5
          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...........

          Comment

          Working...