oracle get table columns

Data from the database in the work to export, but found that the exported Excel column names are field names (in English), to collect data on how to change the field name to Chinese names, and found that Oracle and SQL Server (SQLSERVER2008R2) is

Oracle CBO RBO Detailed url:http://blog.163.com/love-love-l/blog/static/21078304201010175035270/ Http://blog.csdn.net/cnham/archive/2010/04/13/5482318.aspx First part What is Table analysis. Simply put, it is the information that collects tables

Temporary tables: Like normal tables, there is a structure, but the management of the data is not the same, the temporary table stores the transaction or the intermediate result set of the session, the data saved in the temporary table is only

Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most

In fact, when creating an object in the database, the Administrator must also name it. Some experienced database administrators will also be careful when naming them. It must be loud and representative of specific application scenarios. Sometimes

Management of 1.Oracle Tables Naming conventions for table and column names: Must start with a letter; Length cannot exceed 30 characters; Cannot use Oracle's reserved words; Use only the following characters: A-Z, A-Z, 0-9,

A table generally refers to a relational table, and it can also generate object tables and temporary tables. Total, the object table is generated from a user-defined data type, and temporary tables are used to store temporary data that is dedicated

The ORACLE tutorial is: several methods to optimize the design of Oracle database tables. Preface Most Oracle Database performance problems are caused by unreasonable Database design. Only a small number of problems are rooted in the unreasonable

Learn how to prepare a database for Oracle GoldenGate, including how to configure connectivity and logging, how to enable Oracle GoldenGate in a database, how to set up a flashback query, and how to manage server resources. Configure the

Ext.: http://blog.itpub.net/17203031/viewspace-744477An important feature of relational database products (RDBMS) is that data information is organized into two-dimensional data tables, and the expression of information can be accomplished through a