oracle view table field data type and stored procedure statement

2011-04-21  来源:本站原创  分类:Database  人气:93 

select column_name as field name, data_type as data types, DATA_LENGTH as the data length from user_tab_columns where table_name = 'CON_AUDITBOOKINFO' and column_name in ('BOOKNAME', 'PENNAME')

View stored procedure text:
select text from all_source where OWNER = 'USERNAME'
and TYPE = 'PROCEDURE' and NAME = 'PROCNAME'

相关文章
  • oracle view table field data type and stored procedure statement 2011-04-21

    select column_name as field name, data_type as data types, DATA_LENGTH as the data length from user_tab_columns where table_name = 'CON_AUDITBOOKINFO' and column_name in ('BOOKNAME', 'PENNAME') View stored procedure text: select text from all_source

  • SQL-SERVER2000 field data type abbreviations 2010-11-18

    Table 1: SQL-SERVER2000 field data type abbreviation table field data type abbreviation meaning sql_variant sv values of different data types stored Numeric integer int integer value, with 4 bytes to store bigint bint integer value, with 8 bytes to s

  • Oracle View Table Constraints 2010-10-08

    1, we can create object "USER_" view open view. If the pattern table 10 is created, then the query will return from the USER_TABLES 10 rows, each row is the information on the characteristics of a table USER_TABLES can not view the non-current u

  • Oracle and SQL Server Data Type Mapping 2011-08-15

    2.2 Data Types This chapter provides detailed descriptions of the differences in data types used by Microsoft SQL Server and Oracle databases. Specifically, this chapter contains the following information: A table showing the base Microsoft SQL Serve

  • SYBASE ASE repair identity field data type jump (translation) 2011-04-21

    SYBASE ASE repair identity field data type jump (translation) Summary 1 Introduction 2, dbcc object_atts 3, download 'sp_identity' stored procedure 4, using sp_identity display type field of the table using the identity Table 5 shows the current use

  • Oracle view table space usage 2011-02-25

    Keywords: Oracle view table space usage Note: The following is a generic SQL statement (without any modification) How to use: After landing a database instance, directly copy the following SQL statement and run it. Sign in specific database: sqlplus

  • 1 query table field of type XML in the xml tag for the attribute values 2011-08-26

    ============== 1. Query table field of type XML in the xml tag for the attribute value === <ArgXML Type="Trans"> <attribute name="type" value="pdf" description="" extend="" /> <attribute nam

  • Array two-dimensional array. And the type of stored procedure call 2011-06-03

    Oracle components: -------------------------------------- create table parent( id number(10), name varchar2(100), title varchar2(10) ); create table child( id number(10), parent_id number(10), child_name varchar2(100), child_title varchar2(10), child

  • The database initialization data into a stored procedure INSERT statement 2010-11-15

    - Initialize the database data into a stored procedure INSERT statement create proc spGenInsertSQL @ TableName as varchar (100) as - Declare @ TableName varchar (100) - Set @ TableName = 'orders' - Set @ TableName = 'eeducation' DECLARE xCursor CURSO

  • How to handle the data table field of type Date? 2010-10-05

    How to keep a date data type, such as sql database, the corresponding field type is date The date of the database to java.sql.Date; order to a calendar or java.uitl.Date stored in the database, Can calendar or java.uitl.Date into java.sql.Date. java.

  • MySQL field data type / length 2011-03-09

    1, the value type Column type storage needs TINYINT 1 byte SMALLINT 2 bytes MEDIUMINT 3 bytes INT 4 bytes INTEGER 4 bytes BIGINT 8 bytes FLOAT (X) 4 if X <= 24 or 8 if 25 <= X <= 53 FLOAT 4 bytes DOUBLE 8 bytes DOUBLE PRECISION 8 bytes REAL 8 byt

  • Access to oracle database table. Field. Constraint information 2010-08-20

    - Access to the database table information select * from dba_tables; select * from all_tables; select * from user_tables; - Access to the database table field information select * from dba_tab_columns; select * from all_tab_columns; select * from use

  • Oracle and SQL Server data type comparison 2010-05-13

    Oracle SQL Server data type data type back- BFILE VARBINARY (MAX) is BLOB VARBINARY (MAX) is CHAR ([1-2000]) CHAR ([1-2000]) is CLOB VARCHAR (MAX) is DATE DATETIME is FLOAT FLOAT No FLOAT ([1-53]) FLOAT ([1-53]) has FLOAT ([54-126]) FLOAT No INT NUME

  • Query table field. Comment. Type 2010-12-06

    -- Note the query the table field. . Type select B.name,C.value,D.name from sysobjects AS A inner join syscolumns as B on A.id=B.id inner join sysproperties as c on B.id=C.id and B.colid=C.smallid inner join systypes D on B.xtype = D.xtype where a.na

  • oracle - Remove table field notes 2010-09-08

    Through access to Oracle database table name and comments select a.TABLE_NAME,TABLESPACE_NAME ,b.TABLE_TYPE,B.COMMENTS from user_tables a,user_tab_comments b WHERE A.TABLE_NAME=B.TABLE_NAME order by TABLE_NAME Oracle database access through a view na

  • oracle ---- ----- nested table object-oriented data tables and variable arrays (about) 2010-09-30

    Nested Table ( Oracle unique technology to understand , Development does not use ) Also contains a table in another sub-table Such as : A department may undertake projects I usually set up two tables, one is the department One of the project , The or

  • Query table field. Notes. Type 2010-12-06

    -- Query table fields. comments . Type select B.name,C.value,D.name from sysobjects AS A inner join syscolumns as B on A.id=B.id inner join sysproperties as c on B.id=C.id and B.colid=C.smallid inner join systypes D on B.xtype = D.xtype where a.name=

  • oracle recover accidentally deleted data, unlock the other sql statement 2011-05-13

    Note: The database version is 10g, but also applies to most 9i, 9i there is no flashback. 1 have not developed accidentally deleted all the library's database tables was scared to death. The results found the following statement to one hour to restor

  • Asp.Net access to Oracle database implementation of SQL statements and stored procedure calls 2010-05-26

    Asp.Net simple example to access Oracle 1. Is a flexible set, will be connected characters written in the web.config file <appSettings> <add key="oracleconn" value="User"/> <add key="oracleconn" value="Use

  • Asp.Net access Oracle database implementation of SQL statements and stored procedure calls 2010-05-26

    Asp.Net simple example to access Oracle 1. Is a flexible set, will be connected characters written in the web.config file <appSettings> <add key="oracleconn" value="User"/> <add key="oracleconn" value="Use