Oracle

Today is 2014.05.26, parting N continues to use the long-present blog. The deal has been busy. Recently, this article plus the home network has not paid dues, I began to become less secure. Learning is a need to calm emotions, the voice of the heart

Dblink used in the database is more, simple and convenient. However, with the enhancement of Oracle security, normal user login can only be seen, user name and connection string. So how does the dblink password look?Very simple, requires SYS account

In general, for a table with a primary key that can do a unique table, we can use the primary key and rownum mates to implement, for example:select scott.emp.* from scott.emp left join (select empno id, rownum num from scott.emp) id_num

1. The origin of the problemWhen the Oracle database field value is less than 1 decimals, processing with char type loses 0 of the preceding decimal pointFor example, 0.2 becomes. 22. Workaround: (1) format the digital display with the TO_CHAR

1.oracle Dictionary Table Query /* Show Current User */show users available in SQL Plus, unavailable in PL SQL/* View all user names */select username,user_id,created from all_users;/* View user details for the current user */ Select

C # Calling stored proceduresRefer to a lot of articles, write the following text, is to share itPurpose: To change the points and make certain verificationGeneral Debugging methods:DECLAREMyresult INT;BEGINP_changevipbalance (' 018604712233 ', -1, '

OneWin7 cmd run sqlplus error following errors:SP2-1503无法初始化Oracle 调用界面SP2-1503无法初始化Oracle 调SP2-0152Workaround:in Oracle\product\10.2.0\db_2\bin directory to find the Sqlplus.exe, right-click---Properties---compatibility--- Choose the with XP Run

Constraint: Used to maintain data integrity and prevent invalid data from entering the database.The 5 constraints provided in the Oracle database are defined as a combination of a column or a column.1. PRIMARY KEY constraint (PRIMARY key): A single

One set to archive mode[XHTML]View Plaincopyprint? 1 SQL> Archive log list; #查看是不是归档方式 2 SQL> alter system set log_archive_start=true scope=spfile; #启用主动归档 SQL> Alter system set log_archive_dest=' location=/oracle/ora9/oradata/arch '

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. PL/SQL is also a programming language called the procedural SQL language (procedural language/sql), which is an extension of

drop table and purge   in oracle  database actual example:  create OR REPLACE PROCEDURE pro_droptable is   Cursor cur is     SELECT table_name from user_tables where table_name like ' temptable% ';   drop_s QL     VARCHAR2 (;   table_number

EMP Employee TableWhether the field name data type is empty remarks--------   -----------   --------   -------- EMPNO Number (4) Employee IDEname VARCHAR2 (Ten) Y employee nameJob VARCHAR2 (9) Y JobMGR Number (4) Y of the SuperiorHireDate Date Y

Importing Oracle backup data to other tablespaces (only setting the default tablespace is invalid) When importing an Oracle backup data file (*. dmp) to another database user, you can use the following methods to replace the tablespace. Assume that

Oracle update, order by, oracleorder Today, I encountered a problem about converting SQL statements into Oracle statements, which is described as follows: Select * from emp orderby deptno; Select * from dept; SQL Server: Update dept a set

Oracle table organization and Data Replication 1. Copy the table structure and data to generate a new table: Create table table_name_new as select * from table_name_old; 2. copy only the table structure: Create table table_name_new as select *

Oracledatabasewrc execute an error ORA-15557 [Oracle @ host capture] $ wrc system/oracle @ db1 REPLAYDIR =/home/oracle/cap_dir/Workload Replay Client: Release 11.1.0.7.0-Production on Sun Jul 19 17:16:56 2015 Copyright (c) 1982,200 7, Oracle. all

Listparts and oraclelistagg of Oracle Functions Recently, I found a very interesting function in the learning process, which can splice column values. Next, let's take a look at its specific usage. Usage: The official document explains its role as

When the specified asmdisk is FRA, The dbuahang of 11.2.0.3 is When the asm disk is specified as FRA, The dbua hang of 11.2.0.3 stays Source:11.2.0.3 DBUA Hangs While Specifying ASM Disk To FRA (Document ID 1427179.1) Applicable:Oracle Database

Oracle11gR2 installation tutorial 1. Note that Oracle is divided into two files. After downloading, extract the two files to the same directory.In the path name, it is best not to show Chinese characters or irregular characters such as spaces. 2.

Small ora-29250 case after modifying spfile in rac Environment Environment: Operating System: CENTOS6.4 64BIT Database: rac oracle 11.2.0.3 64BIT   An error occurs after the database is started. The filesystemio_options parameter has been modified