网络编程 | 站长之家 | 网页制作 | 图形图象 | 操作系统 | 冲浪宝典 | 软件教学 | 网络办公 | 邮件系统 | 网络安全 | 认证考试 | 系统进程
Firefox | IE | Maxthon | 迅雷 | 电驴 | BitComet | FlashGet | QQ | QQ空间 | Vista | 输入法 | Ghost | Word | Excel | wps | Powerpoint
asp | .net | php | jsp | Sql | c# | Ajax | xml | Dreamweaver | FrontPages | Javascript | css | photoshop | fireworks | Flash | Cad | Discuz!
当前位置 > 网站建设学院 > 网络编程 > 数据库 > Oracle教程
Tag:注入,存储过程,分页,安全,优化,xmlhttp,fso,jmail,application,session,防盗链,stream,无组件,组件,md5,乱码,缓存,加密,验证码,算法,cookies,ubb,正则表达式,水印,索引,日志,压缩,base64,url重写,上传,控件,Web.config,JDBC,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,IIS,Apache,Tomcat,phpmyadmin,Gzip,触发器,socket
数据库:数据库教程,数据库技巧,Oracle教程,MySQL教程,Sybase教程,Access教程,DB2教程,数据库安全,数据库文摘
本月文章推荐
.用JDBC连接Oracle数据库的十项技.
.Oracle字符值的比较和储存.
.Oracle数据库不完全恢复实例.
.Oracle 9i管理的用户.
.8i中回滚段使用和ORA-1555.
.在Oracle中存取BLOB对象实现文件.
.为数据库建立HTML分段使用映射.
.Oracle数据库中单行字符串函数简.
.将Oracle中的数据更改后出错的解.
.Orcale与Asp.net的端口冲突.
.调用存储过程时注意要使用output.
.Oracle Database与Oracle Instan.
.Oracle 9i取得建表和索引.
.自定义临时表实现及在Oracle Spa.
.查看哪些用户拥有SYSDBA、SYSOPE.
.ORACLE 10g调度例行任务解放DBA时.
.Oracle入门教程,新手必读.
.Oracle数据库技术(14).
.如何使特定用户具有smbmount上的.
.Oracle中有关于时间/日期方面的操.

配置UltraEdit为Oracle PL/SQL代码编辑器

发表日期:2008-2-9



  /L8"PL/SQL" Nocase Line Comment = -- Block Comment On = /* Block Comment Off = */ File Extensions = SQL
/Delimiters = ~!%@^&*()-+=\/{}[]:;"'<> ,  .?

/Function String = "%[A-Z _]*[~\s]+(*)"

/C1 "KeyWords"

  ABORT ACCEPT Access ADD ALL ALTER AND ANY ARRAY ARRAYLEN AS ASC ASSERT ASSIGN AT AUDIT AUTHORIZATION AVG

  BASE_TABLE BEGIN BETWEEN BINARY_INTEGER BODY BOOLEAN BY

  CASE CHAR CHAR_BASE CHECK CLOSE CLUSTER CLUSTERS COLAUTH COLUMN COMMENT COMMIT COMPRESS CONNECT CONSTANT CRASH CREATE CURRENT CURRVAL CURSOR

  DATABASE DATA_BASE DATE DBA DEBUGOFF DEBUGON DECLARE DECIMAL DEFAULT   DEFINITION DELAY DELETE DESC DIGITS DISPOSE DISTINCT DO DROP

  ELSE ELSIF END ENTRY EXCEPTION EXCEPTION_INIT EXCLUSIVE EXISTS EXIT
FALSE FETCH FILE FLOAT FOR FORM FROM FUNCTION GENERIC GOTO GRANT GROUP

  HAVING

  IDENTIFIED IF IMMEDIATE IN INCREMENT INDEX INDEXES INDICATOR INITIAL INSERT INTEGER INTERFACE INTERSECT INTO IS

  LEVEL LIKE LIMITED LOCK LONG LOOP

  MAX MAXEXTENTS MIN MINEXTENTS MINUS MISLABEL MOD MODE

  NATURAL NATURALN NEW NEXTVAL NOAUDIT NOCOMPRESS NOLOGGING NOT NOWAIT NULL NUMBER NUMBER_BASE

  OF OFFLINE ON ONLINE OPEN OPTION OR ORDER OTHERS OUT

  PACKAGE PARTITION PCTFREE PCTUSED PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIOR PRIVATE PRIVILEGES PROCEDURE PUBLIC

  RAISE RANGE RAW REAL RECORD REF RELEASE REMR RENAME RESOURCE RETURN REVERSE REVOKE ROLLBACK ROW ROWID ROWLABEL ROWNUM ROWS ROWTYPE RUN

  SAVEPOINT SCHEMA SELECT SEPARATE SESSION SET SHARE SMALLINT SPACE SQL SQLCODE SQLERRM START STATEMENT STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE

  TABAUTH TABLE TABLES TASK TERMINATE THEN TO TRIGGER TRUE TYPE

  UID UNION UNIQUE UPDATE USE USER

  VALIDATE VALUES VARCHAR VARCHAR2 VARIANCE VIEW VIEWS

  WHEN WHENEVER WHERE WHILE WITH WORK WRITE

XOR

/C2 "Packages"

DBMS_OUTPUT

DBMS_JOB

DBMS_SQL

/C3 "Package Methods"

  BIND_VARIABLE BIND_VARIABLE_CHAR BIND_VARIABLE_RAW BIND_VARIABLE_ROWID BROKEN

  CHANGE CLOSE_CURSOR COLUMN_VALUE COLUMN_VALUE_CHAR COLUMN_VALUE_RAW COLUMN_VALUE_ROWID

  DEFINE_COLUMN DEFINE_COLUMN_CHAR DEFINE_COLUMN_RAW DEFINE_COLUMN_ROWID DISABLE

ENABLE EXECUTE EXECUTE_AND_FETCH

FETCH_ROWS

GET_LINE GET_LINES

INTERVAL IS_OPEN

LAST_ERROR_POSITION LAST_ROW_COUNT LAST_ROW_ID LAST_SQL_FUNCTION_CODE

NEW_LINE NEXT_DATE

PARSE PUT PUT_LINE

REMOVE

SUBMIT

WHAT

/C4 "
SQL*Plus Commands"

EXECUTE

GRANT

REPLACE

RUN

START

/C5 "SQL*Plus Functions"

ABS ADD_MONTHS ASCII

CEIL CHR CONCAT CONVERT COS COSH

DECODE

EXP

FLOOR

GREATEST

HEXTORAW

INITCAP INSTR

LAST_DAY LENGTH LN LOG LOWER LPAD LTRIM

MOD MONTHS_BETWEEN

NEXT_DAY NEW_TIME NLS_INITCAP NLS_LOWER NLS_UPPER NVL

POWER

RAWTOHEX REPLACE ROUND ROWIDTOCHAR RPAD RTRIM

SIGN SIN SINH SOUNDEX SQRT SUBSTR SUBSTRB

TAN TANH TO_CHAR TO_DATE TO_LABEL TO_MULTI_BYTE TO_NUMBER TO_SINGLE_TYPE TRANSLATE TRUNC

UPPER USERENV

VSIZE

/C6 "Should Be Reserved"

BEFORE

EACH

FOR

KEY

PRIMARY

WHEN WHERE WHILE
上一篇:Oracle常用的OCI函数 人气:1267
下一篇:Oracle现用数据库 人气:600
浏览全部Oracle教程的内容 Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐