problem with oracle 10g - Oracle Database

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
--------------------

Jun 5 '07 #1

Subscribe Post Reply

1266

debasisdas

8,127

Expert 4TB

This problem arises when you INSERT or when you SELECT.

Jun 6 '07 #2

debasisdas

8,127

Expert 4TB

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.

Jun 6 '07 #3

kittu532

Hi Das,

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

Jun 6 '07 #4

kittu532

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

Jun 6 '07 #5

Similar topics

ASP problem with the Oracle ODBC driver

by: simianphile | last post by:

OK, I had a problem that I've now fixed but I can't really understand what was causing it in the first place. I have an intranet site that uses basic authentication to allow users to view and...

ASP / Active Server Pages

Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem

by: A. Fuentes | last post by:

Fellow Oracle Netters: I have the following problem: Enviroment: Oracle9i/AIX5.2/Veritas vxvm I am trying to create an Oracle database using RAW devices UNDER the Veritas vxvm.(Veritas...

Oracle Database

A simple Listener problem while installing Oracle by copying Ora Home

by: Cherrish Vaidiyan | last post by:

Hello all, A warm Xmas greetings to all. I have a small problem with starting up the database. Here my strategy. I have installed Oracle 9i R 2 on Red Hat 9. i created two database on this...

Oracle Database

Oracle ODBC connection problem

by: SerGioGio | last post by:

Hello, I am going nuts. I am trying to connect to my local ORACLE instance using ODBC. It used to work few weeks ago, but it fails now. Connection with: - SQL*plus: connection works! -...

Oracle Database

ASP / ADO / Oracle connection problem

by: Cliff Cooley | last post by:

Can anybody suggest what may be causing the following problem ? I have an ASP script that opens a connection to an Oracle database using a DSN connection string, such as : Set dbConn=...

ASP / Active Server Pages

problem making Oracle linked server work

by: Ellen K | last post by:

Hi all, I set up our Oracle Financials as a linked server to one of my SQL Server boxes. On running a test query, I got the following error message: OLE DB provider 'MSDAORA' supplied...

Microsoft SQL Server

Asp.net / iis / oracle problem

by: BookerW | last post by:

I am not sure which forum I should post this on, but here is the problem. I have a front end web application(VB) on asp,net 1.1 framework. Inside of the code, I have the following lines to...

ASP.NET

Problem with Information Integrator/Federated Datase - Oracle

by: Michael Rudolph | last post by:

Hi newsgroup, I have an issue with the configuration of a DB2 federated database (WebSphere Information Integrator) in conjunction with the relational wrapper for Oracle on AIX. DB2 seems to not...

DB2 Database

Federated (information integrator) load from cursor - Oracle date problem

by: peteh | last post by:

Hi All; We have many production jobs that "load from cursor" to a UDB/AIX 8.2 (with dpf) data warehouse from source tables residing Oracle 9i. Since Oracle dates are (roughly) equivalent to DB2...

DB2 Database

asp.net/vb / oracle problem

by: bw171 | last post by:

Hopefully, I frame this problem/question correctly. I have some code written/updated in visual studio 2003. This code when setup on other machines where I have installed the Oracle 9i client, and...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing