Oracle

1. Download the installation package http://cx-oracle.sourceforge.net/based on the platform. 2. Install cx_Oracle-5.0-10g.win32-py2.6.msi in Windows 3. If a DLL loading failure error is reported, download the dig command. 4,Import cx_oracle #

1.Write Data   In usePDOIf you useBindparam ()Without specifying the Data Type of the field or usingExecute (),PDOThe default value isStringType, and a default length is limited. ThereforeClobType fields must be usedBindparam ()OrBindvalue

Log on to Oracle with sys SQL> conn sys/root as sysdba; Create Sequence SQL> Create sequence test_seq maxvalue 9 increment by 2 start with 1 cache 2 cycle; Create a test table SQL> Create Table test_table (next number, curr number );Insert

  1. log on with an oracle userIf you want to install it again, you 'd better back up the data first. The script includes the user's login script, the script for automatic database startup and shutdown, and the script for automatic

Original article:Http://www.eygle.com/archives/2007/02/oracle_ace_china.html On Wednesday evening, Jack Han from Oracle Guangzhou came to Beijing, where everyone had a small party at the carving time Lido store. The event was attended by

Control Panel-> Add hardware, select "Yes, connected to this hardware" in the Wizard → add new hardware devices → install me manually list select hardware (advanced) → network adapter → vendor: Microsoft NIC: Microsoft loopback Adapter. After the

#! /Bin/shExport ORACLE_HOME =/APP/Oracle/product/10.2.0/db_1;Export oracle_sid = orcl;Export nls_lang = "simplified chinese_china.utf8 ";Export F = $ (date + % Y % m % d % H % m % s); # Use the date plus time as the backup file nameBackupdir

1. problem origin when the Oracle database field value is smaller than 1 decimal point, the char type will be used for processing, and the 0 before the decimal point will be lost for example, 0.35 is changed. 35 2. solution: Use the to_char

  1. view the table space name and size. SelectT. tablespace_name, round (sum (Bytes/(1024*1024), 0) ts_sizeFromDba_tablespaces T, dba_data_files dWhereT. tablespace_name = D. tablespace_nameGroupT. tablespace_name;SQL>Tablespace_name ts_size----

First, set a user group for the normal installation of oracle; [Root @ localhost ~] # Groupadd oinstall[Root @ localhost ~] # Groupadd DBA A user account is called Oracle, and a group is called oinstall and DBA. [Root @ localhost ~] #

Link: http://www.eygle.com/archives/2010/12/fractured_controlfile_recovery.html   Recently, it helped users recover a database disaster caused by storage faults. The entire database capacity is 4 TB, and database faults are caused by damage to

In the difficult winter of data security, a series of topics sorted out before transcription. Link: http://www.eygle.com/blog/special/oracle_recovery.html Question: With the increasing importance of databases in enterprises, the business

  Oracle study note _ trigger Trigger The code block automatically executed when a specific event occurs. It is similar to a stored procedure, but users cannot directly call them. Function:1. Allow/restrict table modifications2. automatically

In Oracle, the comparison and analysis of the effects of not using indexes and using indexes is unnecessary. 1. Create a test database and then insert data in batches: SQL> Create Table studentinformation (ID number (20) not null primary key, name

Link: http://www.eygle.com/archives/2008/11/become_dba_quickly.html This is because more and more people have asked me this question recently. I want to write down my ideas. 1. How fast is it?Many people like shortcuts, so they often ask for

The Oracle database has the following four users:Super administrator sys change_on_installGeneral Administrator System ManagerNormal user Scott TigerBig Data User sh 1. Uninstall Oracle1. Stop all Oracle-related services.2. Use OUI (Oracle universal

1: A client must be installed when you use toad to connect to Oracle, Select instantclient, but if you want to use the DMP file of the imp/exp database or perform the sqlplus operation, you need to select the following (Administrator) [runtime, you

RecallOracle Installation and DeletionStart and closeSQL * Plus Windows window versionSuper User System/ManagerSys/change_on_installCommon UserScott/TigerSqlplus version under DOSHow to UseCommand show userSQL statementDifficultiesHow do I add

Parallel Database access, that is, two or more users access the same data at the same time. This is also the biggest problem for the database engine to design and implement a moderate response. It.phontol.com's database engine with excellent design

Because the company wants to replace the advertising system and test the performance of the new system, the company's previous system uses Oracle, the new system is MySQL, and the table structure is not the same. Create a user in the local Oracle