退出编辑器屏幕之后,SQL 菜单将再次打开,同时突出显示“运行”选项,并且在屏幕底
部显示语句文本。您可以使用“运行”选项来运行大部分 SQL 语句。
要运行未列出的语句,请使用 SQL 菜单选项“新建”(或“使用编辑器”)和“保存”来
输入并保存语句,然后从命令行运行已保存的文件。
以下是可使用“运行”选项运行的 SQL 语句的列表。
l
ALLOCATE COLLECTION
l
ALLOCATE DESCRIPTOR
l
ALLOCATE ROW
l
ALTER ACCESS_METHOD
l
ALTER FRAGMENT
GBase 8s DB-Access 用户指南
南大通用数据技术股份有限公司 - 24 -
l
ALTER FUNCTION
l
ALTER INDEX
l
ALTER PROCEDURE
l
ALTER ROUTINE
l
ALTER SECURITY LABEL COMPONENT
l
ALTER SEQUENCE
l
ALTER TABLE
l
BEGIN WORK
l
CLOSE
l
CLOSE DATABASE
l
COMMIT WORK
l
CONNECT
l
CREATE ACCESS_METHOD
l
CREATE AGGREGATE
l
CREATE CAST
l
CREATE DATABASE
l
CREATE DISTINCT TYPE
l
CREATE EXTERNAL TABLE
l
CREATE FUNCTION
l
CREATE FUNCTION FROM
l
CREATE INDEX
l
CREATE OPAQUE TYPE
l
CREATE OPCLASS
l
CREATE PROCEDURE
l
CREATE ROLE
l
CREATE ROUTINE FROM
GBase 8s DB-Access 用户指南
南大通用数据技术股份有限公司 - 25 -
l
CREATE ROW TYPE
l
CREATE SCHEMA
l
CREATE SECURITY LABEL COMPONENT
l
CREATE SECURITY LABEL
l
CREATE SECURITY POLICY
l
CREATE SEQUENCE
l
CREATE SYNONYM
l
CREATE TABLE
l
CREATE TRIGGER
l
CREATE VIEW
l
CREATE XADATASOURCE
l
CREATE XADATASOURCE TYPE
l
DATABASE
l
DEALLOCATE COLLECTION
l
DEALLOCATE DESCRIPTOR
l
DEALLOCATE ROW
l
DECLARE
l
DELETE
l
DESCRIBE
l
DESCRIBE INPUT
l
DISCONNECT
l
DROP ACCESS METHOD
l
DROP AGGREGATE
l
DROP CAST
l
DROP DATABASE
l
DROP FUNCTION
GBase 8s DB-Access 用户指南
南大通用数据技术股份有限公司 - 26 -
l
DROP INDEX
l
DROP OPAQUE TYPE
l
DROP OPCLASS
l
DROP PROCEDURE
l
DROP ROLE
l
DROP ROW TYPE
l
DROP SECURITY LABEL COMPONENT/POLICY/LABEL
l
DROP SEQUENCE
l
DROP SYNONYM
l
DROP TABLE
l
DROP TRIGGER
l
DROP TYPE
l
DROP VIEW
l
DROP XADATASOURCE
l
DROP XADATASOURCE TYPE
l
EXECUTE
l
EXECUTE FUNCTION
l
EXECUTE IMMEDIATE
l
EXECUTE PROCEDURE
l
FETCH
l
FLUSH
l
FREE
l
GET DESCRIPTOR
l
GET DIAGNOSTICS
l
GRANT
l
GRANT DBSECADM
GBase 8s DB-Access 用户指南
南大通用数据技术股份有限公司 - 27 -
l
GRANT DEFAULT ROLE
l
GRANT EXEMPTION
l
GRANT FRAGMENT
l
GRANT SECURITY LABEL
l
INFO
l
INSERT
l
LOAD
l
LOCK TABLE
l
MERGE
l
OPEN
l
OUTPUT
l
PREPARE
l
PUT
l
RENAME COLUMN
l
RENAME DATABASE
l
RENAME INDEX
l
RENAME SEQUENCE
l
RENAME TABLE
l
REVOKE
l
REVOKE DBSECADM
l
REVOKE DEFAULT ROLE
l
REVOKE EXEMPTION
l
REVOKE FRAGMENT
l
REVOKE SECURITY LABEL
l
ROLLBACK WORK
l
SAVE EXTERNAL DIRECTIVES
GBase 8s DB-Access 用户指南
南大通用数据技术股份有限公司 - 28 -
l
SELECT
l
SET AUTOFREE
l
SET COLLATION
l
SET CONNECTION
l
SET CONSTRAINTS
l
SET DATASKIP
l
SET DEBUG FILE TO
l
SET DEFERRED PREPARE
l
SET DESCRIPTOR
l
SET ENCRYPTION PASSWORD
l
SET ENVIRONMENT
l
SET EXPLAIN
l
SET ISOLATION
l
SET LOCK MODE
l
SET LOG
l
SET OPTIMIZATION
l
SET PDQPRIORITY
l
SET ROLE
l
SET SESSION AUTHORIZATION
l
SET STATEMENT CACHE
l
SET TRANSACTION
l
START VIOLATIONS TABLE
l
STOP VIOLATIONS TABLE
l
TRUNCATE
l
UNLOAD
l
UNLOCK TABLE
GBase 8s DB-Access 用户指南
南大通用数据技术股份有限公司 - 29 -
l
UPDATE
l
UPDATE STATISTICS
l
WHENEVER