亚洲欧美精品沙发,日韩在线精品视频,亚洲Av每日更新在线观看,亚洲国产另类一区在线5

<pre id="hdphd"></pre>

  • <div id="hdphd"><small id="hdphd"></small></div>
      學(xué)習(xí)啦>學(xué)習(xí)英語>專業(yè)英語>計算機(jī)英語>

      數(shù)據(jù)庫desc的用法有哪些用法

      時間: 長思709 分享

        計算機(jī)程序的學(xué)習(xí)比較復(fù)雜,那么數(shù)據(jù)庫desc的用法的用法你知道嗎?下面學(xué)習(xí)啦小編就跟你們詳細(xì)介紹下數(shù)據(jù)庫desc的用法的用法,希望對你們有用。

        數(shù)據(jù)庫中desc的用法

        1)desc就是用于查詢出結(jié)果時候?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;用“,”號隔開多個排序條件,這樣,先按age 再按 id,就是說,先按age從大到小排序,如果有相同年齡的,那么相同年齡的學(xué)生再按他們的id從大到小排序。

        數(shù)據(jù)庫中desc和ASC的排序區(qū)別

        用 DESC 表示按倒序排序(即:從大到小排序)

        用 ACS 表示按正序排序(即:從小到大排序)

        數(shù)據(jù)庫desc的用法的用法示例

        使用desc查看數(shù)據(jù)庫對象

        desc是用來查看數(shù)據(jù)庫對象的一個命令.格式為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

        參數(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


      猜你喜歡:

      1.數(shù)據(jù)庫中update的用法

      2.如何使用DOS命令來啟動或者停止MySQL數(shù)據(jù)庫

      3.數(shù)據(jù)庫desc的用法

      4.數(shù)據(jù)庫between的用法

      5.計算機(jī)英語

      543047