數(shù)據(jù)庫(kù)desc的用法有哪些用法
計(jì)算機(jī)程序的學(xué)習(xí)比較復(fù)雜,那么數(shù)據(jù)庫(kù)desc的用法的用法你知道嗎?下面學(xué)習(xí)啦小編就跟你們?cè)敿?xì)介紹下數(shù)據(jù)庫(kù)desc的用法的用法,希望對(duì)你們有用。
數(shù)據(jù)庫(kù)中desc的用法
1)desc就是用于查詢出結(jié)果時(shí)候?qū)Y(jié)果進(jìn)行排序,是降序排序,而asc就是升序。。要用與order by一起用。
2)例如select * from student order by id desc; 就是把選出的結(jié)果經(jīng)過“按id從大到小排序”后,把資源返回。
3)還可以select * from student order by age desc,id desc;用“,”號(hào)隔開多個(gè)排序條件,這樣,先按age 再按 id,就是說,先按age從大到小排序,如果有相同年齡的,那么相同年齡的學(xué)生再按他們的id從大到小排序。
數(shù)據(jù)庫(kù)中desc和ASC的排序區(qū)別
用 DESC 表示按倒序排序(即:從大到小排序)
用 ACS 表示按正序排序(即:從小到大排序)
數(shù)據(jù)庫(kù)desc的用法的用法示例
使用desc查看數(shù)據(jù)庫(kù)對(duì)象
desc是用來查看數(shù)據(jù)庫(kù)對(duì)象的一個(gè)命令.格式為desc+對(duì)象名
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
IDENTITY RECORD IN/OUT
DESCRIPTOR RAW(200) IN/OUT
PROCEDURE CLOSEPERSONA
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE CLOSEWALLET
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
PROCEDURE CLOSEWALLET
PROCEDURE CREATEIDENTITY
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE CREATEWALLET
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE DECRYPT
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENCRYPTED_DATA RAW IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE DECRYPT
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
ENCRYPTED_STRING VARCHAR2 IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE DEENVELOPE
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE ENCRYPT
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
ENCRYPTED_DATA RAW OUT
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENCRYPT RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION ENCRYPT RETURNS VARCHAR2
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE ENVELOPE
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION HASH RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE HASH
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION HASH RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE INITIALIZE
PROCEDURE KEYEDHASH
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
KEYED_HASH RAW OUT
HASH_STATE BINARY_INTEGER IN DEFAULT
FUNCTION KEYEDHASH RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE KEYEDHASH
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
HASH_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE OPENPERSONA
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE OPENWALLET
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PASSWORD VARCHAR2 IN
PERSONA_LIST TABLE OF RECORD OUT
WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT
PROCEDURE PKDECRYPT
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
DECRYPTED_DATA RAW OUT
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
FUNCTION PKDECRYPT RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKDECRYPT
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
DECRYPTION_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE PKENCRYPT
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN
RANDOM_BYTES RAW OUT
FUNCTION RANDOMBYTES RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN
PROCEDURE RANDOMNUMBER
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
RANDOM_NUMBER BINARY_INTEGER OUT
FUNCTION RANDOMNUMBER RETURNS BINARY_INTEGER
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
PROCEDURE REMOVEIDENTITY
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
IDENTITY RECORD OUT
DESCRIPTOR RAW(200) OUT
PROCEDURE REMOVEPERSONA
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE SEEDRANDOM
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SEED RAW IN
PROCEDURE SEEDRANDOM
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SEED VARCHAR2 IN
PROCEDURE SEEDRANDOM
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
SEED BINARY_INTEGER IN
PROCEDURE SIGN
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGN RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE SIGN
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGN RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE SIGNDETACHED
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGNDETACHED RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT RAW IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE SIGNDETACHED
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE RAW OUT
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
FUNCTION SIGNDETACHED RETURNS RAW
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
INPUT_STRING VARCHAR2 IN
SIGNATURE_STATE BINARY_INTEGER IN DEFAULT
PROCEDURE STOREPERSONA
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
WALLET RECORD IN/OUT
WALLET RAW(200) IN/OUT
PROCEDURE STOREPERSONA
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN/OUT
PERSONA RAW(200) IN/OUT
PROCEDURE STORETRUSTEDIDENTITY
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
IDENTITY RECORD IN/OUT
DESCRIPTOR RAW(200) IN/OUT
PERSONA RECORD IN
PERSONA RAW(200) IN
PROCEDURE TERMINATE
FUNCTION VALIDATE RETURNS BOOLEAN
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
PERSONA RECORD IN
PERSONA RAW(200) IN
IDENTITY RECORD IN
DESCRIPTOR RAW(200) IN
PROCEDURE VERIFY
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
參數(shù)名稱 類型 輸入/輸出默認(rèn)值?
------------------------------ ----------------------- ------ --------
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
猜你喜歡: