Oracle

[Oracle] cross-database query method: database link and transparent gateway 1. How to Create a dblink when oracle database A accesses another oracle database B1: create public database link dblink connect to totalplant identified by totalplant using

In Oracle, The GOTO statement does not have the continue keyword in Oracle. You can use the goto statement in the loop to achieve the same effect. [SQL] create or replace procedure dd is I pls_integer; begin I: = 0; loop I: = I + 1; if I> 10 then

Debian7 install oracle11g 1, installation must package apt-get install gcc g ++ make binutils libc6 libc6-dev libstdc ++ 6 libstdc ++ 5 rpm gawk alien ksh lesstif2 libaio1 linux-headers elfutils libaio-dev sysstat unixodbc-bin unixodbc -dev pdksh,

Create a new user simple edition for the database in Suse Linux. first, you need the root permission to log on to the database, sqlplus sys/sys @ oracle_ip 2. create user username identified by password. now, log out of the root user and use sqlplus

Rman crosscheck command details in the use of delete obsolete command to DELETE the OBSOLETE backup file, if the following error occurs (RMAN-06207 & RMAN-06208), then you need to use the CROSSCHECK command to solve: RMAN-06207: WARNING: 2 objects

Concept of hierarchical query in Oracle syntax format: select [level], column, expr... from table [where condition] start with condition connect by [prior column1 = column2 | column1 = prior column2]; hierarchical queries are identified by the start

After creating a database, you also need to create a listener by yourself. There are many ways to create a listener, as follows: 1. graphical interface: 1.1 netca is a simple graphical interface. It is recommended that you use it for beginners. The

Select the nth big/small value from the row in the table. The software environment Windows Server 2008 R2Oracle 11g Release 1 (11.1) Oracle SCOTT user uses SCOTT's EMP table in this article. The content is as follows: SQL> select empno, ename, sal 2

Data sharing among multiple oracle databases-database link dblink is the database access to the database and can be used for Distributed Processing (Distributed Processing: in a transaction, processing data in multiple databases at the same time and

Oracle Study Notes (3) filter grouping results select from where group by having order by -- for group function filtering, use having select deptno, avg (sal) from emp group by deptno having avg (sal)> 2000; where-> group by-> having select deptno,

Oracle: Let PL/SQL Developer remember the login password and save the password locally, which certainly brings security risks. However, when you maintain more than 10 databases, if PL/SQL Developer is not allowed to help you remember that every time

Oracle record declaration method Oracle record Declaration has only three methods: 1. the table-based record type Java code student_record student % rowtype. student is a table. After the student_record is declared, the structure is consistent with

Oracle alter table, add column, delete column, modify column 1. add alter table table_name ADD (column datatype [default expr] [, column datatype...]); for example: SQL> ALTER TABLE emp01 ADD eno NUMBER (4); 2. MODIFY the column definition, for

Oracle Import and Export exp, imp command Database Export 1. Export the database completely exp username/password @ test file = d:/xxx. dmp full = y2. export only the user's table exp username/password @ test file = d:/export. dmp owner = (xxx, xxx)

EBS Database Pre-clone log ora02 @ [/u07/CCTEST02/db/tech_st/11.1.0/appsutil/scripts/CCTEST02_test01] $ T02_test01/logs export _jdbc_url = 'null' Trying to get connection using SID based connect descriptorgetConnection () --> sDbHost: test01

OracleDBConsoleorcl cannot be started to solve this error because your ip address is dynamically obtained. When you install Oracle, your ip address is recorded by a network-connected system, the ip address used in some configuration information.

An Issue of Duplicate Database: edit the initSID when creating the Duplicate Database. the ora file finds that the values of db_file_name_convert are sequential. First write the correspondence between subdirectories and then write the correspondence

Oracle developers analyze SQL Execution plans with complicated and complex focus. They may be confused by the developers' eyes and cause a sexy and silly SQL statement to run on the server, focus on a few parts, as for others, of course, don't you

Use SQLNET. EXPIRE_TIME: after the client connected to the database is abnormally disconnected, the occupied client is not released. As shown in the v $ session view, the corresponding session is still inactive, the corresponding server process has

V $ session permission: Use v _ $ session in the oracle trigger to discuss the problem that a problem occurs when the v $ session record type is referenced when a trigger is created under a non-system user: "tables and views do not exist", but in pl/