How to get SQL help in sqlplus? - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - How to get SQL help in sqlplus?

相关主题
● editting .sql file problem	● how to setup shortcut to insert a command in Oracle sql shell?
● SQL Server stupid questions	● 问一个store procedure 问题
● 公司要升级了，问题	● SQL question
● Re: [转载] JDBC用完了oracle的large pool (memor	● a simple question about T-SQL
● use emacs as oracle client	● Problem when using SQL " Insert...." to AutoNumber.
● Urgent help!!!	● 如何在oracle8i中得到视图和表的定义?
● How to creat user in Oracle?	● Is Oracle ODBC support batch SQL(PL/SQL procedure)?
● 一个奇怪的问题	● Oracle SQL*Plus 的密码是啥阿？

相关话题的讨论汇总
话题: sql话题: sqlplus话题: backspace话题: get话题: blank

进入Database版参与讨论

1

(共1页)

a***n 发帖数: 1616	1 就象unix shell里的man一样。。。要所有SQL的syntax... sqlplus help本身那几条命令太不常用了:) 还有，我sqlplus里怎么不能backspace呢，出来的是^[[D:( 我还想sqlplus能上下键浏览命令历史。。。怎么整？(linux) 谢了。
n********a 发帖数: 68	2 This " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90843/toc.htm and this " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/toc.htm SQL> define _editor="emacs" And then type edit will pop emacs for you to edit last query. You can set editor to your favorite if it is not emacs, like vi. sqlplus can only edit previous query, not the whole history. This is different than linux or MySQL. 【在 a***n 的大作中提到】 : 就象unix shell里的man一样。。。要所有SQL的syntax... : sqlplus help本身那几条命令太不常用了:) : 还有，我sqlplus里怎么不能backspace呢，出来的是^[[D:( : 我还想sqlplus能上下键浏览命令历史。。。 : 怎么整？(linux) 谢了。
a***n 发帖数: 1616	3 不是这个。我不是想要sqlplus本身的online help. 我要这样的：比如： help CREATE DATABASE help INSERT help UPDATE help CREATE TABLE help SELECT 然后出来的是SQL的格式定义原文(不要简化版，当然有sample更好:P) //当然我offline的去网上找SQL的语法也能找到一些。。。 //可是没一个是语法的定义，都是一些简单示例的罗列。。。呵呵，backspace今天突然好了。。。昨天还不行的。我今天试了几下ctrl-H也是^[[D，然后试ctrl-backspace然后就可以了现在寡按backspace也成了。。。真是诡异。。。 oh. I see. 我还不如copy/paste呢:) 【在 n********a 的大作中提到】 : : This : " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90843/toc.htm : and this : " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/toc.htm : SQL> define _editor="emacs" : And then type edit will pop emacs for you to edit last query. : You can set editor to your favorite if it is not emacs, like vi. : sqlplus can only edit previous query, not the whole history. : This is different than linux or MySQL.
n********a 发帖数: 68	4 Ok, here: " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/nav/sql_keywords.htm?remark=homepage and here: " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/toc.htm 【在 a***n 的大作中提到】 : : 不是这个。 : 我不是想要sqlplus本身的online help. : 我要这样的：比如： : help CREATE DATABASE : help INSERT : help UPDATE : help CREATE TABLE : help SELECT : 然后出来的是SQL的格式定义原文(不要简化版，当然有sample更好:P)
a***n 发帖数: 1616	5 Oh. I have this set of books:) didn't notice the home of this page has a sql syntax help:) that's cool! Thanks! 【在 n********a 的大作中提到】 : : Ok, here: : " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/nav/sql_keywords.htm?remark=homepage : and here: : " target="_blank" class="a2">http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/toc.htm

1

(共1页)

进入Database版参与讨论

相关主题
● Oracle SQL*Plus 的密码是啥阿？	● use emacs as oracle client
● how to test the database, or test SQL?	● Urgent help!!!
● How to send BLOB images to remote database?	● How to creat user in Oracle?
● Help on Sql server huge table performance	● 一个奇怪的问题
● editting .sql file problem	● how to setup shortcut to insert a command in Oracle sql shell?
● SQL Server stupid questions	● 问一个store procedure 问题
● 公司要升级了，问题	● SQL question
● Re: [转载] JDBC用完了oracle的large pool (memor	● a simple question about T-SQL

相关话题的讨论汇总
话题: sql话题: sqlplus话题: backspace话题: get话题: blank

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)