Oracle

First, download tool: Open http://www.anysql.net/on its right to find SQLULDR2, then click: Second, the download after decompression, there are various corresponding versions, we choose linux64 bit: Third, put it in the Linux directory you want to

1. Simple VariablesDECLARE v_cnt number (10,0): = 0; BEGIN SELECT COUNT (1) into v_cnt from concept.  decoction WHERE Decoctionid =-1; IF v_cnt = 0 Then insert INTO concept. Decoction (Decoctionid, Code, Name, Mnemoniccode, Spellcode, Wbcode,

It turns out that it's not going to die without dying, this time the oracle crashed and it took me two days to unload it just because I installed some inexplicable Android simulator.After uninstalling, found that the Oracle database can not be used,

How to get a database connection: 1. Driver Interface: ? The Java.sql.Driver interface is the interface that all JDBC drivers need to implement. This interface is provided to the database vendors, different database vendors to provide different

Deep understanding of Oracle RAC 12cJump to: Navigation, search Directory 1 Overview 2 Cluster parts management and fault diagnosis 3 Operational Practices 4 new Features 5 Storage and ASM 6

Examples of using Oracle official documentation (11G)The following is the official Oracle document interface, want to learn Oracle, read official documents is the only way, this article to give beginners a general understanding of the use of

As a loyal user of the command line, server-side software operations tend to use commands or scripts to complete, very annoying resources occupy a large GUI. The Oracle database is an important server-side software, and its installation operations

July 8, 2014, I regained Oracle, the computer was previously installed Oracle10, because to import the 11 version of the DMP table file, it is suggested that the version of the low Oracle can not import, only the version of the Oracle import version

In the database design of this piece, many times the table data model is a typical two-fork tree structure.So when querying the data, it involves the recursive query of the data. There are two types of recursive queries: 1. Query itself and all

Dblink detailed 1. Create the Dblink syntax: CREATE [public] DATABASE link link CONNECT to username identified by password USING ' ConnectString ' Description 1) Permissions: The account that created the database link must have the system

When installing 12.1.0.2 32bit Oracle Database Client under Windows R2 64bit, the client crash out without any error messagesReference from:12.1.0.2 32bit Oracle Database Client installation on Windows R2 64bit crashes without any Error Messages

Open EBS form, system error, Chinese message is: frm-92095:oracle jinitiator version is too old, please install version 1.1.8.2 or later, if the English environment, will be error: frm-92095:oracle Jinitiator version too low. Please install version 1

When setting the environment variable, accidentally delete the path of the Oracle environment variable. When setting ODBC, add the DSN data source and the prompt "unable to load the oracle in oradb10g_home2 ODBC driverProgramBecause of system errors.

Oracle trim, ltrim, rtrim function usageThis function has two functions:First, remove spaces that everyone is familiar.Example:-- Trim removes leading and trailing spaces of a specified characterSQL> select trim ('dd df') from dual;Trim ('dddf ')----

1. What is a cursor?① Retrieve the result set from the table and point to a record for interaction at a time.② Operations in relational databases are performed on the complete set of rows.The row set returned by the SELECT statement includes all

Oracle optimizer and SQL query execution sequence before Oracle executes an SQL statement, it first needs to check the SQL Execution Plan and then execute the SQL statement according to the execution plan, the optimizer executes the analysis of

Oracle CREATE user ORA-01045: user lacks create session privilege; logon denied .. conn internal/oraclegrant user aaaa identified by aaaa; conn aaaa/aaaa will report ERROR: SQL> conn aaaa/aaaa will report ERROR: ORA-01045: user aaaa lacks CREATE

Oracle Database Programming: PL/SQL programming basics Oracle Database Programming: basic concepts of Oracle databases http://www.bkjia.com/database/201307/226254.html 2. PL/SQL programming basics: PL/SQL block: declare defines part of the exception

DBA Note: a dba diagnostic tool-Event 10046 and 10053 friend from an optimization tool manufacturer sent a case request to assist in diagnosis, it is unacceptable that a friend's optimization tool can produce results in 10 minutes when executing an

The following is an example of using Excel VBA to connect to Oracle and operate Oracle-related data.To connect to the database through VBA, Excel needs to install the corresponding Oracle client tool and reference the relevant components of ADO. to