數據庫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.計算機英語
