国产宅男网站在线|亚洲A级性爱免费视频|亚洲中精品级在线|午夜福利AA毛

  • <dd id="gf5jf"><th id="gf5jf"></th></dd>

    <cite id="gf5jf"><label id="gf5jf"></label></cite>
  • <div id="gf5jf"><listing id="gf5jf"></listing></div>
    學習啦>學習英語>專業(yè)英語>計算機英語>

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

    時間: 長思709 分享

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

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

      1)desc就是用于查詢出結(jié)果時候?qū)Y(jié)果進行排序,是降序排序,而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從大到小排序,如果有相同年齡的,那么相同年齡的學生再按他們的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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      IDENTITY RECORD IN/OUT

      DESCRIPTOR RAW(200) IN/OUT

      PROCEDURE CLOSEPERSONA

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN/OUT

      PERSONA RAW(200) IN/OUT

      PROCEDURE CLOSEWALLET

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      WALLET RECORD IN/OUT

      WALLET RAW(200) IN/OUT

      PROCEDURE CLOSEWALLET

      PROCEDURE CREATEIDENTITY

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PASSWORD VARCHAR2 IN

      WALLET RECORD IN/OUT

      WALLET RAW(200) IN/OUT

      WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

      PROCEDURE CREATEWALLET

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PASSWORD VARCHAR2 IN

      WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

      PROCEDURE DECRYPT

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      ENCRYPTED_DATA RAW IN

      DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE DECRYPT

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      ENCRYPTED_STRING VARCHAR2 IN

      DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE DEENVELOPE

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PASSWORD VARCHAR2 IN

      WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

      PROCEDURE ENCRYPT

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

      FUNCTION ENCRYPT RETURNS VARCHAR2

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT_STRING VARCHAR2 IN

      ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE ENVELOPE

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      HASH RAW OUT

      HASH_STATE BINARY_INTEGER IN DEFAULT

      FUNCTION HASH RETURNS RAW

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      HASH_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE HASH

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT_STRING VARCHAR2 IN

      HASH_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE INITIALIZE

      PROCEDURE KEYEDHASH

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      HASH_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE KEYEDHASH

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT_STRING VARCHAR2 IN

      HASH_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE OPENPERSONA

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN/OUT

      PERSONA RAW(200) IN/OUT

      PROCEDURE OPENWALLET

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PASSWORD VARCHAR2 IN

      PERSONA_LIST TABLE OF RECORD OUT

      WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

      PROCEDURE PKDECRYPT

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE PKDECRYPT

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT_STRING VARCHAR2 IN

      DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE PKENCRYPT

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN

      RANDOM_BYTES RAW OUT

      FUNCTION RANDOMBYTES RETURNS RAW

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN

      PROCEDURE RANDOMNUMBER

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      RANDOM_NUMBER BINARY_INTEGER OUT

      FUNCTION RANDOMNUMBER RETURNS BINARY_INTEGER

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      PROCEDURE REMOVEIDENTITY

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      IDENTITY RECORD OUT

      DESCRIPTOR RAW(200) OUT

      PROCEDURE REMOVEPERSONA

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN/OUT

      PERSONA RAW(200) IN/OUT

      PROCEDURE SEEDRANDOM

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      SEED RAW IN

      PROCEDURE SEEDRANDOM

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      SEED VARCHAR2 IN

      PROCEDURE SEEDRANDOM

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      SEED BINARY_INTEGER IN

      PROCEDURE SIGN

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      SIGNATURE RAW OUT

      SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

      FUNCTION SIGN RETURNS RAW

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE SIGN

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT_STRING VARCHAR2 IN

      SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE SIGNDETACHED

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      SIGNATURE RAW OUT

      SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

      FUNCTION SIGNDETACHED RETURNS RAW

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT RAW IN

      SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE SIGNDETACHED

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      INPUT_STRING VARCHAR2 IN

      SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

      PROCEDURE STOREPERSONA

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN/OUT

      PERSONA RAW(200) IN/OUT

      WALLET RECORD IN/OUT

      WALLET RAW(200) IN/OUT

      PROCEDURE STOREPERSONA

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN/OUT

      PERSONA RAW(200) IN/OUT

      PROCEDURE STORETRUSTEDIDENTITY

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      IDENTITY RECORD IN/OUT

      DESCRIPTOR RAW(200) IN/OUT

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      PROCEDURE TERMINATE

      FUNCTION VALIDATE RETURNS BOOLEAN

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      PERSONA RECORD IN

      PERSONA RAW(200) IN

      IDENTITY RECORD IN

      DESCRIPTOR RAW(200) IN

      PROCEDURE VERIFY

      參數(shù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

      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ù)名稱 類型 輸入/輸出默認值?

      ------------------------------ ----------------------- ------ --------

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

    543047