How to input the data queried in SQL Plus?

sqlplus user/pwd@sid >

Write the SQL that queries the data, and add a at the end, you try.

When the result is output in Oracle's SQLPLUS, there is no result by default.

For example, sql> begin

2 dbms_'Results');

3 end;

It turned out to be nothing.

Workaround: Enter the command in sqlplus:

sql>set serveroutput on. Test.

sql> begin

2 dbms_'Results');

3 end;

There is no way to set the column width uniformly, but you can set the width according to the specific column name, use col .format ..method.

Character type :

sqlplus> col Column Name Format A10 This sentence specifies that the display width of the column name is 10 characters per line.

sqlplus> col column name format 99999 This is the set number type.

You can set up the usual ones in $Oracle Home SQLPLUS Admin, so you don't have to set them every time.

It seems to be in the setting of the window of sqlplus.

View the existing tables or mountain and land objects in the database balance: 1. select * from cat ; 2、 select * from tab ; 3、 select * from dba_objects ;

Some tables are abnormal, especially the tables that come with the system, and there are many fields.

However, tables like the ones we created ourselves can still be adjusted in the following ways:

set linesize 150;-150 indicates the number of characters displayed in each line, and you can change the appropriate size yourself.

If there are many fields, you need to set the cmd window width to be longer.

with justify

This can change the way the fields are displayed.

Usage: hole key.

column ename justify center;

column empno justify center;

I tried it, and I kind of forgot if it was written like this, and it seems to be. Nagaoqiao.