Tibero  tbPSM 참조 안내서

Tibero 6


Restricted Rights Legend

All TmaxData Software (Tibero®) and documents are protected by copyright laws and international convention. TmaxData software and documents are made available under the terms of the TmaxData License Agreement and this document may only be distributed or copied in accordance with the terms of this agreement. No part of this document may be transmitted, copied, deployed, or reproduced in any form or by any means, electronic, mechanical, or optical, without the prior written consent of TmaxData Co., Ltd. Nothing in this software document and agreement constitutes a transfer of intellectual property rights regardless of whether or not such rights are registered) or any rights to TmaxData trademarks, logos, or any other brand features.

This document is for information purposes only. The company assumes no direct or indirect responsibilities for the contents of this document, and does not guarantee that the information contained in this document satisfies certain legal or commercial conditions. The information contained in this document is subject to change without prior notice due to product upgrades or updates. The company assumes no liability for any errors in this document.

이 소프트웨어(Tibero®) 사용설명서의 내용과 프로그램은 저작권법과 국제 조약에 의해서 보호받고 있습니다. 사용설명서의 내용과 여기에 설명된 프로그램은 TmaxData Co., Ltd.와의 사용권 계약 하에서만 사용이 가능하며, 사용설명서는 사용권 계약의 범위 내에서만 배포 또는 복제할 수 있습니다. 이 사용설명서의 전부 또는 일부분을 TmaxData의 사전 서면 동의 없이 전자, 기계, 녹음 등의 수단을 사용하여 전송, 복제, 배포, 2차적 저작물작성 등의 행위를 하여서는 안 됩니다.

이 소프트웨어 사용설명서와 프로그램의 사용권 계약은 어떠한 경우에도 사용설명서 및 프로그램과 관련된 지적재산권(등록 여부를 불문)을 양도하는 것으로 해석되지 아니하며, 브랜드나 로고, 상표 등을 사용할 권한을 부여하지 않습니다. 사용설명서는 오로지 정보의 제공만을 목적으로 하고, 이로 인한 계약상의 직접적 또는 간접적 책임을 지지 아니하며, 사용설명서 상의 내용은 법적 또는 상업적인 특정한 조건을 만족시키는 것을 보장하지는 않습니다. 사용설명서의 내용은 제품의 업그레이드나 수정에 따라 그 내용이 예고 없이 변경될 수 있으며, 내용상의 오류가 없음을 보장하지 아니합니다.

안내서 정보

안내서 제목: Tibero  tbPSM 참조 안내서

발행일: 2020-08-21

소프트웨어 버전: Tibero 6(FixSet04)

안내서 버전: v2.1.4.5


내용 목차

안내서에 대하여
1. 패키지 소개
1.1. 개요
1.2. 구성
1.2.1. 사용자 정의 패키지
1.2.2. 시스템 패키지
2. ANYDATA
2.1. 개요
2.2. 메소드
2.2.1. CONVERT
2.2.2. GET
2.2.3. ACCESS
2.2.4. GETTYPENAME
3. DBMS_APPLICATION_INFO
3.1. 개요
3.2. 프러시저
3.2.1. READ_CLIENT_INFO
3.2.2. READ_MODULE
3.2.3. SET_ACTION
3.2.4. SET_CLIENT_INFO
3.2.5. SET_MODULE
3.2.6. SET_SESSION_LONGOPS
4. DBMS_AQ
4.1. 개요
4.2. 타입
4.2.1. AQ$_AGENT
4.2.2. AQ$_RECIPIENT_LIST_T
4.2.3. DEQUEUE_OPTIONS_T
4.2.4. ENQUEUE_OPTIONS_T
4.2.5. MESSAGE_PROPERTIES_T
4.2.6. MESSAGE_PROPERTIES_ARRAY_T
4.2.7. MSGID_ARRAY_T
4.2.8. PAYLOAD_ARRAY_T
4.3. 프러시저와 함수
4.3.1. DEQUEUE
4.3.2. DEQUEUE_ARRAY
4.3.3. ENQUEUE
4.3.4. ENQUEUE_ARRAY
5. DBMS_AQADM
5.1. 개요
5.2. 프러시저와 함수
5.2.1. ADD_SUBSCRIBER
5.2.2. CREATE_QUEUE
5.2.3. CREATE_QUEUE_TABLE
5.2.4. DROP_QUEUE
5.2.5. DROP_QUEUE_TABLE
5.2.6. GRANT_SYSTEM_PRIVILEGE
5.2.7. REMOVE_SUBSCRIBER
5.2.8. REVOKE_SYSTEM_PRIVILEGE
5.2.9. START_QUEUE
5.2.10. STOP_QUEUE
6. DBMS_CRYPTO
6.1. 개요
6.2. 암호화/복호화 알고리즘 및 체인, 패딩
6.3. 해시 알고리즘
6.4. 프러시저와 함수
6.4.1. DECRYPT
6.4.2. ENCRYPT
6.4.3. HASH
7. DBMS_DB_VERSION
7.1. 개요
7.2. 상수
7.2.1. MAJOR
7.2.2. MINOR
8. DBMS_DDL
8.1. 개요
8.2. 프러시저와 함수
8.2.1. CREATE_WRAPPED
8.2.2. IS_TRIGGER_FIRE_ONCE
8.2.3. SET_TRIGGER_FIRING_PROPERTY
8.2.4. WRAP
9. DBMS_DEBUG
9.1. 개요
9.2. 타입
9.2.1. breakpoint_info
9.2.2. program_info
9.2.3. runtime_info
9.3. 프러시저와 함수
9.3.1. ATTACH_SESSION
9.3.2. CONTINUE
9.3.3. DEBUG_OFF
9.3.4. DEBUG_ON
9.3.5. DELETE_BREAKPOINT
9.3.6. DETACH_SESSION
9.3.7. DISABLE_BREAKPOINT
9.3.8. ENABLE_BREAKPOINT
9.3.9. GET_RUNTIME_INFO
9.3.10. GET_VALUE
9.3.11. INITIALIZE
9.3.12. PRINT_BACKTRACE
9.3.13. SET_BREAKPOINT
9.3.14. SHOW_BREAKPOINTS
9.3.15. SYNCHRONIZE
10. DBMS_ERRLOG
10.1. 개요
10.2. 프러시저
10.2.1. CREATE_ERROR_LOG
11. DBMS_FLASHBACK
11.1. 개요
11.2. 프러시저와 함수
11.2.1. GET_SYSTEM_CHANGE_NUMBER
12. DBMS_JAVA
12.1. 개요
12.2. 프러시저
12.2.1. SET_OUTPUT
12.3. 함수
12.3.1. LONGNAME
12.3.2. SHORTNAME
13. DBMS_JOB
13.1. 개요
13.2. 프러시저
13.2.1. BROKEN
13.2.2. CHANGE
13.2.3. INTERVAL
13.2.4. NEXT_DATE
13.2.5. REMOVE
13.2.6. RUN
13.2.7. SUBMIT
13.2.8. WHAT
14. DBMS_JOB_WITH_NAME
14.1. 개요
14.2. 프러시저
14.2.1. BROKEN
14.2.2. CHANGE
14.2.3. INTERVAL
14.2.4. NAME
14.2.5. NEXT_DATE
14.2.6. REMOVE
14.2.7. RUN
14.2.8. SUBMIT
14.2.9. WHAT
15. DBMS_LOB
15.1. 개요
15.2. 예외
15.3. 프러시저
15.3.1. APPEND
15.3.2. COPY
15.3.3. CONVERTTOBLOB
15.3.4. CONVERTTOCLOB
15.3.5. CREATETEMPORARY
15.3.6. ERASE
15.3.7. FILECLOSE
15.3.8. FILECLOSEALL
15.3.9. FILEGETNAME
15.3.10. FILEOPEN
15.3.11. FREETEMPORARY
15.3.12. LOADFROMFILE
15.3.13. LOADBLOBFROMFILE
15.3.14. OPEN
15.3.15. READ
15.3.16. TRIM
15.3.17. WRITE
15.3.18. WRITEAPPEND
15.4. 함수
15.4.1. CLOSE
15.4.2. COMPARE
15.4.3. FILEEXISTS
15.4.4. FILEISOPEN
15.4.5. GETLENGTH
15.4.6. INSTR
15.4.7. ISOPEN
15.4.8. ISTEMPORARY
15.4.9. SUBSTR
16. DBMS_LOCK
16.1. 개요
16.2. 프러시저
16.2.1. ALLOCATE_UNIQUE
16.2.2. CONVERT
16.2.3. RELEASE
16.2.4. REQUEST
16.2.5. SLEEP
17. DBMS_METADATA
17.1. 개요
17.2. 프러시저
17.2.1. GET_DDL
18. DBMS_MONITOR
18.1. 개요
18.2. 프러시저와 함수
18.2.1. CLIENT_ID_TRACE_DISABLE
18.2.2. CLIENT_ID_TRACE_ENABLE
18.2.3. DATABASE_TRACE_DISABLE
18.2.4. DATABASE_TRACE_ENABLE
18.2.5. SESSION_TRACE_DISABLE
18.2.6. SESSION_TRACE_ENABLE
19. DBMS_MVIEW
19.1. 개요
19.2. 프러시저
19.2.1. EXPLAIN_REWRITE
19.2.2. REFRESH
20. DBMS_OBFUSCATION_TOOLKIT
20.1. 개요
20.2. 프러시저와 함수
20.2.1. DES3DECRYPT
20.2.2. DES3ENCRYPT
20.2.3. DES3GETKEY
20.2.4. DESDECRYPT
20.2.5. DESENCRYPT
20.2.6. DESGETKEY
20.2.7. MD5
21. DBMS_OUTPUT
21.1. 개요
21.2. 프러시저
21.2.1. DISABLE
21.2.2. ENABLE
21.2.3. GET_LINE, GET_LINES
21.2.4. NEW_LINE
21.2.5. PUT, PUT_LINE
22. DBMS_PIPE
22.1. 개요
22.2. 프러시저와 함수
22.2.1. CREATE_PIPE
22.2.2. NEXT_ITEM_TYPE
22.2.3. PACK_MESSAGE
22.2.4. PURGE
22.2.5. RECEIVE_MESSAGE
22.2.6. RESET_BUFFER
22.2.7. REMOVE_PIPE
22.2.8. SEND_MESSAGE
22.2.9. UNIQUE_SESSION_NAME
22.2.10. UNPACK_MESSAGE
23. DBMS_RANDOM
23.1. 개요
23.2. 프러시저와 함수
23.2.1. NORMAL
23.2.2. RANDOM
23.2.3. SEED
23.2.4. STRING
23.2.5. VALUE
24. DBMS_REDEFINITION
24.1. 개요
24.2. 프러시저
24.2.1. ABORT_REDEF_TABLE
24.2.2. CAN_REDEF_TABLE
24.2.3. COPY_TABLE_DEPENDENTS
24.2.4. FINISH_REDEF_TABLE
24.2.5. REGISTER_DEPENDENT_OBJECT
24.2.6. START_REDEF_TABLE
24.2.7. SYNC_INTERIM_TABLE
24.2.8. UNREGISTER_DEPENDENT_OBJECT
25. DBMS_REPAIR
25.1. 개요
25.2. 함수
25.2.1. ONLINE_INDEX_CLEAN
26. DBMS_RESOURCE_MANAGER
26.1. 개요
26.2. 프러시저
26.2.1. CREATE_CONSUMER_GROUP
26.2.2. CREATE_PLAN
26.2.3. CREATE_PLAN_DIRECTIVE
26.2.4. CREATE_SIMPLE_PLAN
26.2.5. DELETE_CONSUMER_GROUP
26.2.6. DELETE_PLAN
26.2.7. DELETE_PLAN_DIRECTIVE
26.2.8. SET_CONSUMER_GROUP_MAPPING
26.2.9. SWITCH_PLAN
26.2.10. UPDATE_CONSUMER_GROUP
26.2.11. UPDATE_PLAN
26.2.12. UPDATE_PLAN_DIRECTIVE
27. DBMS_RESULT_CACHE
27.1. 개요
27.2. 프러시저와 함수
27.2.1. BYPASS
27.2.2. FLUSH
27.2.3. INVALIDATE
27.2.4. INVALIDATE_OBJECT
27.2.5. MEMORY_REPORT
27.2.6. STATUS
28. DBMS_RLS
28.1. 개요
28.2. 프러시저와 함수
28.2.1. ADD_POLICY
28.2.2. DROP_POLICY
28.2.3. ENABLE_POLICY
28.2.4. REFRESH_POLICY
29. DBMS_ROWID
29.1. 개요
29.2. 프러시저
29.2.1. ROWID_INFO
29.3. 함수
29.3.1. ROWID_CREATE
29.3.2. ROWID_SEGMENT
29.3.3. ROWID_BLOCK_NUMBER
29.3.4. ROWID_ROW_NUMBER
29.3.5. ROWID_ABSOLUTE_FNO
29.3.6. ROWID_TO_RELATIVE_FNO
30. DBMS_SCHEDULER
30.1. 개요
30.2. 프러시저
30.2.1. CREATE_CHAIN
30.2.2. CREATE_JOB
30.2.3. CREATE_PROGRAM
30.2.4. DEFINE_CHAIN_RULE
30.2.5. DEFINE_CHAIN_STEP
30.2.6. DISABLE
30.2.7. DROP_CHAIN
30.2.8. DROP_CHAIN_RULE
30.2.9. DROP_CHAIN_STEP
30.2.10. DROP_JOB
30.2.11. DROP_PROGRAM
30.2.12. ENABLE
30.2.13. RUN_JOB
30.2.14. SET_ATTRIBUTE
31. DBMS_SESSION
31.1. 개요
31.2. 프러시저와 함수
31.2.1. CLEAR_ALL_CONTEXT
31.2.2. CLEAR_CONTEXT
31.2.3. CLEAR_IDENTIFIER
31.2.4. LIST_CONTEXT
31.2.5. SET_CONTEXT
31.2.6. SET_IDENTIFIER
31.2.7. UNIQUE_SESSION_ID
31.2.8. CLOSE_DATABASE_LINK
31.2.9. IS_ROLE_ENABLED
31.2.10. SET_ROLE
32. DBMS_SPACE
32.1. 개요
32.2. 프러시저
32.2.1. SPACE_USAGE
32.2.2. UNUSED_SPACE
33. DBMS_SPACE_ADMIN
33.1. 개요
33.2. 프러시저
33.2.1. SEGMENT_DUMP
34. DBMS_SPH
34.1. 개요
34.2. 프러시저
34.2.1. REPORT_PLANS
34.2.2. REPORT_PLANS_BY_DATE
34.2.3. REPORT_PLAN_HISTORY
34.2.4. REPORT_PLAN_HISTORY_BY_DATE
34.2.5. TRUNCATE_PLAN_HISTORY
34.2.6. TRUNCATE_PLAN_HISTORY_BY_DATE
34.2.7. UPDATE_PLAN_HISTORY
35. DBMS_SQL
35.1. 개요
35.2. 타입
35.2.1. DESC_REC
35.2.2. DESC_REC2
35.2.3. DESC_TAB
35.2.4. DESC_TAB2
35.2.5. VARCHAR2A
35.2.6. DATE_TABLE
35.2.7. NUMBER_TABLE
35.2.8. VARCHAR2_TABLE
35.3. 프러시저
35.3.1. BIND_ARRAY
35.3.2. BIND_VARIABLE
35.3.3. CLOSE_CURSOR
35.3.4. COLUMN_VALUE
35.3.5. DEFINE_COLUMN
35.3.6. DESCRIBE_COLUMNS
35.3.7. DESCRIBE_COLUMNS2
35.3.8. PARSE
35.4. 함수
35.4.1. EXECUTE
35.4.2. EXECUTE_AND_FETCH
35.4.3. FETCH_ROWS
35.4.4. OPEN_CURSOR
35.4.5. IS_OPEN
35.4.6. LAST_ERROR_POSITION
35.4.7. LAST_ROW_COUNT
36. DBMS_SQLTUNE
36.1. 개요
36.2. 프러시저와 함수
36.2.1. REPORT_SQL_MONITOR
37. DBMS_SQL_TRANSLATOR
37.1. 개요
37.2. 프러시저와 함수
37.2.1. CREATE_PROFILE
37.2.2. DEREGISTER_ERROR_TRANSLATION
37.2.3. DEREGISTER_SQL_TRANSLATION
37.2.4. DROP_PROFILE
37.2.5. ENABLE_ERROR_TRANSLATION
37.2.6. ENABLE_SQL_TRANSLATION
37.2.7. REGISTER_ERROR_TRANSLATION
37.2.8. REGISTER_SQL_TRANSLATION
37.2.9. SET_ATTRIBUTE
37.2.10. SQL_HASH
37.2.11. SQL_ID
37.2.12. TRANSLATE_ERROR
37.2.13. TRANSLATE_SQL
38. DBMS_STATS
38.1. 개요
38.2. 프러시저
38.2.1. ALTER_STATS_HISTORY_RETENTION
38.2.2. COPY_TABLE_STATS
38.2.3. CREATE_STAT_TABLE
38.2.4. DELETE_COLUMN_STATS
38.2.5. DELETE_DATABASE_STATS
38.2.6. DELETE_DICTIONARY_STATS
38.2.7. DELETE_INDEX_STATS
38.2.8. DELETE_SCHEMA_STATS
38.2.9. DELETE_SYSTEM_STATS
38.2.10. DELETE_TABLE_STATS
38.2.11. DROP_STAT_TABLE
38.2.12. EXPORT_COLUMN_STATS
38.2.13. EXPORT_DATABASE_STATS
38.2.14. EXPORT_INDEX_STATS
38.2.15. EXPORT_SCHEMA_STATS
38.2.16. EXPORT_SYSTEM_STATS
38.2.17. EXPORT_TABLE_STATS
38.2.18. GATHER_DATABASE_STATS
38.2.19. GATHER_DICTIONARY_STATS
38.2.20. GATHER_INDEX_STATS
38.2.21. GATHER_SCHEMA_STATS
38.2.22. GATHER_SYSTEM_STATS
38.2.23. GATHER_TABLE_STATS
38.2.24. GET_COLUMN_STATS
38.2.25. GET_INDEX_STATS
38.2.26. GET_TABLE_STATS
38.2.27. IMPORT_COLUMN_STATS
38.2.28. IMPORT_DATABASE_STATS
38.2.29. IMPORT_INDEX_STATS
38.2.30. IMPORT_SCHEMA_STATS
38.2.31. IMPORT_SYSTEM_STATS
38.2.32. IMPORT_TABLE_STATS
38.2.33. LOCK_TABLE_STATS
38.2.34. LOCK_SCHEMA_STATS
38.2.35. SET_COLUMN_STATS
38.2.36. SET_INDEX_STATS
38.2.37. SET_TABLE_STATS
38.2.38. PURGE_STATS
38.2.39. RESTORE_SCHEMA_STATS
38.2.40. RESTORE_TABLE_STATS
38.2.41. SET_PARAM
38.2.42. SET_SYSTEM_STATS
38.2.43. UNLOCK_TABLE_STATS
38.2.44. UNLOCK_SCHEMA_STATS
38.3. 함수
38.3.1. GET_PARAM
38.3.2. GET_STATS_HISTORY_AVAILABILITY
38.3.3. GET_STATS_HISTORY_RETENTION
38.3.4. TO_BOOLEAN
39. DBMS_SYSTEM
39.1. 개요
39.2. 프러시저와 함수
39.2.1. SET_SQL_TRACE_IN_SESSION
40. DBMS_TPR
40.1. 개요
40.2. 프러시저
40.2.1. CREATE_SNAPSHOT
40.2.2. CREATE_SNAPSHOT_ALL
40.2.3. REPORT_TEXT
40.2.4. REPORT_TEXT_ID
40.2.5. REPORT_TEXT_GID
40.2.6. REPORT_TEXT_LAST
40.2.7. REPORT_TEXT_SPECIFIC_TIMES
40.2.8. REPORT_TEXT_MARKED
40.2.9. REPORT_HTML
40.2.10. REPORT_HTML_ID
40.2.11. REPORT_HTML_GID
40.2.12. REPORT_HTML_LAST
40.2.13. REPORT_HTML_SPECIFIC_TIMES
40.2.14. REPORT_HTML_MARKED
40.2.15. FLUSH_ASH
40.2.16. ASH_REPORT_TEXT
40.2.17. CREATE_BASELINE
40.2.18. CREATE_BASELINE_ID
40.2.19. DROP_BASELINE
40.2.20. DROP_BASELINE_ID
40.2.21. BASELINE_REPORT_TEXT
40.2.22. BASELINE_REPORT_TEXT_ID
41. DBMS_TRANSACTION
41.1. 개요
41.2. 프러시저
41.2.1. COMMIT
41.2.2. ROLLBACK, ROLLBACK_SAVEPOINT
41.2.3. SAVEPOINT
42. DBMS_TYPES
42.1. 개요
42.2. 상수 목록
43. DBMS_UTILITY
43.1. 개요
43.2. 타입
43.2.1. UNCL_ARRAY
43.3. 프러시저와 함수
43.3.1. COMMA_TO_TABLE
43.3.2. FORMAT_CALL_STACK
43.3.3. FORMAT_ERROR_BACKTRACE
43.3.4. FORMAT_ERROR_STACK
43.3.5. GET_HASH_VALUE
43.3.6. GET_TIME
44. DBMS_VERIFY
44.1. 개요
44.2. 프러시저
44.2.1. SCHEMA_INDEX
44.2.2. TABLE_INDEX
44.2.3. INDEX
45. DBMS_XMLDOM
45.1. 개요
45.2. 타입
45.2.1. DOMAttr
45.2.2. DOMCDataSection
45.2.3. DOMCharacterData
45.2.4. DOMComment
45.2.5. DOMDocument
45.2.6. DOMDocumentFragment
45.2.7. DOMDocumentType
45.2.8. DOMElement
45.2.9. DOMEntity
45.2.10. DOMEntityReference
45.2.11. DOMImplementation
45.2.12. DOMNamedNodeMap
45.2.13. DOMNode
45.2.14. DOMNodeList
45.2.15. DOMNotation
45.2.16. DOMProcessingInstruction
45.2.17. DOMText
45.3. 프러시저와 함수
45.3.1. ADOPTNODE
45.3.2. APPENDCHILD
45.3.3. CREATECDATASECTION
45.3.4. CREATECOMMENT
45.3.5. CREATEELEMENT
45.3.6. CREATETEXTNODE
45.3.7. FREEDOCFRAG
45.3.8. FREEDOCUMENT
45.3.9. FREENODE
45.3.10. GETATTRIBUTE
45.3.11. GETATTRIBUTENODE
45.3.12. GETATTRIBUTES
45.3.13. GETCHILDNODES
45.3.14. GETCHILDRENBYTAGNAME
45.3.15. GETDOCUMENTELEMENT
45.3.16. GETELEMENTSBYTAGNAME
45.3.17. GETFIRSTCHILD
45.3.18. GETLASTCHILD
45.3.19. GETLENGTH
45.3.20. GETNAME
45.3.21. GETNAMEDITEM
45.3.22. GETNODENAME
45.3.23. GETNODETYPE
45.3.24. GETNODEVALUE
45.3.25. GETOWNERDOCUMENT
45.3.26. GETPARENTNODE
45.3.27. GETVALUE
45.3.28. GETXMLTYPE
45.3.29. HASATTRIBUTE
45.3.30. IMPORTNODE
45.3.31. INSERTBEFORE
45.3.32. ISNULL
45.3.33. ITEM
45.3.34. MAKEATTR
45.3.35. MAKEDOCUMENT
45.3.36. MAKEELEMENT
45.3.37. MAKENODE
45.3.38. NEWDOMDOCUMENT
45.3.39. REMOVEATTRIBUTE
45.3.40. REMOVECHILD
45.3.41. REPLACECHILD
45.3.42. SETATTRIBUTE
45.3.43. SETVALUE
45.3.44. WRITETOCLOB
46. DBMS_XMLGEN
46.1. 개요
46.2. 타입
46.2.1. ctxHandle
46.3. 프러시저와 함수
46.3.1. CLOSECONTEXT
46.3.2. CONVERT
46.3.3. GETNUMROWSPROCESSED
46.3.4. GETXML
46.3.5. GETXMLTYPE
46.3.6. NEWCONTEXT
46.3.7. SETMAXROWS
46.3.8. SETNULLHANDLING
46.3.9. SETROWTAG
46.3.10. SETROWSETTAG
46.3.11. SETSKIPROWS
47. DBMS_XPLAN
47.1. 개요
47.2. 함수
47.2.1. DISPLAY_CURSOR
48. HTF
48.1. 개요
48.2. 함수
48.2.1. ADDRESS
48.2.2. ANCHOR
48.2.3. ANCHOR2
48.2.4. APPLETCLOSE
48.2.5. APPLETOPEN
48.2.6. AREA
48.2.7. BASEFONT
48.2.8. BGSOUND
48.2.9. BIG
48.2.10. BLOCKQUOTECLOSE
48.2.11. BLOCKQUOTEOPEN
48.2.12. BODYCLOSE
48.2.13. BODYOPEN
48.2.14. BOLD
48.2.15. BR
48.2.16. CENTER
48.2.17. CENTERCLOSE
48.2.18. CENTEROPEN
48.2.19. CITE
48.2.20. CODE
48.2.21. COMMENT
48.2.22. DFN
48.2.23. DIRLISTCLOSE
48.2.24. DIRLISTOPEN
48.2.25. DIV
48.2.26. DLISTCLOSE
48.2.27. DLISTDEF
48.2.28. DLISTOPEN
48.2.29. DLISTTERM
48.2.30. EM
48.2.31. ESCAPE_SC
48.2.32. FONTCLOSE
48.2.33. FONTOPEN
48.2.34. FORMCHECKBOX
48.2.35. FORMCLOSE
48.2.36. FORMFILE
48.2.37. FORMHIDDEN
48.2.38. FORMIMAGE
48.2.39. FORMOPEN
48.2.40. FORMPASSWORD
48.2.41. FORMRADIO
48.2.42. FORMRESET
48.2.43. FORMSELECTCLOSE
48.2.44. FORMSELECTOPEN
48.2.45. FORMSELECTOPTION
48.2.46. FORMSUBMIT
48.2.47. FORMTEXT
48.2.48. FORMTEXTAREA
48.2.49. TEXTAREACLOSE
48.2.50. FORMTEXTAREAOPEN
48.2.51. FRAME
48.2.52. FRAMESETCLOSE
48.2.53. FRAMESETOPEN
48.2.54. HEADCLOSE
48.2.55. HEADER
48.2.56. HEADOPEN
48.2.57. HR
48.2.58. HTMLCLOSE
48.2.59. HTMLOPEN
48.2.60. IMG
48.2.61. ISINDEX
48.2.62. ITALIC
48.2.63. KBD
48.2.64. LINKREL
48.2.65. LINKREV
48.2.66. LISTHEADER
48.2.67. LISTINGCLOSE
48.2.68. LISTINGOPEN
48.2.69. LISTITEM
48.2.70. MAILTO
48.2.71. MAPCLOSE
48.2.72. MAPOPEN
48.2.73. MENULISTCLOSE
48.2.74. MENULISTOPEN
48.2.75. META
48.2.76. NOBR
48.2.77. NOFRAMESCLOSE
48.2.78. NOFRAMESOPEN
48.2.79. OLISTCLOSE
48.2.80. OLISTOPEN
48.2.81. PARA
48.2.82. PARAGRAPH
48.2.83. PARAM
48.2.84. PLAINTEXT
48.2.85. PRECLOSE
48.2.86. PREOPEN
48.2.87. S
48.2.88. SAMPLE
48.2.89. SCRIPT
48.2.90. SMALL
48.2.91. STRIKE
48.2.92. STRONG
48.2.93. STYLE
48.2.94. SUB
48.2.95. SUP
48.2.96. TABLECAPTION
48.2.97. TABLECLOSE
48.2.98. TABLEDATA
48.2.99. TABLEHEADER
48.2.100. TABLEOPEN
48.2.101. TABLEROWCLOSE
48.2.102. TABLEROWOPEN
48.2.103. TELETYPE
48.2.104. TITLE
48.2.105. ULISTCLOSE
48.2.106. ULISTOPEN
48.2.107. UNDERLINE
48.2.108. VARIABLE
48.2.109. WBR
49. HTP
49.1. 개요
49.2. Apache와의 연동
49.3. 프러시저와 함수
49.3.1. BODYCLOSE
49.3.2. BODYOPEN
49.3.3. BR
49.3.4. CENTER
49.3.5. CENTERCLOSE
49.3.6. CENTEROPEN
49.3.7. FONTCLOSE
49.3.8. FONTOPEN
49.3.9. FORMSELECTCLOSE
49.3.10. FORMSELECTOPEN
49.3.11. FORMSELECTOPTION
49.3.12. GET_PAGE
49.3.13. HEADCLOSE
49.3.14. HEADER
49.3.15. HEADOPEN
49.3.16. HR
49.3.17. HTMLCLOSE
49.3.18. HTMLOPEN
49.3.19. IMG
49.3.20. IMG2
49.3.21. LINE
49.3.22. PRINT
49.3.23. PRN
49.3.24. TITLE
50. TEXT_DDL
50.1. 개요
50.2. 프러시저
50.2.1. ADD_STOPWORD
50.2.2. CREATE_PREFERENCE
50.2.3. CREATE_STOPLIST
50.2.4. DROP_PREFERENCE
50.2.5. DROP_STOPLIST
50.2.6. REMOVE_STOPWORD
50.2.7. SET_ATTRIBUTE
51. UTL_COMPRESS
51.1. 개요
51.2. 함수
51.2.1. LZ_COMPRESS
51.2.2. LZ_UNCOMPRESS
52. UTL_ENCODE
52.1. 개요
52.2. 함수
52.2.1. BASE64_DECODE
52.2.2. BASE64_ENCODE
52.2.3. QUOTED_PRINTABLE_DECODE
52.2.4. QUOTED_PRINTABLE_ENCODE
52.2.5. TEXT_DECODE
52.2.6. TEXT_ENCODE
53. UTL_FILE
53.1. 개요
53.2. 프러시저
53.2.1. FCLOSE
53.2.2. FCLOSE_ALL
53.2.3. FCOPY
53.2.4. FFLUSH
53.2.5. FGETATTR
53.2.6. FREMOVE
53.2.7. FRENAME
53.2.8. FSEEK
53.2.9. GET_LINE
53.2.10. GET_RAW
53.2.11. NEW_LINE
53.2.12. PUT
53.2.13. PUTF
53.2.14. PUT_RAW
53.2.15. PUT_LINE
53.3. 함수
53.3.1. FGETPOS
53.3.2. FOPEN
53.3.3. IS_OPEN
54. UTL_HTTP
54.1. 개요
54.2. 상수
54.2.1. HTTP 버전 상수
54.2.2. HTTP 포트 상수
54.2.3. 상태 코드 상수
54.3. 타입
54.3.1. HTML_PIECES
54.3.2. req
54.3.3. resp
54.4. 예외
54.5. 함수
54.5.1. BEGIN_REQUEST
54.5.2. GET_RESPONSE
54.5.3. REQUEST
54.6. 프러시저
54.6.1. END_RESPONSE
54.6.2. GET_BODY_CHARSET
54.6.3. GET_DETAILED_EXCP_SUPPORT
54.6.4. GET_TRANSFER_TIMEOUT
54.6.5. READ_TEXT
54.6.6. SET_BODY_CHARSET
54.6.7. SET_DETAILED_EXCP_SUPPORT
54.6.8. SET_HEADER
54.6.9. SET_TRANSFER_TIMEOUT
54.6.10. WRITE_TEXT
54.7. URL
54.8. 예제
55. UTL_I18N
55.1. 개요
55.2. 프러시저와 함수
55.2.1. RAW_TO_CHAR
55.2.2. STRING_TO_RAW
56. UTL_MATCH
56.1. 개요
56.2. 함수
56.2.1. EDIT_DISTANCE
56.2.2. EDIT_DISTANCE_SIMILARITY
56.2.3. JARO_WINKLER
56.2.4. JARO_WINKLER_SIMILARITY
57. UTL_RAW
57.1. 개요
57.2. 함수
57.2.1. BIT_AND
57.2.2. BIT_COMPLEMENT
57.2.3. BIT_OR
57.2.4. BIT_XOR
57.2.5. CAST_FROM_BINARY_DOUBLE
57.2.6. CAST_FROM_BINARY_FLOAT
57.2.7. CAST_FROM_BINARY_INTEGER
57.2.8. CAST_FROM_NUMBER
57.2.9. CAST_TO_BINARY_DOUBLE
57.2.10. CAST_TO_BINARY_FLOAT
57.2.11. CAST_TO_BINARY_INTEGER
57.2.12. CAST_TO_NUMBER
57.2.13. CAST_TO_RAW
57.2.14. CAST_TO_VARCHAR2
57.2.15. COMPARE
57.2.16. CONCAT
57.2.17. COPIES
57.2.18. LENGTH
57.2.19. OVERLAY
57.2.20. REVERSE
57.2.21. SUBSTR
57.2.22. TRANSLATE
57.2.23. TRANSLITERATE
57.2.24. XRANGE
58. UTL_RECOMP
58.1. 개요
58.2. 프러시저
58.2.1. RECOMP_SERIAL
59. UTL_TCP
59.1. 개요
59.2. 타입
59.2.1. CONNECTION
59.3. 상수
59.3.1. CRLF
59.4. 프러시저와 함수
59.4.1. CLOSE_ALL_CONNECTIONS
59.4.2. CLOSE_CONNECTION
59.4.3. GET_LINE
59.4.4. GET_RAW
59.4.5. GET_TEXT
59.4.6. OPEN_CONNECTION
59.4.7. READ_LINE
59.4.8. READ_RAW
59.4.9. READ_TEXT
59.4.10. WRITE_LINE
59.4.11. WRITE_RAW
59.4.12. WRITE_TEXT
60. UTL_URL
60.1. 개요
60.2. 함수
60.2.1. ESCAPE
60.2.2. UNESCAPE
색인

예 목차

[예 1.1] EMP_MGMT 패키지의 선언부
[예 1.2] EMP_MGMT 패키지의 구현부