学习啦>学习英语>专业英语>计算机英语>

数据库desc的用法有哪些用法

时间: 长思709 分享

  计算机程序的学习比较复杂,那么数据库desc的用法的用法你知道吗?下面学习啦小编就跟你们详细介绍下数据库desc的用法的用法,希望对你们有用。

  数据库中desc的用法

  1)desc就是用于查询出结果时候对结果进行排序,是降序排序,而asc就是升序。。要用与order by一起用。

  2)例如select * from student order by id desc; 就是把选出的结果经过“按id从大到小排序”后,把资源返回。

  3)还可以select * from student order by age desc,id desc;用“,”号隔开多个排序条件,这样,先按age 再按 id,就是说,先按age从大到小排序,如果有相同年龄的,那么相同年龄的学生再按他们的id从大到小排序。

  数据库中desc和ASC的排序区别

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

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

  数据库desc的用法的用法示例

  使用desc查看数据库对象

  desc是用来查看数据库对象的一个命令.格式为desc+对象名

  SQL> desc course;

  名称 是否为空? 类型

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

  COURSEID NOT NULL VARCHAR2(32)

  COURSENAME NOT NULL VARCHAR2(64)

  COURSENAME_EN VARCHAR2(256)

  COURSENO NOT NULL VARCHAR2(32)

  DEPARTMENTID VARCHAR2(32)

  STAFFROOMID NOT NULL VARCHAR2(32)

  COURSEKINDCODE NOT NULL VARCHAR2(8)

  ISOTHERLANG CHAR(2)

  TOTALPERIODNUM NOT NULL NUMBER(3)

  TEACHPERIODNUM NUMBER

  TESTPERIODNUM NUMBER

  EXERPERIODNUM NUMBER

  CREDITHOURNUM NUMBER

  TEACHMETHODCODE CHAR(2)

  REFBOOKNAME CHAR(1)

  PRECOURSENAME CHAR(1)

  EXAMMETHODCODE CHAR(2)

  BRIEF CHAR(1)

  STATUS NOT NULL VARCHAR2(10)

  COMMENTS CHAR(1)

  REEXAM CHAR(1)

  LABEL CHAR(1)

  PASSSCORE NUMBER

  FULLSCORE NUMBER

  TEXTBOOK CHAR(1)

  SHORTNAME NOT NULL VARCHAR2(8)

  SQL> desc dbms_crypto_toolkit;

  PROCEDURE ABORTIDENTITY

  参数名称 类型 输入/输出默认值?

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

  IDENTITY RECORD IN/OUT

  DESCRIPTOR RAW(200) IN/OUT

  PROCEDURE CLOSEPERSONA

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN/OUT

  PERSONA RAW(200) IN/OUT

  PROCEDURE CLOSEWALLET

  参数名称 类型 输入/输出默认值?

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

  WALLET RECORD IN/OUT

  WALLET RAW(200) IN/OUT

  PROCEDURE CLOSEWALLET

  PROCEDURE CREATEIDENTITY

  参数名称 类型 输入/输出默认值?

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

  IDENTITYTYPE BINARY_INTEGER IN

  PUBLIC_IDENTITY VARCHAR2 IN

  ALIAS VARCHAR2 IN

  LONGER_DESCRIPTION VARCHAR2 IN

  TRUST_QUALIFIER VARCHAR2 IN

  IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  PROCEDURE CREATEPERSONA

  参数名称 类型 输入/输出默认值?

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

  CIPHER_TYPE BINARY_INTEGER IN

  PRIVATE_INFORMATION RECORD IN

  INFORMATION RAW(200) IN

  PRL VARCHAR2 IN

  ALIAS VARCHAR2 IN

  LONGER_DESCRIPTION VARCHAR2 IN

  PERSONA RECORD OUT

  PERSONA RAW(200) OUT

  PROCEDURE CREATEWALLET

  参数名称 类型 输入/输出默认值?

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

  PASSWORD VARCHAR2 IN

  WALLET RECORD IN/OUT

  WALLET RAW(200) IN/OUT

  WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

  PROCEDURE CREATEWALLET

  参数名称 类型 输入/输出默认值?

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

  PASSWORD VARCHAR2 IN

  WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

  PROCEDURE DECRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENCRYPTED_DATA RAW IN

  DECRYPTED_DATA RAW OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION DECRYPT RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENCRYPTED_DATA RAW IN

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE DECRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENCRYPTED_STRING VARCHAR2 IN

  DECRYPTED_STRING VARCHAR2 OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION DECRYPT RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENCRYPTED_STRING VARCHAR2 IN

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE DEENVELOPE

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENVELOPED_DATA RAW IN

  OUTPUT_DATA RAW OUT

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SENDER_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION DEENVELOPE RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENVELOPED_DATA RAW IN

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SENDER_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE DEENVELOPE

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENVELOPED_STRING VARCHAR2 IN

  OUTPUT_STRING VARCHAR2 OUT

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SENDER_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION DEENVELOPE RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  ENVELOPED_STRING VARCHAR2 IN

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SENDER_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE DESTROYWALLET

  参数名称 类型 输入/输出默认值?

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

  PASSWORD VARCHAR2 IN

  WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

  PROCEDURE ENCRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  ENCRYPTED_DATA RAW OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION ENCRYPT RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION ENCRYPT RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE ENVELOPE

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT RAW IN

  ENVELOPED_DATA RAW OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION ENVELOPE RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT RAW IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE ENVELOPE

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENVELOPED_STRING VARCHAR2 OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION ENVELOPE RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE ENVELOPE

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT RAW IN

  ENVELOPED_DATA RAW OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION ENVELOPE RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT RAW IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE ENVELOPE

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENVELOPED_STRING VARCHAR2 OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION ENVELOPE RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE HASH

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  HASH RAW OUT

  HASH_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION HASH RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  HASH_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE HASH

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  HASH RAW OUT

  HASH_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION HASH RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  HASH_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE INITIALIZE

  PROCEDURE KEYEDHASH

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  KEYED_HASH RAW OUT

  HASH_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION KEYEDHASH RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  HASH_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE KEYEDHASH

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  KEYED_HASH RAW OUT

  HASH_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION KEYEDHASH RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  HASH_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE OPENPERSONA

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN/OUT

  PERSONA RAW(200) IN/OUT

  PROCEDURE OPENWALLET

  参数名称 类型 输入/输出默认值?

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

  PASSWORD VARCHAR2 IN

  WALLET RECORD IN/OUT

  WALLET RAW(200) IN/OUT

  PERSONA_LIST TABLE OF RECORD OUT

  WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

  PROCEDURE OPENWALLET

  参数名称 类型 输入/输出默认值?

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

  PASSWORD VARCHAR2 IN

  PERSONA_LIST TABLE OF RECORD OUT

  WALLET_RESOURCE_LOCATOR VARCHAR2 IN DEFAULT

  PROCEDURE PKDECRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  DECRYPTED_DATA RAW OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION PKDECRYPT RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE PKDECRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  DECRYPTED_STRING VARCHAR2 OUT

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION PKDECRYPT RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  DECRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE PKENCRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT RAW IN

  ENCRYPTED_DATA RAW OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION PKENCRYPT RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT RAW IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE PKENCRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTED_STRING VARCHAR2 OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION PKENCRYPT RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RECIPIENT RECORD IN

  DESCRIPTOR RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE PKENCRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT RAW IN

  ENCRYPTED_DATA RAW OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION PKENCRYPT RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT RAW IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE PKENCRYPT

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTED_STRING VARCHAR2 OUT

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION PKENCRYPT RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_RECIPIENTS BINARY_INTEGER IN

  RECIPIENT_LIST RECORD IN

  DESCRIPTOR_ARRAY RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  ENCRYPTION_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE RANDOMBYTES

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN

  RANDOM_BYTES RAW OUT

  FUNCTION RANDOMBYTES RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  NUMBER_OF_BYTES_DESIRED BINARY_INTEGER IN

  PROCEDURE RANDOMNUMBER

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  RANDOM_NUMBER BINARY_INTEGER OUT

  FUNCTION RANDOMNUMBER RETURNS BINARY_INTEGER

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  PROCEDURE REMOVEIDENTITY

  参数名称 类型 输入/输出默认值?

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

  IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  PROCEDURE REMOVEPERSONA

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN/OUT

  PERSONA RAW(200) IN/OUT

  PROCEDURE SEEDRANDOM

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SEED RAW IN

  PROCEDURE SEEDRANDOM

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SEED VARCHAR2 IN

  PROCEDURE SEEDRANDOM

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SEED BINARY_INTEGER IN

  PROCEDURE SIGN

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  SIGNATURE RAW OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION SIGN RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE SIGN

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  SIGNATURE RAW OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION SIGN RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE SIGNDETACHED

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  SIGNATURE RAW OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION SIGNDETACHED RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT RAW IN

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE SIGNDETACHED

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  SIGNATURE RAW OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION SIGNDETACHED RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  INPUT_STRING VARCHAR2 IN

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE STOREPERSONA

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN/OUT

  PERSONA RAW(200) IN/OUT

  WALLET RECORD IN/OUT

  WALLET RAW(200) IN/OUT

  PROCEDURE STOREPERSONA

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN/OUT

  PERSONA RAW(200) IN/OUT

  PROCEDURE STORETRUSTEDIDENTITY

  参数名称 类型 输入/输出默认值?

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

  IDENTITY RECORD IN/OUT

  DESCRIPTOR RAW(200) IN/OUT

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  PROCEDURE TERMINATE

  FUNCTION VALIDATE RETURNS BOOLEAN

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  IDENTITY RECORD IN

  DESCRIPTOR RAW(200) IN

  PROCEDURE VERIFY

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SIGNATURE RAW IN

  EXTRACTED_MESSAGE RAW OUT

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SIGNING_PARTY_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION VERIFY RETURNS RAW

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SIGNATURE RAW IN

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SIGNING_PARTY_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE VERIFY

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SIGNATURE RAW IN

  EXTRACTED_MESSAGE_STRING VARCHAR2 OUT

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SIGNING_PARTY_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  FUNCTION VERIFY RETURNS VARCHAR2

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  SIGNATURE RAW IN

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SIGNING_PARTY_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE VERIFYDETACHED

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  DATA RAW IN

  SIGNATURE RAW IN

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SIGNING_PARTY_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT

  PROCEDURE VERIFYDETACHED

  参数名称 类型 输入/输出默认值?

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

  PERSONA RECORD IN

  PERSONA RAW(200) IN

  DATA_STRING VARCHAR2 IN

  SIGNATURE RAW IN

  VERIFIED BOOLEAN OUT

  VALIDATED BOOLEAN OUT

  SIGNING_PARTY_IDENTITY RECORD OUT

  DESCRIPTOR RAW(200) OUT

  SIGNATURE_STATE BINARY_INTEGER IN DEFAULT


猜你喜欢:

1.数据库中update的用法

2.如何使用DOS命令来启动或者停止MySQL数据库

3.数据库desc的用法

4.数据库between的用法

5.计算机英语

543047