Parameterless stored procedure:
create or replace procedure sayhello
Two call methods of command window
SQL> set serveroutput on; --The first time I have to drive
SQL> exec sayhello
PL/SQL procedure successfully comple ...
Posted by joenjeru on Sun, 29 Mar 2020 09:34:56 -0700
DCL Data control language
Statement of authorization and right to receive as mentioned before
Data definition language
create alter,drop statement, create table, modify table, delete
create table $tablename$(
name,varchar(5) --Maximum length required to declare
-- Cop ...
Posted by ashell on Mon, 25 Nov 2019 11:28:05 -0800
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
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
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
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
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.
First, you need to have CREATE ...
Posted by jhlove on Fri, 12 Apr 2019 12:15:32 -0700
What are constraints
Constraints are mandatory at the table level
There are five constraints:
- NOT NULL
- PRIMARY KEY
- FOREIGN KEY
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
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
The following is from Oracle Database Express Version 11g Version 2 OTN Licensing Protocol:
Any u ...