sql 和 sqlplus工具

红太狼 2022-09-13 15:20 222阅读 0赞

sql -help
    SQLcl: Release 19.1.0.0 Production
    Oracle SQL Developer Command-Line (SQLcl) help
    
    Usage 1: sql -H | -V
    
        -H		   Displays the SQLcl version and the
    		   usage help.
        -V		   Displays the SQLcl version.
    
    Usage 2: sql  [<option>] [{ <logon> | /nolog}] [<start>] 
    
      <option> is:  [-R <level>] [-S] [-verbose] [-oci] [-L[OGON] ]
    
        -R <level>	Sets restricted mode to disable SQLcl commands
                    that interact with the file system.	The level can
                    be 1, 2, 3 or 4.  The most restrictive is -R 4 which
                    disables all user commands interacting with the
                    file system.
        -S	        Sets silent mode which suppresses the display of
                    the SQLcl banner, prompts, and echoing of
                    commands.
        -verbose    Set this to show logging messages inline.
                    By default these messages are suppressed.
        -nohistory  Switch off history logging.
        -noupdates  Do not check update site for newer versions available.
        -oci        Set this to use an Oracle Instant Client installation.
                    If this option is set, then SQLcl will use the drivers
                    from the first Installation on the path.
        -L[OGON]    Specifies not to reprompt for username or password 
                    if the initial connection does not succeed.
    
      <logon> is: {<username>[/<password>][@<connect_identifier>] | / }
    	      [AS {SYSDBA | SYSOPER | SYSASM}] 
    
        Specifies the database account username, password and connect
        identifier for the database connection.  Without a connect
        identifier, SQLcl connects to the default database.
    
        The AS SYSDBA, AS SYSOPER and AS SYSASM  options are database
        administration privileges.
    
        <connect_identifier> can be in the form of Net Service Name
        or Easy Connect.
    
          @[<net_service_name> | [//]Host[:Port]/<service_name>]
    
    	<net_service_name> is a simple name for a service that resolves
    	to a connect descriptor.
    
    	Example: Connect to database using Net Service Name and the
    		 database net service name is ORCL.
    
    	   sql myusername/mypassword@ORCL
    
    	Host specifies the host name or IP address of the database
    	server computer.
    
    	Port specifies the listening port on the database server.
    
    	<service_name> specifies the service name of the database you
    	want to access.
    
    	Example: Connect to database using Easy Connect and the
    		 Service name is ORCL.
    
    	   sql myusername/mypassword@Host/ORCL
    
        The /NOLOG option starts SQLcl without connecting to a
        database.
    
    
      <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
    
        Runs the specified SQLcl script from a web server (URL) or the
        local file system (filename.ext) with specified parameters that
        will be assigned to substitution variables in the script.
    
    When SQLcl starts, and after CONNECT commands, the site profile
    (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
    (e.g. login.sql in the working directory) are run.  The files may
    contain SQLcl commands.
    
    Refer to the SQLDeveloper User's Guide and Reference for more information.

sqlplus -help
    
    SQL*Plus: Release 19.0.0.0.0 - Production
    Version 19.12.0.0.0
    
    Copyright (c) 1982, 2021, Oracle.  All rights reserved.
    
    Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.
    
    Usage 1: sqlplus -H | -V
    
        -H		   Displays the SQL*Plus version and the
    		   usage help.
        -V		   Displays the SQL*Plus version.
    
    Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]
    
      <option> is: [-C <version>] [-F] [-L] [-M "<options>"] [-NOLOGINTIME]
    	       [-R <level>] [-S]
    
        -C <version>   Sets the compatibility of affected commands to the
    		   version specified by <version>.  The version has
    		   the form "x.y[.z]".	For example, -C 10.2.0
        -F		   This option improves performance in general. It changes
    		   the default values settings.
    		   See SQL*Plus User's Guide for the detailed settings.
        -L		   Attempts to log on just once, instead of
    		   reprompting on error.
        -M "<options>" Sets automatic HTML or CSV markup of output.  The options
    		   have the form:
    		   {HTML html_options|CSV csv_options}
    		   See SQL*Plus User's Guide for detailed HTML and CSV options.
        -NOLOGINTIME   Don't display Last Successful Login Time.
        -R <level>	   Sets restricted mode to disable SQL*Plus commands
    		   that interact with the file system.	The level can
    		   be 1, 2 or 3.  The most restrictive is -R 3 which
    		   disables all user commands interacting with the
    		   file system.
        -S		   Sets silent mode which suppresses the display of
    		   the SQL*Plus banner, prompts, and echoing of
    		   commands.
    
      <logon> is: {<username>[/<password>][@<connect_identifier>] | / }
    	      [AS {SYSDBA | SYSOPER | SYSASM | SYSBACKUP | SYSDG
    	      | SYSKM | SYSRAC}] [EDITION=value]
    
        Specifies the database account username, password and connect
        identifier for the database connection.  Without a connect
        identifier, SQL*Plus connects to the default database.
    
        The AS SYSDBA, AS SYSOPER, AS SYSASM, AS SYSBACKUP, AS SYSDG,
        AS SYSKM and AS SYSRAC options are database administration privileges.
    
        <connect_identifier> can be in the form of Net Service Name
        or Easy Connect.
    
          @[<net_service_name> | [[//]Host[:Port]/<service_name>] |
    	[[[protocol:]//]host1{,host12}[:port1]{,host2:port2}[/service_name]
    	 [:server][/instance_name][?[parameter_name=value]
    	 {&parameter_name=value}]]]
    
    	<net_service_name> is a simple name for a service that resolves
    	to a connect descriptor.
    
    	Example: Connect to database using Net Service Name and the
    		 database net service name is ORCL.
    
    	   sqlplus myusername/mypassword@ORCL
    
    	Host specifies the host name or IP address of the database
    	server computer.
    
    	Port specifies the listening port on the database server.
    
    	<service_name> specifies the service name of the database you
    	want to access.
    
    	Example: Connect to database using Easy Connect and the
    		 Service name is ORCL.
    
    	   sqlplus myusername/mypassword@Host/ORCL
    
        The /NOLOG option starts SQL*Plus without connecting to a
        database.
    
        The EDITION specifies the value for Session Edition.
    
    
      <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
    
        Runs the specified SQL*Plus script from a web server (URL) or the
        local file system (filename.ext) with specified parameters that
        will be assigned to substitution variables in the script.
    
    When SQL*Plus starts, and after CONNECT commands, the site profile
    (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
    (e.g. login.sql in the working directory) are run.  The files may
    contain SQL*Plus commands.
    
    Refer to the SQL*Plus User's Guide and Reference for more information.