Tibero
		Next

Tibero tbPSM Reference Guide

Tibero 6

Copyright © 2020 TmaxData Co., Ltd. All Rights Reserved.

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.

Trademarks

Tibero® is a registered trademark of TmaxData Co., Ltd. Other products, titles or services may be registered trademarks of their respective companies.

Open Source Software Notice

Some modules or files of this product are subject to the terms of the following licenses. : OpenSSL, RSA Data Security, Inc., Apache Foundation, Jean-loup Gailly and Mark Adler, Paul Hsieh's hash

Detailed Information related to the license can be found in the following directory : ${INSTALL_PATH}/license/oss_licenses

Document Information

Title: Tibero tbPSM Reference Guide

Publication Date: 2020-03-13

Software Version: Tibero 6 (FixSet07)

Edition: v2.1.7.4

Table of Contents

About This Document

1. Introduction to Packages

1.1. Overview

1.2. Structure

1.2.1. User-Defined Packages
1.2.2. System Packages

2.1. Overview

2.2. Methods

2.2.1. CONVERT
2.2.2. GET
2.2.3. ACCESS
2.2.4. GETTYPENAME

3. DBMS_ALERT

3.1. Overview

3.2. Procedures

3.2.1. REGISTER
3.2.2. REMOVE
3.2.3. REMOVEALL
3.2.4. SET_DEFAULTS
3.2.5. SIGNAL
3.2.6. WAITANY
3.2.7. WAITONE

4. DBMS_APPLICATION_INFO

4.1. Overview

4.2. Procedures

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.1. Overview

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. Procedures and Functions

5.3.1. DEQUEUE
5.3.2. DEQUEUE_ARRAY
5.3.3. ENQUEUE
5.3.4. ENQUEUE_ARRAY

6. DBMS_AQADM

6.1. Overview

6.2. Procedures

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. Overview

7.2. Encryption/Decryption Algorithms, Chaining, and Padding

7.3. Hash Functions

7.4. Procedures and Functions

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. Overview

8.2. Constants

8.2.1. MAJOR
8.2.2. MINOR

9. DBMS_DDL

9.1. Overview

9.2. Procedures and Functions

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. Overview

10.2. Types

10.2.1. breakpoint_info
10.2.2. program_info
10.2.3. runtime_info

10.3. Procedures and Functions

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. Overview

11.2. Procedure

11.2.1. CREATE_ERROR_LOG

12. DBMS_FLASHBACK

12.1. Overview

12.2. Procedure

12.2.1. GET_SYSTEM_CHANGE_NUMBER

13. DBMS_JAVA

13.1. Overview

13.2. Procedure

13.2.1. SET_OUTPUT

13.3. Functions

13.3.1. LONGNAME
13.3.2. SHORTNAME

14. DBMS_JOB

14.1. Overview

14.2. Procedures

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. Overview

15.2. Procedures

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. Overview

16.2. Exceptions

16.3. Procedures

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. Functions

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. Overview

17.2. Procedures

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. Overview

18.2. Function

18.2.1. GET_DDL

19. DBMS_MONITOR

19.1. Overview

19.2. Procedures and Functions

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. Overview

20.2. Procedures

20.2.1. EXPLAIN_REWRITE
20.2.2. REFRESH

21. DBMS_OBFUSCATION_TOOLKIT

21.1. Overview

21.2. Procedures and Functions

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. Overview

22.2. Procedures

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. Overview

23.2. Procedures and Functions

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. Overview

24.2. Procedures and Functions

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. Overview

25.2. Procedures

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. Overview

26.2. Functions

26.2.1. ONLINE_INDEX_CLEAN

27. DBMS_RESOURCE_MANAGER

27.1. Overview

27.2. Procedure

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. Overview

28.2. Procedures and Functions

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. Overview

29.2. Procedures

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. Overview

30.2. Procedure

30.2.1. ROWID_INFO

30.3. Functions

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. Overview

31.2. Procedures

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. Overview

32.2. Procedures and Functions

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. Overview

33.2. Procedures

33.2.1. SPACE_USAGE
33.2.2. UNUSED_SPACE

34. DBMS_SPACE_ADMIN

34.1. Overview

34.2. Procedure

34.2.1. SEGMENT_DUMP

35. DBMS_SPH

35.1. Overview

35.2. Procedures

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. Overview

36.2. Types

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. Procedures

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. Functions

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. Overview

37.2. Function

37.2.1. REPORT_SQL_MONITOR

38. DBMS_SQL_TRANSLATOR

38.1. Overview

38.2. Procedures and Functions

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. Overview

39.2. Procedures

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. Functions

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. Overview

40.2. Procedure

40.2.1. SET_SQL_TRACE_IN_SESSION

41. DBMS_TPR

41.1. Overview

41.2. Procedures

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. Overview

42.2. Procedures

42.2.1. COMMIT
42.2.2. ROLLBACK, ROLLBACK_SAVEPOINT
42.2.3. SAVEPOINT

43. DBMS_TYPES

43.1. Overview
43.2. Constants

44. DBMS_UTILITY

44.1. Overview

44.2.1. UNCL_ARRAY

44.3. Procedures and Functions

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. Overview

45.2. Procedures

45.2.1. SCHEMA_INDEX
45.2.2. TABLE_INDEX
45.2.3. INDEX

46. DBMS_XMLDOM

46.1. Overview

46.2. Types

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. Procedures and Functions

47. DBMS_XMLGEN

47.1. Overview

47.2. Types

47.2.1. ctxHandle

47.3. Procedures and Functions

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. Overview

48.2. Function

48.2.1. DISPLAY_CURSOR

49.1. Overview

49.2. Functions

50.1. Overview

50.2. Interoperation with Apache

50.3. Procedures and Functions

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. Overview

51.2. Procedures

51.2.1. WHO_CALLED_ME

52. TEXT_DDL

52.1. Overview

52.2. Procedures

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. Overview

53.2. Functions

53.2.1. LZ_COMPRESS
53.2.2. LZ_UNCOMPRESS

54. UTL_ENCODE

54.1. Overview

54.2. Functions

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. Overview

55.2. Procedures

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. Functions

55.3.1. FGETPOS
55.3.2. FOPEN
55.3.3. IS_OPEN

56. UTL_HTTP

56.1. Overview

56.2. Constants

56.2.1. HTTP Version Constant
56.2.2. HTTP Port Constant
56.2.3. Status Code Constants

56.3. Types

56.3.1. HTML_PIECES
56.3.2. req
56.3.3. resp

56.4. Exceptions

56.5. Functions

56.5.1. BEGIN_REQUEST
56.5.2. GET_RESPONSE
56.5.3. REQUEST

56.6. Procedures

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.8. Example

57. UTL_I18N

57.1. Overview

57.2. Functions

57.2.1. RAW_TO_CHAR
57.2.2. STRING_TO_RAW
57.2.3. UNESCAPE_REFERENCE

58. UTL_MATCH

58.1. Overview

58.2. Functions

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. Overview

59.2. Functions

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. Overview

60.2. Procedures

60.2.1. RECOMP_SERIAL

61. UTL_TCP

61.1. Overview

61.2. Types

61.2.1. CONNECTION

61.3. Constants

61.3.1. CRLF

61.4. Procedures and Functions

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. Overview

62.2. Functions

62.2.1. ESCAPE
62.2.2. UNESCAPE

List of Examples

[Example 1.1] Declaration of EMP_MGMT Package
[Example 1.2] Body of EMP_MGMT Package

		Next
		About This Document

Copyright © 2020 TmaxData Co., Ltd. All Rights Reserved.