本文介绍了使用SQL*Plus时的一些实用技巧，包括如何通过分号终止SQL语句、如何编辑最近输入的SQL语句以及如何运行存储在文件中的SQL脚本。
1: SQL statements directly entered into SQL*Plus are terminated using a semicolon character (;)
2:You can edit your last SQL statement in SQL*Plus by entering EDIT. This is useful when you make a mistake or you want to make a change to your SQL statement. In Windows, when you enter EDIT you are taken to the Notepad application; you then use Notepad to edit your SQL statement. When you exit Notepad and save your statement, the statement is passed to SQL*Plus where you can re-execute it.
3:Run the store_schema.sql script from within SQL*Plus using the @ command
eg:@C:\SQL\store_schema.sql
4:
2:You can edit your last SQL statement in SQL*Plus by entering EDIT. This is useful when you make a mistake or you want to make a change to your SQL statement. In Windows, when you enter EDIT you are taken to the Notepad application; you then use Notepad to edit your SQL statement. When you exit Notepad and save your statement, the statement is passed to SQL*Plus where you can re-execute it.
3:Run the store_schema.sql script from within SQL*Plus using the @ command
eg:@C:\SQL\store_schema.sql
4:
扫一扫
28
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
