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 참조 안내서  

발행일: 2024-03-29

소프트웨어 버전: Tibero 6.7.1

안내서 버전: v6.7.1


내용 목차

안내서에 대하여
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_ALERT
3.1. 개요
3.2. 프러시저
3.2.1. REGISTER
3.2.2. REMOVE
3.2.3. REMOVE
3.2.4. SET_DEFAULTS
3.2.5. SIGNAL
3.2.6. WAITANY
3.2.7. WAITONE
4. DBMS_APPLICATION_INFO
4.1. 개요
4.2. 프러시저
4.2.1. READ_CLIENT_INFO
4.2.2. READ_MODULE
4.2.3. SET_ACTION
4.2.4. SET_CLIENT_INFO
4.2.5. SET_MODULE
4.2.6. SET_SESSION_LONGOPS
5. DBMS_AQ
5.1. 개요
5.2. 타입
5.2.1. AQ$_AGENT
5.2.2. AQ$_RECIPIENT_LIST_T
5.2.3. DEQUEUE_OPTIONS_T
5.2.4. ENQUEUE_OPTIONS_T
5.2.5. MESSAGE_PROPERTIES_T
5.2.6. MESSAGE_PROPERTIES_ARRAY_T
5.2.7. MSGID_ARRAY_T
5.2.8. PAYLOAD_ARRAY_T
5.3. 프러시저와 함수
5.3.1. DEQUEUE
5.3.2. DEQUEUE_ARRAY
5.3.3. ENQUEUE
5.3.4. ENQUEUE_ARRAY
6. DBMS_AQADM
6.1. 개요
6.2. 프러시저와 함수
6.2.1. ADD_SUBSCRIBER
6.2.2. CREATE_QUEUE
6.2.3. CREATE_QUEUE_TABLE
6.2.4. DROP_QUEUE
6.2.5. DROP_QUEUE_TABLE
6.2.6. GRANT_SYSTEM_PRIVILEGE
6.2.7. REMOVE_SUBSCRIBER
6.2.8. REVOKE_SYSTEM_PRIVILEGE
6.2.9. START_QUEUE
6.2.10. STOP_QUEUE
7. DBMS_CRYPTO
7.1. 개요
7.2. 암호화/복호화 알고리즘 및 체인, 패딩
7.3. 해시 알고리즘
7.4. 프러시저와 함수
7.4.1. DECRYPT
7.4.2. ENCRYPT
7.4.3. HASH
7.4.4. MAC
7.4.5. RANDOMBYTES
8. DBMS_DB_VERSION
8.1. 개요
8.2. 상수
8.2.1. MAJOR
8.2.2. MINOR
9. DBMS_DDL
9.1. 개요
9.2. 프러시저와 함수
9.2.1. CREATE_WRAPPED
9.2.2. IS_TRIGGER_FIRE_ONCE
9.2.3. SET_TRIGGER_FIRING_PROPERTY
9.2.4. WRAP
10. DBMS_DEBUG
10.1. 개요
10.2. 타입
10.2.1. breakpoint_info
10.2.2. program_info
10.2.3. runtime_info
10.3. 프러시저와 함수
10.3.1. ATTACH_SESSION
10.3.2. CONTINUE
10.3.3. DEBUG_OFF
10.3.4. DEBUG_ON
10.3.5. DELETE_BREAKPOINT
10.3.6. DETACH_SESSION
10.3.7. DISABLE_BREAKPOINT
10.3.8. ENABLE_BREAKPOINT
10.3.9. GET_RUNTIME_INFO
10.3.10. GET_VALUE
10.3.11. INITIALIZE
10.3.12. PRINT_BACKTRACE
10.3.13. SET_BREAKPOINT
10.3.14. SHOW_BREAKPOINTS
10.3.15. SYNCHRONIZE
11. DBMS_ERRLOG
11.1. 개요
11.2. 프러시저
11.2.1. CREATE_ERROR_LOG
12. DBMS_FLASHBACK
12.1. 개요
12.2. 프러시저와 함수
12.2.1. GET_SYSTEM_CHANGE_NUMBER
13. DBMS_JAVA
13.1. 개요
13.2. 프러시저
13.2.1. SET_OUTPUT
13.3. 함수
13.3.1. LONGNAME
13.3.2. SHORTNAME
14. DBMS_JOB
14.1. 개요
14.2. 프러시저
14.2.1. BROKEN
14.2.2. CHANGE
14.2.3. INTERVAL
14.2.4. NEXT_DATE
14.2.5. REMOVE
14.2.6. RUN
14.2.7. SUBMIT
14.2.8. WHAT
15. DBMS_JOB_WITH_NAME
15.1. 개요
15.2. 프러시저
15.2.1. BROKEN
15.2.2. CHANGE
15.2.3. INTERVAL
15.2.4. NAME
15.2.5. NEXT_DATE
15.2.6. REMOVE
15.2.7. RUN
15.2.8. SUBMIT
15.2.9. WHAT
16. DBMS_LOB
16.1. 개요
16.2. 예외
16.3. 프러시저
16.3.1. APPEND
16.3.2. COPY
16.3.3. CONVERTTOBLOB
16.3.4. CONVERTTOCLOB
16.3.5. CREATETEMPORARY
16.3.6. ERASE
16.3.7. FILECLOSE
16.3.8. FILECLOSEALL
16.3.9. FILEGETNAME
16.3.10. FILEOPEN
16.3.11. FREETEMPORARY
16.3.12. LOADFROMFILE
16.3.13. LOADBLOBFROMFILE
16.3.14. OPEN
16.3.15. READ
16.3.16. TRIM
16.3.17. WRITE
16.3.18. WRITEAPPEND
16.4. 함수
16.4.1. CLOSE
16.4.2. COMPARE
16.4.3. FILEEXISTS
16.4.4. FILEISOPEN
16.4.5. GETLENGTH
16.4.6. INSTR
16.4.7. ISOPEN
16.4.8. ISTEMPORARY
16.4.9. SUBSTR
17. DBMS_LOCK
17.1. 개요
17.2. 프러시저
17.2.1. ALLOCATE_UNIQUE
17.2.2. CONVERT
17.2.3. RELEASE
17.2.4. REQUEST
17.2.5. SLEEP
18. DBMS_METADATA
18.1. 개요
18.2. 프러시저
18.2.1. GET_DDL
19. DBMS_MONITOR
19.1. 개요
19.2. 프러시저와 함수
19.2.1. CLIENT_ID_TRACE_DISABLE
19.2.2. CLIENT_ID_TRACE_ENABLE
19.2.3. DATABASE_TRACE_DISABLE
19.2.4. DATABASE_TRACE_ENABLE
19.2.5. SESSION_TRACE_DISABLE
19.2.6. SESSION_TRACE_ENABLE
20. DBMS_MVIEW
20.1. 개요
20.2. 프러시저
20.2.1. EXPLAIN_REWRITE
20.2.2. REFRESH
21. DBMS_OBFUSCATION_TOOLKIT
21.1. 개요
21.2. 프러시저와 함수
21.2.1. DES3DECRYPT
21.2.2. DES3ENCRYPT
21.2.3. DES3GETKEY
21.2.4. DESDECRYPT
21.2.5. DESENCRYPT
21.2.6. DESGETKEY
21.2.7. MD5
22. DBMS_OUTPUT
22.1. 개요
22.2. 프러시저
22.2.1. DISABLE
22.2.2. ENABLE
22.2.3. GET_LINE, GET_LINES
22.2.4. NEW_LINE
22.2.5. PUT, PUT_LINE
23. DBMS_PIPE
23.1. 개요
23.2. 프러시저와 함수
23.2.1. CREATE_PIPE
23.2.2. NEXT_ITEM_TYPE
23.2.3. PACK_MESSAGE
23.2.4. PURGE
23.2.5. RECEIVE_MESSAGE
23.2.6. RESET_BUFFER
23.2.7. REMOVE_PIPE
23.2.8. SEND_MESSAGE
23.2.9. UNIQUE_SESSION_NAME
23.2.10. UNPACK_MESSAGE
24. DBMS_RANDOM
24.1. 개요
24.2. 프러시저와 함수
24.2.1. NORMAL
24.2.2. RANDOM
24.2.3. SEED
24.2.4. STRING
24.2.5. VALUE
25. DBMS_REDEFINITION
25.1. 개요
25.2. 프러시저
25.2.1. ABORT_REDEF_TABLE
25.2.2. CAN_REDEF_TABLE
25.2.3. COPY_TABLE_DEPENDENTS
25.2.4. FINISH_REDEF_TABLE
25.2.5. REGISTER_DEPENDENT_OBJECT
25.2.6. START_REDEF_TABLE
25.2.7. SYNC_INTERIM_TABLE
25.2.8. UNREGISTER_DEPENDENT_OBJECT
26. DBMS_REPAIR
26.1. 개요
26.2. 함수
26.2.1. ONLINE_INDEX_CLEAN
27. DBMS_RESOURCE_MANAGER
27.1. 개요
27.2. 프러시저
27.2.1. CREATE_CONSUMER_GROUP
27.2.2. CREATE_PLAN
27.2.3. CREATE_PLAN_DIRECTIVE
27.2.4. CREATE_SIMPLE_PLAN
27.2.5. DELETE_CONSUMER_GROUP
27.2.6. DELETE_PLAN
27.2.7. DELETE_PLAN_DIRECTIVE
27.2.8. SET_CONSUMER_GROUP_MAPPING
27.2.9. SWITCH_PLAN
27.2.10. UPDATE_CONSUMER_GROUP
27.2.11. UPDATE_PLAN
27.2.12. UPDATE_PLAN_DIRECTIVE
28. DBMS_RESULT_CACHE
28.1. 개요
28.2. 프러시저와 함수
28.2.1. BYPASS
28.2.2. FLUSH
28.2.3. INVALIDATE
28.2.4. INVALIDATE_OBJECT
28.2.5. MEMORY_REPORT
28.2.6. STATUS
29. DBMS_RLS
29.1. 개요
29.2. 프러시저와 함수
29.2.1. ADD_POLICY
29.2.2. DROP_POLICY
29.2.3. ENABLE_POLICY
29.2.4. REFRESH_POLICY
30. DBMS_ROWID
30.1. 개요
30.2. 프러시저
30.2.1. ROWID_INFO
30.3. 함수
30.3.1. ROWID_CREATE
30.3.2. ROWID_SEGMENT
30.3.3. ROWID_BLOCK_NUMBER
30.3.4. ROWID_ROW_NUMBER
30.3.5. ROWID_ABSOLUTE_FNO
30.3.6. ROWID_TO_RELATIVE_FNO
31. DBMS_SCHEDULER
31.1. 개요
31.2. 프러시저
31.2.1. CREATE_CHAIN
31.2.2. CREATE_JOB
31.2.3. CREATE_PROGRAM
31.2.4. DEFINE_CHAIN_RULE
31.2.5. DEFINE_CHAIN_STEP
31.2.6. DISABLE
31.2.7. DROP_CHAIN
31.2.8. DROP_CHAIN_RULE
31.2.9. DROP_CHAIN_STEP
31.2.10. DROP_JOB
31.2.11. DROP_PROGRAM
31.2.12. ENABLE
31.2.13. RUN_JOB
31.2.14. SET_ATTRIBUTE
31.2.15. STOP_JOB
32. DBMS_SESSION
32.1. 개요
32.2. 프러시저와 함수
32.2.1. CLEAR_ALL_CONTEXT
32.2.2. CLEAR_CONTEXT
32.2.3. CLEAR_IDENTIFIER
32.2.4. LIST_CONTEXT
32.2.5. SET_CONTEXT
32.2.6. SET_IDENTIFIER
32.2.7. UNIQUE_SESSION_ID
32.2.8. CLOSE_DATABASE_LINK
32.2.9. IS_ROLE_ENABLED
32.2.10. SET_ROLE
33. DBMS_SPACE
33.1. 개요
33.2. 프러시저
33.2.1. SPACE_USAGE
33.2.2. UNUSED_SPACE
34. DBMS_SPACE_ADMIN
34.1. 개요
34.2. 프러시저
34.2.1. SEGMENT_DUMP
35. DBMS_SPH
35.1. 개요
35.2. 프러시저
35.2.1. REPORT_PLANS
35.2.2. REPORT_PLANS_BY_DATE
35.2.3. REPORT_PLAN_HISTORY
35.2.4. REPORT_PLAN_HISTORY_BY_DATE
35.2.5. TRUNCATE_PLAN_HISTORY
35.2.6. TRUNCATE_PLAN_HISTORY_BY_DATE
35.2.7. UPDATE_PLAN_HISTORY
36. DBMS_SQL
36.1. 개요
36.2. 타입
36.2.1. DESC_REC
36.2.2. DESC_REC2
36.2.3. DESC_TAB
36.2.4. DESC_TAB2
36.2.5. VARCHAR2A
36.2.6. DATE_TABLE
36.2.7. NUMBER_TABLE
36.2.8. VARCHAR2_TABLE
36.3. 프러시저
36.3.1. BIND_ARRAY
36.3.2. BIND_VARIABLE
36.3.3. CLOSE_CURSOR
36.3.4. COLUMN_VALUE
36.3.5. DEFINE_COLUMN
36.3.6. DESCRIBE_COLUMNS
36.3.7. DESCRIBE_COLUMNS2
36.3.8. PARSE
36.4. 함수
36.4.1. EXECUTE
36.4.2. EXECUTE_AND_FETCH
36.4.3. FETCH_ROWS
36.4.4. OPEN_CURSOR
36.4.5. IS_OPEN
36.4.6. LAST_ERROR_POSITION
36.4.7. LAST_ROW_COUNT
37. DBMS_SQLTUNE
37.1. 개요
37.2. 프러시저와 함수
37.2.1. REPORT_SQL_MONITOR
38. DBMS_SQL_TRANSLATOR
38.1. 개요
38.2. 프러시저와 함수
38.2.1. CREATE_PROFILE
38.2.2. DEREGISTER_ERROR_TRANSLATION
38.2.3. DEREGISTER_SQL_TRANSLATION
38.2.4. DROP_PROFILE
38.2.5. ENABLE_ERROR_TRANSLATION
38.2.6. ENABLE_SQL_TRANSLATION
38.2.7. REGISTER_ERROR_TRANSLATION
38.2.8. REGISTER_SQL_TRANSLATION
38.2.9. SET_ATTRIBUTE
38.2.10. SQL_HASH
38.2.11. SQL_ID
38.2.12. TRANSLATE_ERROR
38.2.13. TRANSLATE_SQL
39. DBMS_STATS
39.1. 개요
39.2. 프러시저
39.2.1. ALTER_STATS_HISTORY_RETENTION
39.2.2. COPY_TABLE_STATS
39.2.3. CREATE_STAT_TABLE
39.2.4. DELETE_COLUMN_STATS
39.2.5. DELETE_DATABASE_STATS
39.2.6. DELETE_DICTIONARY_STATS
39.2.7. DELETE_INDEX_STATS
39.2.8. DELETE_SCHEMA_STATS
39.2.9. DELETE_SYSTEM_STATS
39.2.10. DELETE_TABLE_STATS
39.2.11. DROP_STAT_TABLE
39.2.12. EXPORT_COLUMN_STATS
39.2.13. EXPORT_DATABASE_STATS
39.2.14. EXPORT_INDEX_STATS
39.2.15. EXPORT_SCHEMA_STATS
39.2.16. EXPORT_SYSTEM_STATS
39.2.17. EXPORT_TABLE_STATS
39.2.18. GATHER_DATABASE_STATS
39.2.19. GATHER_DICTIONARY_STATS
39.2.20. GATHER_INDEX_STATS
39.2.21. GATHER_SCHEMA_STATS
39.2.22. GATHER_SYSTEM_STATS
39.2.23. GATHER_TABLE_STATS
39.2.24. GET_COLUMN_STATS
39.2.25. GET_INDEX_STATS
39.2.26. GET_TABLE_STATS
39.2.27. IMPORT_COLUMN_STATS
39.2.28. IMPORT_DATABASE_STATS
39.2.29. IMPORT_INDEX_STATS
39.2.30. IMPORT_SCHEMA_STATS
39.2.31. IMPORT_SYSTEM_STATS
39.2.32. IMPORT_TABLE_STATS
39.2.33. LOCK_TABLE_STATS
39.2.34. LOCK_SCHEMA_STATS
39.2.35. SET_COLUMN_STATS
39.2.36. SET_INDEX_STATS
39.2.37. SET_TABLE_STATS
39.2.38. PURGE_STATS
39.2.39. RESTORE_SCHEMA_STATS
39.2.40. RESTORE_TABLE_STATS
39.2.41. SET_PARAM
39.2.42. SET_SYSTEM_STATS
39.2.43. UNLOCK_TABLE_STATS
39.2.44. UNLOCK_SCHEMA_STATS
39.3. 함수
39.3.1. GET_PARAM
39.3.2. GET_STATS_HISTORY_AVAILABILITY
39.3.3. GET_STATS_HISTORY_RETENTION
39.3.4. TO_BOOLEAN
40. DBMS_SYSTEM
40.1. 개요
40.2. 프러시저와 함수
40.2.1. SET_SQL_TRACE_IN_SESSION
41. DBMS_TPR
41.1. 개요
41.2. 프러시저
41.2.1. CREATE_SNAPSHOT
41.2.2. CREATE_SNAPSHOT_ALL
41.2.3. REPORT_TEXT
41.2.4. REPORT_TEXT_ID
41.2.5. REPORT_TEXT_GID
41.2.6. REPORT_TEXT_LAST
41.2.7. REPORT_TEXT_SPECIFIC_TIMES
41.2.8. REPORT_TEXT_MARKED
41.2.9. REPORT_HTML
41.2.10. REPORT_HTML_ID
41.2.11. REPORT_HTML_GID
41.2.12. REPORT_HTML_LAST
41.2.13. REPORT_HTML_SPECIFIC_TIMES
41.2.14. REPORT_HTML_MARKED
41.2.15. FLUSH_ASH
41.2.16. ASH_REPORT_TEXT
41.2.17. CREATE_BASELINE
41.2.18. CREATE_BASELINE_ID
41.2.19. DROP_BASELINE
41.2.20. DROP_BASELINE_ID
41.2.21. BASELINE_REPORT_TEXT
41.2.22. BASELINE_REPORT_TEXT_ID
42. DBMS_TRANSACTION
42.1. 개요
42.2. 프러시저
42.2.1. COMMIT
42.2.2. ROLLBACK, ROLLBACK_SAVEPOINT
42.2.3. SAVEPOINT
43. DBMS_TYPES
43.1. 개요
43.2. 상수 목록
44. DBMS_UTILITY
44.1. 개요
44.2. 타입
44.2.1. UNCL_ARRAY
44.3. 프러시저와 함수
44.3.1. COMMA_TO_TABLE
44.3.2. CURRENT_INSTANCE
44.3.3. FORMAT_CALL_STACK
44.3.4. FORMAT_ERROR_BACKTRACE
44.3.5. FORMAT_ERROR_STACK
44.3.6. GET_HASH_VALUE
44.3.7. GET_PARAMETER_VALUE
44.3.8. GET_TIME
45. DBMS_VERIFY
45.1. 개요
45.2. 프러시저
45.2.1. SCHEMA_INDEX
45.2.2. TABLE_INDEX
45.2.3. INDEX
46. DBMS_XMLDOM
46.1. 개요
46.2. 타입
46.2.1. DOMAttr
46.2.2. DOMCDataSection
46.2.3. DOMCharacterData
46.2.4. DOMComment
46.2.5. DOMDocument
46.2.6. DOMDocumentFragment
46.2.7. DOMDocumentType
46.2.8. DOMElement
46.2.9. DOMEntity
46.2.10. DOMEntityReference
46.2.11. DOMImplementation
46.2.12. DOMNamedNodeMap
46.2.13. DOMNode
46.2.14. DOMNodeList
46.2.15. DOMNotation
46.2.16. DOMProcessingInstruction
46.2.17. DOMText
46.3. 프러시저와 함수
46.3.1. ADOPTNODE
46.3.2. APPENDCHILD
46.3.3. CREATECDATASECTION
46.3.4. CREATECOMMENT
46.3.5. CREATEELEMENT
46.3.6. CREATETEXTNODE
46.3.7. FREEDOCFRAG
46.3.8. FREEDOCUMENT
46.3.9. FREENODE
46.3.10. GETATTRIBUTE
46.3.11. GETATTRIBUTENODE
46.3.12. GETATTRIBUTES
46.3.13. GETCHILDNODES
46.3.14. GETCHILDRENBYTAGNAME
46.3.15. GETDOCUMENTELEMENT
46.3.16. GETELEMENTSBYTAGNAME
46.3.17. GETFIRSTCHILD
46.3.18. GETLASTCHILD
46.3.19. GETLENGTH
46.3.20. GETNAME
46.3.21. GETNAMEDITEM
46.3.22. GETNODENAME
46.3.23. GETNODETYPE
46.3.24. GETNODEVALUE
46.3.25. GETOWNERDOCUMENT
46.3.26. GETPARENTNODE
46.3.27. GETVALUE
46.3.28. GETXMLTYPE
46.3.29. HASATTRIBUTE
46.3.30. IMPORTNODE
46.3.31. INSERTBEFORE
46.3.32. ISNULL
46.3.33. ITEM
46.3.34. MAKEATTR
46.3.35. MAKEDOCUMENT
46.3.36. MAKEELEMENT
46.3.37. MAKENODE
46.3.38. NEWDOMDOCUMENT
46.3.39. REMOVEATTRIBUTE
46.3.40. REMOVECHILD
46.3.41. REPLACECHILD
46.3.42. SETATTRIBUTE
46.3.43. SETVALUE
46.3.44. WRITETOCLOB
47. DBMS_XMLGEN
47.1. 개요
47.2. 타입
47.2.1. ctxHandle
47.3. 프러시저와 함수
47.3.1. CLOSECONTEXT
47.3.2. CONVERT
47.3.3. GETNUMROWSPROCESSED
47.3.4. GETXML
47.3.5. GETXMLTYPE
47.3.6. NEWCONTEXT
47.3.7. SETMAXROWS
47.3.8. SETNULLHANDLING
47.3.9. SETROWTAG
47.3.10. SETROWSETTAG
47.3.11. SETSKIPROWS
48. DBMS_XPLAN
48.1. 개요
48.2. 함수
48.2.1. DISPLAY_CURSOR
49. HTF
49.1. 개요
49.2. 함수
49.2.1. ADDRESS
49.2.2. ANCHOR
49.2.3. ANCHOR2
49.2.4. APPLETCLOSE
49.2.5. APPLETOPEN
49.2.6. AREA
49.2.7. BASEFONT
49.2.8. BGSOUND
49.2.9. BIG
49.2.10. BLOCKQUOTECLOSE
49.2.11. BLOCKQUOTEOPEN
49.2.12. BODYCLOSE
49.2.13. BODYOPEN
49.2.14. BOLD
49.2.15. BR
49.2.16. CENTER
49.2.17. CENTERCLOSE
49.2.18. CENTEROPEN
49.2.19. CITE
49.2.20. CODE
49.2.21. COMMENT
49.2.22. DFN
49.2.23. DIRLISTCLOSE
49.2.24. DIRLISTOPEN
49.2.25. DIV
49.2.26. DLISTCLOSE
49.2.27. DLISTDEF
49.2.28. DLISTOPEN
49.2.29. DLISTTERM
49.2.30. EM
49.2.31. ESCAPE_SC
49.2.32. FONTCLOSE
49.2.33. FONTOPEN
49.2.34. FORMCHECKBOX
49.2.35. FORMCLOSE
49.2.36. FORMFILE
49.2.37. FORMHIDDEN
49.2.38. FORMIMAGE
49.2.39. FORMOPEN
49.2.40. FORMPASSWORD
49.2.41. FORMRADIO
49.2.42. FORMRESET
49.2.43. FORMSELECTCLOSE
49.2.44. FORMSELECTOPEN
49.2.45. FORMSELECTOPTION
49.2.46. FORMSUBMIT
49.2.47. FORMTEXT
49.2.48. FORMTEXTAREA
49.2.49. TEXTAREACLOSE
49.2.50. FORMTEXTAREAOPEN
49.2.51. FRAME
49.2.52. FRAMESETCLOSE
49.2.53. FRAMESETOPEN
49.2.54. HEADCLOSE
49.2.55. HEADER
49.2.56. HEADOPEN
49.2.57. HR
49.2.58. HTMLCLOSE
49.2.59. HTMLOPEN
49.2.60. IMG
49.2.61. ISINDEX
49.2.62. ITALIC
49.2.63. KBD
49.2.64. LINKREL
49.2.65. LINKREV
49.2.66. LISTHEADER
49.2.67. LISTINGCLOSE
49.2.68. LISTINGOPEN
49.2.69. LISTITEM
49.2.70. MAILTO
49.2.71. MAPCLOSE
49.2.72. MAPOPEN
49.2.73. MENULISTCLOSE
49.2.74. MENULISTOPEN
49.2.75. META
49.2.76. NOBR
49.2.77. NOFRAMESCLOSE
49.2.78. NOFRAMESOPEN
49.2.79. OLISTCLOSE
49.2.80. OLISTOPEN
49.2.81. PARA
49.2.82. PARAGRAPH
49.2.83. PARAM
49.2.84. PLAINTEXT
49.2.85. PRECLOSE
49.2.86. PREOPEN
49.2.87. S
49.2.88. SAMPLE
49.2.89. SCRIPT
49.2.90. SMALL
49.2.91. STRIKE
49.2.92. STRONG
49.2.93. STYLE
49.2.94. SUB
49.2.95. SUP
49.2.96. TABLECAPTION
49.2.97. TABLECLOSE
49.2.98. TABLEDATA
49.2.99. TABLEHEADER
49.2.100. TABLEOPEN
49.2.101. TABLEROWCLOSE
49.2.102. TABLEROWOPEN
49.2.103. TELETYPE
49.2.104. TITLE
49.2.105. ULISTCLOSE
49.2.106. ULISTOPEN
49.2.107. UNDERLINE
49.2.108. VARIABLE
49.2.109. WBR
50. HTP
50.1. 개요
50.2. Apache와의 연동
50.3. 프러시저와 함수
50.3.1. BODYCLOSE
50.3.2. BODYOPEN
50.3.3. BR
50.3.4. CENTER
50.3.5. CENTERCLOSE
50.3.6. CENTEROPEN
50.3.7. FONTCLOSE
50.3.8. FONTOPEN
50.3.9. FORMSELECTCLOSE
50.3.10. FORMSELECTOPEN
50.3.11. FORMSELECTOPTION
50.3.12. GET_PAGE
50.3.13. HEADCLOSE
50.3.14. HEADER
50.3.15. HEADOPEN
50.3.16. HR
50.3.17. HTMLCLOSE
50.3.18. HTMLOPEN
50.3.19. IMG
50.3.20. IMG2
50.3.21. LINE
50.3.22. PRINT
50.3.23. PRN
50.3.24. TITLE
51. OWA_UTIL
51.1. 개요
51.2. 프러시저
51.2.1. WHO_CALLED_ME
52. TEXT_DDL
52.1. 개요
52.2. 프러시저
52.2.1. ADD_STOPWORD
52.2.2. CREATE_PREFERENCE
52.2.3. CREATE_STOPLIST
52.2.4. DROP_PREFERENCE
52.2.5. DROP_STOPLIST
52.2.6. REMOVE_STOPWORD
52.2.7. SET_ATTRIBUTE
53. UTL_COMPRESS
53.1. 개요
53.2. 함수
53.2.1. LZ_COMPRESS
53.2.2. LZ_UNCOMPRESS
54. UTL_ENCODE
54.1. 개요
54.2. 함수
54.2.1. BASE64_DECODE
54.2.2. BASE64_ENCODE
54.2.3. QUOTED_PRINTABLE_DECODE
54.2.4. QUOTED_PRINTABLE_ENCODE
54.2.5. TEXT_DECODE
54.2.6. TEXT_ENCODE
55. UTL_FILE
55.1. 개요
55.2. 프러시저
55.2.1. FCLOSE
55.2.2. FCLOSE_ALL
55.2.3. FCOPY
55.2.4. FFLUSH
55.2.5. FGETATTR
55.2.6. FREMOVE
55.2.7. FRENAME
55.2.8. FSEEK
55.2.9. GET_LINE
55.2.10. GET_RAW
55.2.11. NEW_LINE
55.2.12. PUT
55.2.13. PUTF
55.2.14. PUT_RAW
55.2.15. PUT_LINE
55.3. 함수
55.3.1. FGETPOS
55.3.2. FOPEN
55.3.3. IS_OPEN
56. UTL_HTTP
56.1. 개요
56.2. 상수
56.2.1. HTTP 버전 상수
56.2.2. HTTP 포트 상수
56.2.3. 상태 코드 상수
56.3. 타입
56.3.1. HTML_PIECES
56.3.2. req
56.3.3. resp
56.4. 예외
56.5. 함수
56.5.1. BEGIN_REQUEST
56.5.2. GET_RESPONSE
56.5.3. REQUEST
56.6. 프러시저
56.6.1. END_RESPONSE
56.6.2. GET_BODY_CHARSET
56.6.3. GET_DETAILED_EXCP_SUPPORT
56.6.4. GET_TRANSFER_TIMEOUT
56.6.5. READ_TEXT
56.6.6. SET_BODY_CHARSET
56.6.7. SET_DETAILED_EXCP_SUPPORT
56.6.8. SET_HEADER
56.6.9. SET_RESPONSE_ERROR_CHECK
56.6.10. SET_TRANSFER_TIMEOUT
56.6.11. WRITE_TEXT
56.7. URL
56.8. 예제
57. UTL_I18N
57.1. 개요
57.2. 프러시저와 함수
57.2.1. RAW_TO_CHAR
57.2.2. STRING_TO_RAW
57.2.3. UNESCAPE_REFERENCE
58. UTL_MATCH
58.1. 개요
58.2. 함수
58.2.1. EDIT_DISTANCE
58.2.2. EDIT_DISTANCE_SIMILARITY
58.2.3. JARO_WINKLER
58.2.4. JARO_WINKLER_SIMILARITY
59. UTL_RAW
59.1. 개요
59.2. 함수
59.2.1. BIT_AND
59.2.2. BIT_COMPLEMENT
59.2.3. BIT_OR
59.2.4. BIT_XOR
59.2.5. CAST_FROM_BINARY_DOUBLE
59.2.6. CAST_FROM_BINARY_FLOAT
59.2.7. CAST_FROM_BINARY_INTEGER
59.2.8. CAST_FROM_NUMBER
59.2.9. CAST_TO_BINARY_DOUBLE
59.2.10. CAST_TO_BINARY_FLOAT
59.2.11. CAST_TO_BINARY_INTEGER
59.2.12. CAST_TO_NUMBER
59.2.13. CAST_TO_RAW
59.2.14. CAST_TO_VARCHAR2
59.2.15. COMPARE
59.2.16. CONCAT
59.2.17. COPIES
59.2.18. LENGTH
59.2.19. OVERLAY
59.2.20. REVERSE
59.2.21. SUBSTR
59.2.22. TRANSLATE
59.2.23. TRANSLITERATE
59.2.24. XRANGE
60. UTL_RECOMP
60.1. 개요
60.2. 프러시저
60.2.1. RECOMP_SERIAL
61. UTL_TCP
61.1. 개요
61.2. 타입
61.2.1. CONNECTION
61.3. 상수
61.3.1. CRLF
61.4. 프러시저와 함수
61.4.1. CLOSE_ALL_CONNECTIONS
61.4.2. CLOSE_CONNECTION
61.4.3. GET_LINE
61.4.4. GET_RAW
61.4.5. GET_TEXT
61.4.6. OPEN_CONNECTION
61.4.7. READ_LINE
61.4.8. READ_RAW
61.4.9. READ_TEXT
61.4.10. WRITE_LINE
61.4.11. WRITE_RAW
61.4.12. WRITE_TEXT
62. UTL_URL
62.1. 개요
62.2. 함수
62.2.1. ESCAPE
62.2.2. UNESCAPE
색인

예 목차

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