Oracle

I thought it was simple, and I found some pits.1. Installing Cx_oraclePip Install Cx_oracle2. Download InstantclientThen unzip the oci.dll copy to the $python_home or $Python _home\lib\site-packages directory, note must be consistent version,

1 Install Oracle Client on Windows.2 Ensure that the 1521 ports on the Linux server are open.3 See your window machine is enough to ping the IP address of the Linux server 4 in the Oracle client's Tnsnames.ora in Windows add the Oracle (that is,

The dump function is used to determine whether a character type in a string belongs to number or stringStored ProceduresCreate or Replace procedurePro_isnum (i_stringinch varchar2, O_note outvarchar2) asstring1varchar2( +);--after the field is

--Delete PartitionALTER TABLE tt_trms_all_air_task DROP PARTITION tt_trms_all_air_task_p20171030;1. Add a partitionALTER TABLE Tt_trms_all_air_taskADD PARTITION tt_trms_all_air_task_p20171031 VALUES less THAN (TIMESTAMP ' 2017-10-31 00:00:00

1. Basic dataSELECT * from Table_muen TID CODE NAME Parentcode0 first-sbzhyw Social Security integrated ROOT1 Second-sbzhyw-zzyw self-service first-sbzhyw2 Third-sbzhyw-ywcxydy business Query and print Second-sbzhyw-zzyw3 Four-sbzhyw-grcbzmdy

Numeric functions:1.round: Returns the value after roundingRound (number, parameter) parameter does not write default to 0The following parameter specifies the precision of the return value, or the start of rounding from the beginning of the decimal

Prepare two devices, take my example a source ip:192.168.3.66 and a duplicate ip:192.168.3.771 "Copy the database based on the backup set, the directory structure is the same (Active database network)1. Check the duplicate to see if there are any

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is

Conversion Functionsstring , values and dates can be converted between three types of data . No. Name of function Meaning 1 String To_char ( column | date, format ) Convert a date or number to a

YUM Script#!/bin/bashrm -rf/etc/yumrepos.d/*echo "[yum]name=yumbaseurl=file:/// Mnt/enabled=1gpgcheck=0 ">/etc/yum.repos.d/yum.repomount/dev/cdrom/mnt &>/dev/nullyum clean Allyum MakecacheOracle Script#!/bin/bash# Configure

1 Writing Backup scripts1echo Backup Oracle Database ...2Echo%~dp03Set File_dir=%~dp04 5Echo Backup time ...6Set "year=%date:~0,4%"7Set "month=%date:~5,2%"8Set "day=%date:~8,2%"9Set "hour_ten=%time:~0,1%"TenSet "hour_one=%time:~1,1%" OneSet "minute=%

Oracle Functions Sys_connect_by_path DetailedGrammar:Oracle functions: Sys_connect_by_path is primarily used for tree queries (hierarchical queries) and multi-column career change. The syntax is generally:Select ... sys_connect_by_path (column_name,

1.create user username identified by password;//username and password Oracle, Oracle2.grant CONNECT,RESOURCE,DBA to username;//authorized Grant CONNECT,RESOURCE,DBA,SYSDBA to username;3.connect username/password//entry.4.select

After each database upgrade, the objects in the library need to be recompiled. Here's a script that can be compiled in batches to compile these defunct objects in a single execution. It is important to note that because of the permissions problem,

How to modify the field order in an Oracle database table Preface Some time ago, someone asked me a question about the order adjustment of table fields in Oracle. The problem is that after the table structure is designed, if you need to add a field

Oracle replication database, oracle Database Prepare two devices, for example, one source ip Address: 192.168.3.66 and one duplicate ip Address: 192.168.3.77. 1. Copy the database based on the backup set, and the directory structure is the same

Solve the Oracle string Sorting Problem that contains numbers and special symbols. Problem description: A residential area needs to be sorted by the residential area, building, unit number, and room number. However, when sorted by the address

[20171120] 11g select for update skip locked.txt, 20171120locked.txt [20171120] 11g select for update skip locked.txt-- // 11g when the select for update encounters a blocking, you can skip the blocking record through skipped locked. Let's test the

Oracle 12c implements manual database creation instead of CDB and CDB creation. Preface I believe everyone knows that for Oracle DATABASE creation, apart from dbca (GUI interface), Oracle also supports manual DATABASE creation, that is, using the

Regular Oracle listening log cleaning, oracle listening log Environment: Oracle 11.2.0 Win Server 2008 R2 Enterprise Cause: when the size of the Oracle listening log file exceeds 4 GB, the oracle listening connection is interrupted. Solution: