Oracle

Case: Open card information in the bank Field Field type Id Number Name VARCHAR2 (64) Sex CHAR2 () Birth Date Money Number (10,2)

　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　Cursor Properties and Restrictions/*1. Cursor Properties%found%notfound%isopen to determine if the cursor is open%rowcount the number of rows affected2, the cursor limitBy default, the Oracle database allows only 300

This morning to the company, opened the computer and found that the launch of the Oracle instance, reported the following error:Oops, all of a sudden worried, the original still good how suddenly so? I recalled that it was my previous modified

I. ORACLE internal structure1. Table SpaceA tablespace is a logical division of a database, a table space belongs to only one database, each table space consists of one or more data files, and other logical structures in the table space are stored

[Email protected] ~]$ Ps-ef|grep SmonOracle 14809 1 0 Sep25? 00:13:02 ORA_SMON_MAILP3[Email protected] ~]$ export ORACLE_SID=MAILP3[Email protected] ~]$ echo $ORACLE _sidMailp3[Email protected] ~]$ Sqlplus/as sysdba;Sql*plus:release 11.2.0.3.0

Nothing's going on today. Installed Oracle database, but in this process encountered a lot of problems, here want to share with you.At first I installed the Oracle 12c, but this installation does not matter, Ann me a full half a day is not well, in

I. Smon: System monitoring Process1. Mainly submitted data but has not yet been written to the data file to power down, restart the time, the Smon will be restoredA. Roll forward, the redo log file has been written but no data has been written to

Oracle Instant Client (clients) download1,:http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlThe download will be a compressed file with the following contents: D:\Program files\instant client. Put it in the

First, the businessReview What is a transaction?An indivisible sub-operation forms a whole, which either executes successfully or fails all. Example: TransferReview Why do you use transactions? If you do not have a transaction, for example, a user

Basic syntax for user authorization: Grant permissions/role to username; Master2. Switch usersSwitch User basic syntax: Connect user name/password; Master3, xiaoming Change passwordChange Password basic syntax: password user name;Admin Change

Resources:Http://www.cnblogs.com/jiguixin/archive/2011/09/09/2172672.htmlhttp://blog.csdn.net/lanchengxiaoxiao/article/details/39251947Install package Download:Link: https://pan.baidu.com/s/1qYBeXT6 Password: FaagFirst, unzip the file, run Setup.exe,

Export can be understood as setting environment variables in the Linux bash. Can be used by the current shell and child shell.The meanings of these variables are somewhat meaningful and you can view the corresponding documents, and I'll explain to

1. To enable Python to operate the Oracle database, first install the Cx_oracle package.2. Create a simple Python file to test whether the installation was successful.1 #!/usr/bin/env Python32 #-*-coding:utf-8-*-3 4 Importcx_oracle5DNS_TNS=CX_ORACLE.

DatabaseListener.ora# Listener.ora Network Configuration file:c:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration Tools. Sid_list_listener = (sid_list = ( Sid_desc = (sid_name = Clrextproc)

1. Equivalent connection: Take the same record as the relationship columnSELECT * from emp e,dept d where E.deptno=d.deptno;Find the same records as the Deptno column in the EMP and dept tables2, non-equivalent connection: Take a record of the

A table connection is required for multiple table queriesConnection can be divided into: (self-Baidu)Cross Join (Cartesian product of the digital logic, no explanation)Equivalent connectionFor example: SELECT * from T_a, t_b where t_a.xx = t_b.xxNo

Select Ename,hiredate,sysdate from Scott.emp; can find out the date of employee's entry to presentSelect Ename,sysdate-hiredate from Scott.emp; See how many days the employee has been in service;Select Ename,months_between (sysdate,hiredate) from

View Buffer command: ListExecute save 1.sql can be saved by the buffer command.Execution @1.sql can execute the saved content;Show feedback Displays the feedback information, the last line.Show Echo onShow ArraySize 5000 View the number of rows for

How [Oracle] observes the conflicts between various lock types in tableExample:SESSION#15 Create a table:SID 15==============CREATE TABLE T1 (C1 number)Partition by range (C1)(partition P1 values less than (' 11 '),Partition P2 values less than (' 21

Oracle's table creation and transaction management- CURD，根据查询结果创建新表- 事务管理 - 什么是事务 ，为什么要用事务 - SQL99事务隔离级别 - Oracle事务隔离级别 - 事务回滚 - 隐式回滚 - 显示回滚 - 事务提交 - 隐式提交 - 显示提交 - 事务回滚点1, curd, create a table according