FireBird Forum
C++Builder  |  Delphi  |  FireMonkey  |  C/C++  |  Free Pascal  |  Firebird
볼랜드포럼 BorlandForum
 경고! 게시물 작성자의 사전 허락없는 메일주소 추출행위 절대 금지
파이어버드 포럼
Q & A
FAQ
팁&트릭
강좌/문서
자료실
볼랜드포럼 홈
헤드라인 뉴스
IT 뉴스
공지사항
자유게시판
해피 브레이크
공동 프로젝트
구인/구직
회원 장터
건의사항
운영진 게시판
회원 메뉴
북마크
IBPhoenix
FireBird Main site
볼랜드포럼 광고 모집

FireBird 강좌/문서
[41] Firebird 2.0 Language Reference
박지훈.임프 [cbuilder] 22629 읽음    2008-10-09 11:58
제목 그대로 Firebird 2.0 Language Reference입니다. 9월 29일자로 업데이트된 거네요.

목차는 다음과 같습니다.

1. Introduction
    Versions covered
    Authorship
2. Reserved words and keywords
    Added since InterBase 6
    Dropped since InterBase 6
    Possibly reserved in future versions
3. Miscellaneous language elements
    -- (single-line comment)
    CASE construct
4. Data types and subtypes
    BIGINT data type
    BLOB data type
    New character sets
    Character set NONE handling changed
    New collations
5. DDL statements
    ALTER DATABASE
    ALTER DOMAIN
    ALTER EXTERNAL FUNCTION
    ALTER PROCEDURE
    ALTER SEQUENCE
    ALTER TABLE
    ALTER TRIGGER
    COMMENT
    CREATE DATABASE
    CREATE DOMAIN
    CREATE GENERATOR
    CREATE INDEX
    CREATE PROCEDURE
    CREATE SEQUENCE
    CREATE TABLE
    CREATE TRIGGER
    CREATE VIEW
    CREATE OR ALTER EXCEPTION
    CREATE OR ALTER PROCEDURE
    CREATE OR ALTER TRIGGER
    DECLARE EXTERNAL FUNCTION
    DECLARE FILTER
    DROP GENERATOR
    DROP PROCEDURE
    DROP SEQUENCE
    DROP TRIGGER
    RECREATE EXCEPTION
    RECREATE PROCEDURE
    RECREATE TABLE
    RECREATE TRIGGER
    RECREATE VIEW
    REVOKE ADMIN OPTION
    SET GENERATOR
6. DML statements
    DELETE
    EXECUTE BLOCK
    EXECUTE PROCEDURE
    INSERT
    SELECT
    UPDATE
7. Transaction control statements
    RELEASE SAVEPOINT
    ROLLBACK
    SAVEPOINT
    SET TRANSACTION
8. PSQL statements
    BEGIN ... END blocks may be empty
    BREAK
    CLOSE cursor
    DECLARE
    EXCEPTION
    EXECUTE PROCEDURE
    EXECUTE STATEMENT
    EXIT
    FETCH cursor
    FOR EXECUTE STATEMENT ... DO
    LEAVE
    OPEN cursor
    PLAN allowed in trigger code
    UDFs callable as void functions
9. Context variables
    CURRENT_CONNECTION
    CURRENT_ROLE
    CURRENT_TIME
    CURRENT_TIMESTAMP
    CURRENT_TRANSACTION
    CURRENT_USER
    DELETING
    GDSCODE
    INSERTING
    NEW
    'NOW'
    OLD
    ROW_COUNT
    SQLCODE
    UPDATING
10. Operators and predicates
    NULL literals allowed as operands
    || (string concatenator)
    ALL
    ANY / SOME
    IN
    IS [NOT] DISTINCT FROM
    NEXT VALUE FOR
    SOME
11. Internal functions
    BIT_LENGTH()
    CAST()
    CHAR_LENGTH(), CHARACTER_LENGTH()
    COALESCE()
    EXTRACT()
    GEN_ID()
    IIF()
    LOWER()
    NULLIF()
    OCTET_LENGTH()
    RDB$GET_CONTEXT()
    RDB$SET_CONTEXT()
    SUBSTRING()
    TRIM()
    UPPER()
12. External functions (UDFs)
    addDay
    addHour
    addMilliSecond
    addMinute
    addMonth
    addSecond
    addWeek
    addYear
    ascii_char
    dow
    dpower
    getExactTimestamp
    i64round
    i64truncate
    log
    lower
    lpad
    ltrim
    *nullif
    *nvl
    rand
    right
    round, i64round
    rpad
    rtrim
    sdow
    srand
    string2blob
    substr
    substrlen
    truncate, i64truncate
A. Notes
    Character set NONE data accepted “as is”
    Understanding the WITH LOCK clause
    A note on CSTRING parameters
    Passing NULL to UDFs in Firebird 2
    Maximum number of indices in different Firebird versions
B. Document History
C. License notice

온라인 html 버전은 다음 위치에서 보실 수 있습니다.
http://www.firebirdsql.org/refdocs/langrefupd20.html

+ -

관련 글 리스트
41 Firebird 2.0 Language Reference 박지훈.임프 22629 2008/10/09
Google
Copyright © 1999-2015, borlandforum.com. All right reserved.