Home Database Mysql Tutorial Oracle基础教程:SQLPLUS环境命令

Oracle基础教程:SQLPLUS环境命令

Jun 07, 2016 pm 05:11 PM

Oracle基础教程:SQLPLUS环境命令,sqlplus常用命令 当输入SQL语句时,SQL在SQLPLUS里的缓存中,这个缓存很小,只能允许一个SQL语句

sqlplus常用命令
 当输入SQL语句时,SQL在SQLPLUS里的缓存中,这个缓存很小,只能允许一个SQL语句,当下一个SQL输入时,上一个SQL就被覆盖了
 为了更有效的输入和编辑SQL语句,SQLPLUS提供了一些常用命令,与SQL语句相比,SQLPLUS里的命令可以缩写.
 
 查看sqlplus里的所有命令
 help index
 查看sqlplus里某个命令的帮助
 help cmd
 
 show all 列出所有当前参数值
 
set line[size]{80|n}
 设置显示宽度 默认是80 n可以自己定义
 set line 100
l列出当前缓冲区内容
n整数.缓冲区中的指定行号
c/OLD/NEW 替换 NEW部分不写则是删除的意思
/ 或 r 运行
a 追加内容 一般和n先提取行后追加
del n 删除第n行的整行

1.输入错误的修正 方法一:
 seker> select ename,sal
   2  from emq
   3  where sal  from emq
      *
 ERROR at line 2:
 ORA-00942: table or view does not exist
 执行后发现输入错误

 seker> l 
   1  select ename,sal
   2  from emq
   3* where sal  L列出命令清单 发现第2行emp写成emq

 seker> 2
   2* from emq
 N命令提取指定行

 seker> c/q/p
   2* from emp
 c/OLD/NEW 替换

 seker> l
   1  select ename,sal
   2  from emp
   3* where sal  列出当前的缓冲区查看

 seker> /
 
 ENAME    SAL
 ---------- ----------
 SMITH    800
 JAMES    950
 
 seker>
 /执行当前缓冲区的命令


2.输入错误的修正 方法二:
 seker> select ename,sal
   2  from emq
   3  where sal  from emq
      *
 ERROR at line 2:
 ORA-00942: table or view does not exist
 执行后发现输入错误

 seker> l
   1  select ename,sal
   2  from emq
   3* where sal  L列出命令清单 发现第2行emp写成emq

 seker> 2 from emp
 n text 命令修改指定行的内容

 seker> r
   1  select ename,sal
   2  from emp
   3* where sal

 ENAME    SAL
 ---------- ----------
 SMITH    800
 JAMES    950

 seker> 
 r执行当前缓冲区的命令
 
 a 追加操作
 seker> l
   1  select ename,sal
   2  from emp
   3* where sal  seker> 1
   1* select ename,sal
 seker> a ,job,deptno
   1* select ename,sal,job,deptno
 seker> l
   1  select ename,sal,job,deptno
   2  from emp
   3* where sal  seker> /

 ENAME    SAL JOB     DEPTNO
 ---------- ---------- --------- ----------
 SMITH    800 CLERK  20
 JAMES    950 CLERK  30

 seker>

 del n命令 不可以简写为d
 idle> l
   1  select ename,sal,job,deptno
   2  from emp
   3* where sal  idle> d 3
 SP2-0042: unknown command "d 3" - rest of line ignored.
 idle> del 3
 idle> l
   1  select ename,sal,job,deptno
   2* from emp
 idle>

将当前缓冲区的内容另存到文件
 idle> l
   1  select ename,sal,job,deptno
   2* from emp
 idle> save abc.sql
 Created file abc.sql
 idle> host ls
 abc.sql  afiedt.buf  Oracle  sqlnet.log
 
 idle> !cat abc.sql
 select ename,sal,job,deptno
 from emp
 /
 idle>
 

加载文件中的语句到缓冲区
 idle> l
   1* select * from emp
 idle> get abc.sql
   1  select ename,sal,job,deptno
   2* from emp
 idle> l
   1  select ename,sal,job,deptno
   2* from emp
 idle>

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Reduce the use of MySQL memory in Docker Reduce the use of MySQL memory in Docker Mar 04, 2025 pm 03:52 PM

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

How to solve the problem of mysql cannot open shared library How to solve the problem of mysql cannot open shared library Mar 04, 2025 pm 04:01 PM

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

How do you alter a table in MySQL using the ALTER TABLE statement? How do you alter a table in MySQL using the ALTER TABLE statement? Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Run MySQl in Linux (with/without podman container with phpmyadmin) Run MySQl in Linux (with/without podman container with phpmyadmin) Mar 04, 2025 pm 03:54 PM

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

What is SQLite? Comprehensive overview What is SQLite? Comprehensive overview Mar 04, 2025 pm 03:55 PM

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

Running multiple MySQL versions on MacOS: A step-by-step guide Running multiple MySQL versions on MacOS: A step-by-step guide Mar 04, 2025 pm 03:49 PM

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

How do I configure SSL/TLS encryption for MySQL connections? How do I configure SSL/TLS encryption for MySQL connections? Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

See all articles