資料庫desc的用法有哪些用法
計算機程式的學習比較複雜,那麼資料庫desc的用法的用法你知道嗎?下面本站小編就跟你們詳細介紹下資料庫desc的用法的用法,希望對你們有用。
資料庫中desc的用法1)desc就是用於查詢出結果時候對結果進行排序,是降序排序,而asc就是升序。。要用與order by一起用。
2)例如select * from student order by id desc; 就是把選出的結果經過“按id從大到小排序”後,把資源返回。
3)還可以select * from student order by age desc,id desc;用“,”號隔開多個排序條件,這樣,先按age 再按 id,就是說,先按age從大到小排序,如果有相同年齡的,那麼相同年齡的學生再按他們的id從大到小排序。
資料庫中desc和ASC的排序區別用 DESC 表示按倒序排序(即:從大到小排序)
用 ACS 表示按正序排序(即:從小到大排序)
資料庫desc的用法的用法示例使用desc檢視資料庫物件
desc是用來檢視資料庫物件的一個命令.格式為desc+物件名
SQL> desc course;
名稱 是否為空? 型別
----------------------------------------- -------- ----------------------------
COURSEID NOT NULL VARCHAR2(32)
COURSENAME NOT NULL VARCHAR2(64)
COURSENAME_EN VARCHAR2(256)
COURSENO NOT NULL VARCHAR2(32)
DEPARTMENTID VARCHAR2(32)
STAFFROOMID NOT NULL VARCHAR2(32)
COURSEKINDCODE NOT NULL VARCHAR2(8)
ISOTHERLANG CHAR(2)
TOTALPERIODNUM NOT NULL NUMBER(3)
TEACHPERIODNUM NUMBER
TESTPERIODNUM NUMBER
EXERPERIODNUM NUMBER
CREDITHOURNUM NUMBER
TEACHMETHODCODE CHAR(2)
REFBOOKNAME CHAR(1)
PRECOURSENAME CHAR(1)
EXAMMETHODCODE CHAR(2)
BRIEF CHAR(1)
STATUS NOT NULL VARCHAR2(10)
COMMENTS CHAR(1)
REEXAM CHAR(1)
LABEL CHAR(1)
PASSSCORE NUMBER
FULLSCORE NUMBER
TEXTBOOK CHAR(1)
SHORTNAME NOT NULL VARCHAR2(8)
SQL> desc dbms_crypto_toolkit;
PROCEDURE ABORTIDENTITY
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
IDENTITY RECORD IN/OUT
DESCRIPTOR RAW(200) IN/OUT
PROCEDURE CLOSEPERSONA
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE CLOSEWALLET
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
PROCEDURE CLOSEWALLET
PROCEDURE CREATEIDENTITY
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
IDENTITYTYPE BINARY_INTEGER IN
PUBLIC_IDENTITY VARCHAR2 IN
ALIAS VARCHAR2 IN
LONGER_DESCRIPTION VARCHAR2 IN
TRUST_QUALIFIER VARCHAR2 IN
IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
PROCEDURE CREATEPERSONA
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
CIPHER_TYPE BINARY_INTEGER IN
PRIVATE_INFORMATION RECORD IN
INFORMATION RAW(200) IN
PRL VARCHAR2 IN
ALIAS VARCHAR2 IN
LONGER_DESCRIPTION VARCHAR2 IN
PERSONA RECORD OUT
PERSONA RAW(200) OUT
PROCEDURE CREATEWALLET
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE CREATEWALLET
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE DECRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENCRYPTED_DATA RAW IN
DECRYPTED_DATA RAW OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION DECRYPT RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENCRYPTED_DATA RAW IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE DECRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENCRYPTED_STRING VARCHAR2 IN
DECRYPTED_STRING VARCHAR2 OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION DECRYPT RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENCRYPTED_STRING VARCHAR2 IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE DEENVELOPE
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENVELOPED_DATA RAW IN
OUTPUT_DATA RAW OUT
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SENDER_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION DEENVELOPE RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENVELOPED_DATA RAW IN
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SENDER_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE DEENVELOPE
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENVELOPED_STRING VARCHAR2 IN
OUTPUT_STRING VARCHAR2 OUT
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SENDER_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION DEENVELOPE RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENVELOPED_STRING VARCHAR2 IN
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SENDER_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE DESTROYWALLET
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE ENCRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
ENCRYPTED_DATA RAW OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENCRYPT RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENCRYPT RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE ENVELOPE
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT RAW IN
ENVELOPED_DATA RAW OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENVELOPE RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT RAW IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE ENVELOPE
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENVELOPED_STRING VARCHAR2 OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENVELOPE RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE ENVELOPE
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT RAW IN
ENVELOPED_DATA RAW OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENVELOPE RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT RAW IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE ENVELOPE
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENVELOPED_STRING VARCHAR2 OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENVELOPE RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE HASH
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION HASH RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE HASH
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION HASH RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE INITIALIZE
PROCEDURE KEYEDHASH
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
KEYED_HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION KEYEDHASH RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE KEYEDHASH
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
KEYED_HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION KEYEDHASH RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE OPENPERSONA
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE OPENWALLET
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
PERSONA_LIST TABLE OF RECORD OUT
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE OPENWALLET
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
PERSONA_LIST TABLE OF RECORD OUT
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE PKDECRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
DECRYPTED_DATA RAW OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKDECRYPT RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKDECRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
DECRYPTED_STRING VARCHAR2 OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKDECRYPT RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKENCRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT RAW IN
ENCRYPTED_DATA RAW OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKENCRYPT RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT RAW IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKENCRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTED_STRING VARCHAR2 OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKENCRYPT RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RECIPIENT RECORD IN
DESCRIPTOR RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKENCRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT RAW IN
ENCRYPTED_DATA RAW OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKENCRYPT RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT RAW IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKENCRYPT
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTED_STRING VARCHAR2 OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKENCRYPT RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_RECIPIENTS BINARY_INTEGER IN
RECIPIENT_LIST RECORD IN
DESCRIPTOR_ARRAY RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE RANDOMBYTES
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN
RANDOM_BYTES RAW OUT
FUNCTION RANDOMBYTES RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN
PROCEDURE RANDOMNUMBER
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RANDOM_NUMBER BINARY_INTEGER OUT
FUNCTION RANDOMNUMBER RETURNS BINARY_INTEGER
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
PROCEDURE REMOVEIDENTITY
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
PROCEDURE REMOVEPERSONA
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE SEEDRANDOM
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SEED RAW IN
PROCEDURE SEEDRANDOM
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SEED VARCHAR2 IN
PROCEDURE SEEDRANDOM
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SEED BINARY_INTEGER IN
PROCEDURE SIGN
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGN RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE SIGN
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGN RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE SIGNDETACHED
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGNDETACHED RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE SIGNDETACHED
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGNDETACHED RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE STOREPERSONA
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
PROCEDURE STOREPERSONA
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE STORETRUSTEDIDENTITY
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
IDENTITY RECORD IN/OUT
DESCRIPTOR RAW(200) IN/OUT
PERSONA RECORD IN
PERSONA RAW(200) IN
PROCEDURE TERMINATE
FUNCTION VALIDATE RETURNS BOOLEAN
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
IDENTITY RECORD IN
DESCRIPTOR RAW(200) IN
PROCEDURE VERIFY
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SIGNATURE RAW IN
EXTRACTED_MESSAGE RAW OUT
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SIGNING_PARTY_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION VERIFY RETURNS RAW
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SIGNATURE RAW IN
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SIGNING_PARTY_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE VERIFY
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SIGNATURE RAW IN
EXTRACTED_MESSAGE_STRING VARCHAR2 OUT
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SIGNING_PARTY_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION VERIFY RETURNS VARCHAR2
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SIGNATURE RAW IN
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SIGNING_PARTY_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE VERIFYDETACHED
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
DATA RAW IN
SIGNATURE RAW IN
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SIGNING_PARTY_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE VERIFYDETACHED
引數名稱 型別 輸入/輸出預設值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
DATA_STRING VARCHAR2 IN
SIGNATURE RAW IN
VERIFIED BOOLEAN OUT
VALIDATED BOOLEAN OUT
SIGNING_PARTY_IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
猜你喜歡:
1.資料庫中update的用法
2.如何使用DOS命令來啟動或者停止MySQL資料庫
3.資料庫desc的用法
4.資料庫between的用法
5.計算機英語