Programmer Group

Parameterless stored procedure: create or replace procedure sayhello as --Explanation part begin dbms_output.put_line('hello world'); end; 1 2 3 4 5 6 Two call methods of command window 1. SQL> set serveroutput on; --The first time I have to drive SQL> exec sayhello hello world PL/SQL procedure successfully comple ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...