Oracle

How to view the IP address of the database server in oracle 1. view the tns configuration under the local oracle installation directory. $ HOME/network/admin/tnsnames. ora. Find the database you want to access, such as PRIMARY = (DESCRIPTION =

Oracle 11g x64 Oracle SQL Developer error: Unable .. SQL developer is always difficult to learn about oracle over the past few days. This time, it is finally solved. oracle SQL Developer error: Unable to find a Java Virtual Machine 1. environment

Flow Control statements in PL/SQL and temporary Oracle tables [SQL] create global temporary table temp_dept (dno number, dname varchar2 (10) on commit delete rows; insert into temp_dept values (10, 'abc'); drop table temp_dept -- the temporary table

Use the script to create the scott mode. First, check my database version SQL> select * from v $ version; BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0

Create a synonym in Oracle create a synonym statement in Oracle: we all know that user management in oracle uses permission management, that is, if we want to use a database, we must have permissions, but if someone grants us the permissions, we can

The nested loop of Oracle table connection executes a query SQL statement in the database system. If this query only operates on one table, it only involves access to this table and associated objects. There are usually three access methods: full

The Truncate and Delete statements in Oracle are described first. The truncate command: www.2cto.com Syntax: truncate table; The data in the table is cleared, and the storage space is released. After the task is run, the task is automatically

The introduction of sqlplus and sqlplusw oracle is really difficult to cook in the database. It took a long time to install 11 GB, But it encountered the problem of unable to run sqlplusw: www.2cto.com found a lot of reincarnation on the Internet,

How to create an auto-incrementing primary key in Oracle 1. create a table and set the primary key. 2. create a sequence. 3. create trigger .www.2cto.com. For example: assume that the table name of the data table is tbl_name, the primary key column

Summary of the SQL language during Oracle Learning 1. query the structure of the dept table www.2cto.com in the Command window input: desc dept; 2. Retrieve all column information in the dept table select * from dept 3. Search for the employee name,

The protection level of Data Guard 10g is RESYNCHRONIZATION. After the data guard of Oracle is created, check the value of protection_mode and protection_level of v $ database. If the value of protection_mode is maximum availability, the value of

The difference between union and union all and the use of join 1. The difference between union and union all is www.2cto.com Union. union operations are performed on two result sets, excluding repeated rows, sort the default rules at the same time.

Temporary tablespace group (TTG) environment for Oracle temporary tables: www.2cto.com [SQL] sys @ ORCL> select * from v $ version; BANNER implements Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod PL/SQL Release 10.2.0.1.0-Production

In Linux, a raw device is used to create an oracle tablespace. Today, a test is performed to create a tablespace in linux: 1. create logical volume: run # lvcreate-L 100 M-n vg30 vg02. bind the logical volume to the bare device as the root user:

Insufficient use of Oracle tablespace and solutions 1. how to query table space: www.2cto.com select B. file_id, B. tablespace_name, B. file_name, B. bytes, (B. bytes-sum (nvl (. bytes, 0), sum (nvl (. bytes, 0), sum (nvl (. bytes, 0)/(B. bytes) * 10

Oracle 10g obtains the result set of merging values in column B based on the same value in column a. oracle 10g obtains the same value according to Column, obtains the result set that combines values in column B. (Make a and B form a parent-child

Oracle Real-Time query resource consumption SQL 1. first, use the top command to view the pid Number with more resources in production. Note: For the oacle of the top Command user, follow the pid www.2cto.com 2. query the current time-consuming

Oracle creates a trigger to insert a stored procedure into the memory to improve computing efficiency. Create the Stored Procedure SQL> @... \ dbmspool. SQL check whether the package has created SQL> desc dbms_shared_pool www.2cto.com create trigger

When SQL Server is used, an auto-increment field is added and set as the primary key to avoid repeated records. Now let go of the advantages and disadvantages of doing so. Let alone implementation problems. When Oracle is used, this situation occurs.

Custom sqlplus sqlprompt after logon creates a login under any directory. SQL example: www.2cto.com E: \ oracle-study input content: define _ editor = sublime_textset serveroutput on size 1000000 set trimspool onset long 5000 set linesize 100 set