Set, setup

Set, setup

SQL> set echo on ----------------- set whether to display the statement when running the command

SQL> set feedback on ---------------- set to show "XX rows selected"

SQL> set colsep | ----------------- sets the delimiter between a column and a column.

SQL> set pagesize 10 ---------------- set the number of rows per page

SQL> SET SERVEROUTPUT ON ----------- SET to allow display of output similar to dbms_output.putline

SQL> set heading on ---------------- set the display column name

SQL> set timing on ----------------- set to display "time in use: XXXX"

SQL> set time on ------------------ set to display the current time

SQL> set autotrace on ---------------- set to allow analysis of executed SQL statements

 

 

The DBMS_METADATA.GET_DDL package obtains the ddl script of the database object. As follows (executed in SQLPLUS ):
1. Get the ddl statement of a table:

SET SERVEROUTPUT ON
Set linesize 1000
SET FEEDBACK OFF
Set long 999999 ------ incomplete display
Set pagesize 1000 ---- Paging
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM (DBMS_METADATA.SESSION_TRANSFORM, 'store', false); --- SELECT DBMS_METADATA.GET_DDL ('table', 'tcc _ NE_FRAME ') from dual;

SELECT DBMS_METADATA.GET_DDL ('table', 'tcc _ NE_SNAP ') from dual;

 

2. Obtain the ddl statements for all tables, indexes, and stored procedures of a user.

SET SERVEROUTPUT ON
Set linesize 1000
SET FEEDBACK OFF
Set long 999999 ------ incomplete display
Set pagesize 1000 ---- Paging
--- Remove multiple parameters such as storage
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM (DBMS_METADATA.SESSION_TRANSFORM, 'store', false );

SELECT DBMS_METADATA.GET_DDL (U. OBJECT_TYPE, u. object_name)
FROM USER_OBJECTS u
Where U. OBJECT_TYPE IN ('table', 'index', 'Procedure ');

3. Obtain the ddl statements for all tablespaces.

SET SERVEROUTPUT ON
Set linesize 1000
SET FEEDBACK OFF
Set long 999999 ------ incomplete display
Set pagesize 1000 ---- Paging
--- Remove redundant parameters such as storage

SELECT DBMS_METADATA.GET_DDL ('tablespace', TS. tablespace_name)
FROM DBA_TABLESPACES TS;

4. Obtain the ddlSET SERVEROUTPUT ON
Set linesize 1000
SET FEEDBACK OFF
Set long 999999 ------ incomplete display
Set pagesize 1000 ---- Paging
--- Remove redundant parameters such as storage

SELECT DBMS_METADATA.GET_DDL ('user', U. username)
FROM DBA_USERS U; in addition, if the package cannot be executed, You need to correctly install the corresponding package.

What is SET on a car?

These are cruise speed control marks. SETRSM = resume accel = ACCELERATECST = COAST if you want to use cruise speed control, first press the [ON] button to start the cruise speed control function. (This is how most Ford cars start ). When you want to SET the cruise speed, speed up the car to the predetermined speed, and press the [SET] button. At this time, the speed of a car is usually greater than 30 miles per hour (about 48 kilometers per hour ). When using the cruise speed control, if you step on the brakes, the cruise speed control will stop working. Click the [RSM] button to restore the cruise speed control function. The speed will return to the previously set standard. When using the cruise speed control, press the [ACCEL] button to increase the cruise speed. When using the cruise speed control, press the [CST] button to reduce the cruise speed.

What is SET on a car?

These are cruise speed control marks. SETRSM = resume accel = ACCELERATECST = COAST if you want to use cruise speed control, first press the [ON] button to start the cruise speed control function. (This is how most Ford cars start ). When you want to SET the cruise speed, speed up the car to the predetermined speed, and press the [SET] button. At this time, the speed of a car is usually greater than 30 miles per hour (about 48 kilometers per hour ). When using the cruise speed control, if you step on the brakes, the cruise speed control will stop working. Click the [RSM] button to restore the cruise speed control function. The speed will return to the previously set standard. When using the cruise speed control, press the [ACCEL] button to increase the cruise speed. When using the cruise speed control, press the [CST] button to reduce the cruise speed.