473,322 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Sql output problem in SQLPLUS....

Dear All,
I am faceing a problem in sql output in SQLPLUS screen.I am explaining
the details..
================================================== ====================
SQL> desc accountmaster;
================================================== ====================
================================================== ====================
Output of the Command
================================================== ====================
================================================== ====================
Name Null? Type
----------------------------------------- --------
----------------------------
ACCOUNTCODE NOT NULL NUMBER(10)
NAMEOFACCOUNT VARCHAR2(100)
SUPERCODE NUMBER(10)
OPENINGAMOUNT NUMBER(10,2)
ACCOUNTGROUP VARCHAR2(20)
SUBLEDGER CHAR(1)
PAN VARCHAR2(20)
ADDRESS1 VARCHAR2(70)
ADDRESS2 VARCHAR2(70)
ADDRESS3 VARCHAR2(70)
CREDITLIMIT NUMBER(10,2)
CREDITDAYS NUMBER(10)
DOC VARCHAR2(10)
================================================== ========================
SQL> select * from accountmaster where accountcode=7;
================================================== ========================
================================================== ========================
Output of the command
================================================== ========================
================================================== ========================
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
7

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
Reserves & Surplus (Retained Earnings)

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
0 0 01 T

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
0 0

ACCOUNTCODE
-----------
NAMEOFACCOUNT
--------------------------------------------------------------------------------
SUPERCODE OPENINGAMOUNT ACCOUNTGROUP S PAN
---------- ------------- -------------------- - --------------------
ADDRESS1
----------------------------------------------------------------------
ADDRESS2
----------------------------------------------------------------------
ADDRESS3
----------------------------------------------------------------------
CREDITLIMIT CREDITDAYS DOC
----------- ---------- ----------
SQL>
================================================== ==============
Instead of thesemuch multiple rows I want to see the output in single
row with no wrap.
Please suggest me how to do this????
Regards
Arijit Chatterjee
Jul 19 '05 #1
2 12775
Arijit Chatterjee wrote:
Dear All,
I am faceing a problem in sql output in SQLPLUS screen.I am explaining
the details..
================================================== ==================== Instead of thesemuch multiple rows I want to see the output in single
row with no wrap.
Please suggest me how to do this????
Regards
Arijit Chatterjee


Dear Arijit

It is time to Read The Fantastic Manual. The one at http://docs.oracle.com
(follow the link to your version of the dtabase, then to 'View Library',
'List Books' and SQL*Plus Reference Manual or SQLPlus Quick Reference
Guide.)

Your requirements are resolved by a combination of setting column size,
column format and line width, and I simply can not tell you the right
values. Look up the syntax for SET LINEWIDTH and COLUMN

/Hans
Jul 19 '05 #2
Respected Sir,
Thanks for your guidance.I opened Sqlplus window then
Options -> Environment -> LineSize
Set to custom and put the value 1000.
Now it is showing perfectly.
Regards
Arijit Chatterjee
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: 91YJ_Renegade | last post by:
why can I TNSPING but I can not connect using SQLPLUS? Oracle 10g Slackware 10 install 2.6.6 kernel exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i...
0
by: tyousaf | last post by:
Hi i am new to mysql and mysql++, i have installed mysql server, it is running fine. i also installed "mysql++-1.7.9gcc3.2-2.i386.rpm" (i have gcc 3.3) , first of all as the readme file says to do...
1
by: hafertepen | last post by:
preventing sqlplus output to terminal from UNIX - I've forgot, please help!
3
by: eeriehunk | last post by:
Hi, I wrote a shell script where I connect to an oracle db(the connection works because I able to see the DBMS output) and I execute a procedure, but I am not able to get the return value from...
1
by: pssraju | last post by:
Hi, I am not sure whether I am posting it in right location as i cant see any shell scripting forum here. Below script works perfectly fine from command line, but when I run through browser I am...
0
by: dolphin123 | last post by:
Hi, How can i redirect the output of an sql select query to a tab delimited text file and to an excel file using perl script. I use , system("sqlplus / \@$my_folder/qry.sql"); to call...
0
by: Mark D Powell | last post by:
getamit23@rediffmail.com (Amit Kapoor) wrote in message news:<c33bca54.0307090046.7698321f@posting.google.com>... The Windows version of sqlplus should be part of the Oracle client install for...
2
by: Arijit Chatterjee | last post by:
Dear All, I am faceing a problem in sql output in SQLPLUS screen.I am explaining the details.. ====================================================================== SQLdesc accountmaster;...
1
by: LaoDe | last post by:
Hi, I want to catch a select-result into perl-variable, like this (on Linux): $C = system ("sqlplus $DBUSER/$DBPW \@getcolnam.sql $TABNAM $TABOWNER "); Wenn I run this, I see Oracle's...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.