Oracle

By manually creating an Oracle database, you can understand the structure of the Oracle database and the database operating mechanism to help you understand the Oracle database. First, open the command line tool, create the necessary relevant

By default, Oracle does not start automatically with the system under Linux. 1. Start Oracle 1. Log in to CentOS with an Oracle account　　 , or switch to Oracle user rights # su–oracle 2. Then enter: $ sqlplus "/as sysdba" 3. The original screen will

Original address: http://blog.sina.com.cn/s/blog_5014663501007n40.htmlin the design of the database, choose the right data type, often can avoid a lot of problems, correctly understand the type of database, for storage space planning, application

Partition table has a lot of advantages, to Dahua small, a small, coupled with the use of parallel, in the LOAP can often improve the effect of dozens of times times or even hundreds of times times.Of course the design of the table is not good also

Sdd53homeNew Oracle Database encountered ORA-00922: option is missing or invalidCause: There is usually a problem with the syntax of the statement. For example, the name is wrong, the keyword is wrong and so on. For nonstandard naming, double

Download Oracle (this is no nonsense!) ）To a link, you need to register Oracle and then download it.Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.htmlUnzip the installation12c has two files, download them and unzip

I. ORACLE Physical Architecture Principle Structure diagram Each part explains:PGA: Private memory area for use by the current initiating user only.Three effects The session information after the user logs in will be saved in

1, whether to open the Audit function queryShow parameter AuditNAME TYPE VALUE------------------------------------ ----------- ------------------------------Audit_file_dest string/home/oracle/app/oracle/admin/Orcl/adumpAudit_sys_operations Boolean

the job can be used in Oracle to automate some tasks, similar to the functionality of the UNIX operating system crontab command.A brief demonstration, for reference.1. Create a table T, which contains an X field, defined as a date type, to

Exp Zdxk/[email protected] tables= (MS_DATA_DICTORY_DEF,MS_STATIC_DATA_DEF) file=c:\staticdata.dmpExport by entering the EXP command and your username/passwordThe action prompts you to enter the parameters:For example: EXP Scott/tigerAlternatively,

Operating system: Windows 7Database version number: Oracle 10gVS Version number: VS2010Introduction: There are many ways to connect Oracle, here only proc Shell, explain how to connect Oracle, what's the matter, I hope you tell me to point out,

1 , build a test table [C-sharp]view plaincopyprint? CREATE TABLE Edw_int ( Agmt_no VARCHAR2 (+ BYTE) not NULL, Agmt_sub_no VARCHAR2 (4 BYTE) not NULL, Need_repay_int number (22,2), Curr_period Number (4) Not NULL ); CREATE TABLE

CREATE OR REPLACE FUNCTION number_to_bit (v_num Number) RETURN VARCHAR is V_rtnVARCHAR(8);--Note return column lengthV_n1 Number; V_n2 Number;BEGINv_n1:=V_num; LOOP v_n2:=MOD (V_N1,2); V_N1:= ABS(TRUNC (v_n1/ 2)); V_RTN:=To_char (V_N2)||V_rtn;

trunc (D1[,C1]) returns the date D1 the first day of the period (parameter C1)D1 Date Type, C1 is character (parameter), C1 default is J (i.e. current date)C1 the corresponding parameter table:This week Sunday: day or Dy or D (Weekly order: Days,

Installation of Oracle 11g database1. Install the virtual machine, use VMware or VirtualBox, run the memory configuration to 4G, the hard disk expands automatically. (CPU virtualization does not need to be turned on)2. Install the operating system

Control file management and common parameter settings in Oracle Database, oracle File Management I. Control FilesPurpose: Binary files Records the structure and behavior of the current database instance, data file and log file information, and

Execution Plan in oracle-view, The content mainly comes from reading and learning notes. The following describes the methods for querying execution plans. 2.2 view the execution plan1. explain plan2. dbms_xplan package3. autotrace4.10046 events5.1005

The basic method for installing Oracle databases on Mac OS, osoracle Basic Environment: Snow Leopard10.6.2, Oracle10.2.0.4 Open the Mac terminal and execute: sudo -i Create an oinstall group and an oracle user. Make sure that the ID of the combined

Unlock database users1. log on to and unlock the account with the dba role. First, set the specific time format to view the specific time. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. 2. Check the lock time

Implementation of Oracle's INSTR function MySQLIn a migration project, the instr function of MySQL can only find whether the child string is in the parent string. Here I wrote one for migration. Of course, here I only focus on migration, and may not