Oracle

Steps1 Installing Oracle 11gOracle official website Download Orcale 11g, "Now still do not use 10g, anyway I did not use" 2 Installing Microsoft Visual studio2012 Expressmicrosoft visual studio2013the use of the installation did not succeed, but it

How to use%type and%rowtype in Oracle PL/SQL1. Using%typeIn many cases, a PL/SQL variable can be used to store data in a database table. In this case, the variable should have the same type as the table column. For example, the first_name column of

Command meaning/Run SQL Buffer? [keywords] provide SQL help for keywords@[@] [file name] [parameter list] Run the specified command file with the specified parametersACC[EPT] variable [def[ault] value] [PROMPT text | Nopr[ompt]] Allows the user to

Select table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect table_name from dba_tables where owner= ' user name

Data integrity Classification1. Domain IntegrityDomain integrity, also known as column integrity, specifies whether a dataset is valid for a column and determines whether null values are allowed.2. Entity integrityEntity integrity can also be called

The premise is that the machine already has Oracle installed, using NET Configuration assistant.If the machine does not have Oracle installed, do not need to install the Oracle method please point meOpen NET Configuration assistant, select the Local

Oracle remote connection is not directly using the IP plus port form, but using TNS (Personal feeling and ODBC DSN a bit similar, somewhere to save some settings, and then give these settings a name, when used to directly write the name on the

First, export/import (Export/import)----Use export to extract data from the database and import the extracted data back to the Oracle database. ----1. Simple Export data (exports) and imported data (import)----Oracle supports three types of output:--

First, Oracle common system functions1. Date class function(1) to_date (string, format)Sql> Select To_date (' 2014-10-11 12:13:14 ', ' yyyy-mm-dd hh:mi:ss ') from dual; To_date (' 2014-10-1112:13:14 ', '------------------------------2014-10-11 12:13:

First, dynamic monitoringAn Oracle listener is a stand-alone process that typically starts before a DB instance is started, and dynamically registers its service_names and instance_name with the listener program when the Oracle instance is open.

Remember once Oracle Clusterware installation failure handling1. Environmentcat /etc/5.8 (tikanga) Kernel \ r on an \m2. Description of the problem during the installation of the RAC, the nodes were shut down after successfully installing the grid (

Just made a simple test.TimesTen 11g and Oracle 11.2.0.4 are installed on the same physical machine with two hardware environmentsCreate a table on both sides of the databaseCREATE TABLE Test (a number,b varchar2 (20));CommitAnd then insert the

Reproduced below from: http://blog.itpub.net/29324876/viewspace-1096741/There are both explicit type conversions (EXPLICIT) and implicit type conversions (implicit) for different types of processing in Oracle, we are controllable for explicit type

Data export:1 The database test is fully exported, user Name System Password Manager exported to D:\daochu.dmp exp System/[email protected] file=d:\daochu.dmp full=y 2 will be in the database sys TEM User and SYS user table export exp system/[email

SQL statements that are paged and sorted by RowNum in Oracle are used to using such SQL statements before paging:Select * from (SelectT.*, RowNum row_num fromMyTable TOrder byt.id) bwhereB.row_numbetween 1 and Tenit turns out that because the

CREATE OR REPLACE PROCEDURE P_query_cs (P_infotype in VARCHAR2,P_fromareacode in VARCHAR2,P_toareacode in VARCHAR2,P_keytype in number,R_cursor1 out Sys_refcursor,--Result setR_cursor2 out Sys_refcursor--Result set)IsBEGINOPEN R_cursor1 forSELECT *

Oracle's own Dbms_redefinition package is very powerful and can be used to reduce high watermark, reclaim debris space, make online redefinition of tables (Add or Remove fields, change field types, normal table redefine table as partition table,

OracleFGA fine-grained Audit If you want to audit the table, it is a good choice to use FGA for a certain period of time, persons and DML statements. SQL> select * from v $ version;Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit

Generation Process of new part encoding and generation process of part Encoding1. Background 1.1 region-level code In the system, we divide the region-level codes into: district, street, community, and cell ). The numbers they correspond to

Oracle Index instance description-Basics Oracle Index instance description-Basics Index is an object used in relational databases to store each record location in a table. It aims to speed up Data Reading and data integrity check. Indexing is a