六月丁香五月婷婷,丁香五月婷婷网,欧美激情网站,日本护士xxxx,禁止18岁天天操夜夜操,18岁禁止1000免费,国产福利无码一区色费

學(xué)習(xí)啦>學(xué)習(xí)英語>專業(yè)英語>計(jì)算機(jī)英語>

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

時(shí)間: 長思709 分享

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

  數(shù)據(jù)庫中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ù)庫中desc和ASC的排序區(qū)別

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

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

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

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

  desc是用來查看數(shù)據(jù)庫對象的一個(gè)命令.格式為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命令來啟動(dòng)或者停止MySQL數(shù)據(jù)庫

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

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

5.計(jì)算機(jī)英語

543047