oracle learning notes DCL data control language and DDL data definition language

DCL Data control language Statement of authorization and right to receive as mentioned before grant, revoke Data definition language create alter,drop statement, create table, modify table, delete Create table create table $tablename$( id int, name,varchar(5) --Maximum length required to declare money,number(6,2) --9999.00 ) -- Cop ...

Posted by ashell on Mon, 25 Nov 2019 11:28:05 -0800

oracle's advanced use [5] stored procedure, stored function and package

Stored procedures are used to perform specific operations and complete certain functions. They can have input parameters in and output parameters out. Store functions are used to return specific results. Use the return clause at the head of the function, specify the type of return, and use the return clause in the execution part to ...

Posted by alconebay on Tue, 05 Nov 2019 10:13:20 -0800

Installation of oracle 11g under Debian 8

oracle has never supported Debian systems. How did the leader have to put it on debian, so he started. 1. Create directories and users: /usr/sbin/groupadd -g 501 oinstall && /usr/sbin/groupadd -g 502 dba && /usr/sbin/groupadd -g 503 oper && /usr/sbin/useradd -g oinstall -G dba,oper -d /home/oracle/ -s /bin/bash ora ...

Posted by Typer999 on Tue, 09 Jul 2019 16:14:56 -0700

A Problem Record in Oracle Expansion Table Space

When this Case happened, I was out of town, and the project manager managed to solve it. I'll sort it out and share it with you. Problem phenomenonWe need to expand a table space under Oracle DB, but when executing the expansion command, Oracle reported the following error:ORA-00059 : maximum number of DB_FILES exceeded Error Reporting Interp ...

Posted by Kaizard on Tue, 04 Jun 2019 13:23:34 -0700

Oracle User Management

Example:    #sqlplus /nolog   SQL> conn / as sysdba;   create user username identified by password;   grant connect,resource to username;   grant select,insert,update,delete on Table name to username;   //Let this user create views   grant CREATE VIEW to username;   //Let this user create tables   grant create table to ...

Posted by syntaxerror on Tue, 21 May 2019 18:05:50 -0700

Using flip-flops to realize id self-growth

How to achieve id self-growth after inserting data Reference Blog: http://www.cnblogs.com/hyzhou/archive/2012/04/12/2444158.html ORACLE SEQUENCE Usage In oracle, sequence is the serial number, which increases automatically every time it is taken. Sequence has nothing to do with tables. 1,Create Sequence First, you need to have CREATE ...

Posted by jhlove on Fri, 12 Apr 2019 12:15:32 -0700

4. Constraints && Views

What are constraints Constraints are mandatory at the table level There are five constraints: - NOT NULL - UNIQUE - PRIMARY KEY - FOREIGN KEY - CHECK Table-level constraints and column-level constraints Scope of action: (1) Column-level constraints can only work on one column (2) Table-level constraints can be applied to mu ...

Posted by rosegarden on Thu, 11 Apr 2019 11:03:31 -0700

Configuration and Use of Oracle 11g XE and Oracle SQL Developer

The Oracle database is used in the project, so backup and restore are needed locally (there is no database shared on the LAN). For example, there is now a backup file of student.dmp database. Install and configure Oracle 11g XE brief introduction The following is from Oracle Database Express Version 11g Version 2 OTN Licensing Protocol: Any u ...

Posted by TKKP on Wed, 19 Dec 2018 22:42:05 -0800

ASM Translation Series 12: ASM Internal amdu - ASM Metadata Dump Utility

Original text: ASM disk header Author: Bane Radulovic Translator: Zhuang Peipei, Pre-sales Engineer of Waukee Science and Technology Database, is mainly responsible for database platform architecture design, product validation and testing. Revision: Wei Xinghua Chief Editor: Qian Shuguang amdu - ASM Metadata Dump Utility ASM Metadata Du ...

Posted by somedude on Sun, 16 Dec 2018 02:42:03 -0800

Oracle11g migrates from single instance + ASM to RAC+ASM

A few days ago, when my department colleagues were working on the project, the customer asked to migrate the single instance + ASM database to RAC+ASM. After that, the God sorted out some ideas and operation details and published them on the company's public number. I saw itching in the future, so I planned to do an experiment ...

Posted by Jewbilee on Sun, 16 Dec 2018 02:06:03 -0800