Oracle

When a user wants to access data in another database table across a local database, the local database must have a dblink of the remote database, and the Dblink local database can access the data in the Remote database table as if it were accessing

First, IntroductionThe importance of Oracle databases in system operations is self-evident, and the knowledge of operating systems and databases is deepened through familiarity with the installation of Oracle. The environment for this installation

1. Configure a minimum of 2 data Group (datagroup), the Fra datagroup as the flash back Zone side archive, backup, etc.) mainly consider the IO performance problem2. Oracle Official documentation recommends a minimum of 4 disks per DG and the same

Original: Oracle non-digital to digital type In Oracle, if the content of a field is not fully digital, it can be filtered in the following wayTo_number (substr (Translate (a.vital_signs_cvalues,'9876543210.' ||A.vital_signs_cvalues,'9876543210.'),

View system Current time HH24 24-hour MI is the right minuteSelect To_char (sysdate, ' Yyyy-mm-dd HH24:MI:SS ') from dualHH non-MM case-insensitive date mm system is considered a monthSelect To_char (sysdate, ' Yyyy-mm-dd HH:MM:SS ') from

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 (

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

ORA-01591: lockheldbyin-doubtdistributedtransaction troubleshooting Oracle errors occurred when running the batch data program yesterday: $ Tail-f INDB_ERROR_8.LOG[Time] 2014-12-01 04: 10: 31: activeAccountDeposit in oracle error: = ORA-01591: lock

The data in the oracle column contains multiple mobile phone numbers separated by commas. How can I separate them ?, Oracle Column ID NUMBER1 137 xxxx, 138 xxxxExtractedID NUMBER1 137 xxxx1 138 xxxx create  table  test (id  int , phone varchar2(200))

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