利用管道在SQL中实现查询分页显示和筛选

desc dbms_sqltune"|sqlplus / as sysdba | more SQL*Plus: Release 11.2.0.4.0 Production on Sat Sep 24 13:04:17 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> FUNCTION ACCEPT_SQL_PROFILE RETURNS VARCHAR2 Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- TASK_NAME VARCHAR2 IN OBJECT_ID NUMBER IN DEFAULT NAME VARCHAR2 IN DEFAULT DESCRIPTION VARCHAR2 IN DEFAULT --More--

 

筛选：

[oracle@zytk32 ~]$ echo "desc dbms_sqltune"|sqlplus / as sysdba | grep DROP
PROCEDURE DROP_SQLSET
PROCEDURE DROP_SQL_PROFILE
PROCEDURE DROP_TUNING_TASK

 

[oracle@zytk32 ~]$ echo "desc dbms_sqltune"|sqlplus / as sysdba | grep DROP_SQL_PROFILE -A 7    //从匹配字符处开始再往下显示7行
PROCEDURE DROP_SQL_PROFILE
 Argument Name            Type            In/Out Default?
 ------------------------------ ----------------------- ------ --------
 NAME                VARCHAR2        IN
 IGNORE             BOOLEAN         IN     DEFAULT
PROCEDURE DROP_TUNING_TASK
 Argument Name            Type            In/Out Default?
 ------------------------------ ----------------------- ------ --------

 

利用管道在SQL中实现查询分页显示和筛选

标签：