当前位置

首页 > 商务英语 > 计算机英语 > 数据库desc的用法有哪些用法

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

推荐人: 来源: 阅读: 1.31W 次

计算机程序的PEnhen.com/tags-447-0.html" target="_blank" >学习比较复杂,那么数据库desc的用法的用法你知道吗?下面本站小编就跟你们详细介绍下数据库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.计算机英语