Oracle Stored Procedures

CREATE TABLE STUDENT (--Creating student tablesID Number (TEN) PRIMARY key,--primary Key IDSNAME VARCHAR2 (20),);--Create a stored procedure to add a record to a student tableCREATE OR REPLACE PROCEDURE procedure_add(in_id in

Oracle Custom Functions

CREATE TABLE STUDENT (--Creating student tablesID Number (TEN) PRIMARY key,--primary Key IDSNAME VARCHAR2 (20),CLASSNAME VARCHAR2 (20)--Class);INSERT into STUDENT VALUES (1, ' Tom ', ' Svse ');INSERT into STUDENT VALUES (2, ' Jack ', ' GIS ');INSERT

Oracle transforms from function to system

hexadecimal conversion to decimal: To_number ()Sql> Select To_number (' A ', ' X ') from dual; To_number (' A ', ' X ')------------------10Decimal conversion to 16 binary: To_char ()Sql> Select To_char (ten, ' xxx ') from dual; To_char (, '----------

oracle-table is locked

1. If you update a table, without an error, waiting for a long time is not over, it is likely that the table is locked.2. View Locked objectsSelect sid,serial#,username,schemaname,osuser,machine,terminal,program,owner,object_name,

Oracle Query Table

--View User system permissionsSELECT * from Dba_sys_privs;SELECT * from User_sys_privs;--View User object permissionsSELECT * from Dba_tab_privs;SELECT * from All_tab_privs;SELECT * from User_tab_privs;SELECT * from Dba_roles; --View all roles--View

Oracle Parameter Parallel_max Experiment

The parameter Parallel_max is the Oracle's largest open parallel service process, the concurrent sum of all sessions.Sql> Show Parameter Parallel_max_serversNAME TYPE VALUE------------------------------------ ----------- -----------------------------

Oracle Database Creation Table Space

--oracle Database Creation Table spaceCreate Tablespace New_taspace--Table space nameDataFile ' D:\NEWTABLESPACE. DBF ' -the data file and location associated with the tablespaceSize 200M --File Initial sizeAutoextend on next 20MB MAXSIZE 400MB;

Oracle queries grouped by month

As the following table table1:Number of dates (exportdate) (amount)--------------                    -----------1 April-February-08 20October-March-08 21 April-April-08 61 April-June-08 752 April-October-09 231 April-November-09 45April-August-10

Oracle installation Basic Steps

Installing the Database1. Set up user groups and users groupadd Oinstallgroupadd dbagroupadd operuseradd-G Oinstall-G dba oraclepasswd Oracle2. Create the installation directory and permissions mkdir-p/opt/Ora10gchown-R oracle.oinstall/opt/ora10g3.

Oracle Birthday Reminder SQL statement notation

Today want to be a staff birthday reminder module, suddenly found that the statement is not good to write, so Baidu summed up a bit, hehe.select * from table name where humanstate= ' normal incumbency ' and  (To_number (To_char ((dateOfBirth), ' mm '

Oracle data read consistency and transactional tables

  The key to ensuring the consistency of Oracle database reads is the SCN. Each data block will record the SCN for a transaction submission. At the same time, each data block contains a transaction table (ITL), and the transaction must obtain an ITL

Oracle Foundation-Index

First, the indexIndexes are a quick way to access data to improve database performance. Indexing makes it possible for a database program to find the data it needs without having to scan the entire table, like a book's directory, to quickly find the

Oracle Basic Syntax

1, CREATE table space, table space name is database, directory is datafile ' d:\oracle\product\10.2.0\oradata\data01.dbf ', size is 100M, each auto expansion 10M, maximum unrestricted. Create tablespace database datafile '

Oracle Foundation <4>--Package

One: Package definition (includes 1. Package Specification 2. Package Body )A package is a database object that encapsulates the related PL/SQL types, subroutines, cursors, exceptions, variables, and constants.1, Package Specification: You can

Oraclesys_context () function

Oraclesys_context () function The first parameter is 'userenv', which is fixed. The second parameter is also fixed, but multiple options are fixed. The optional values are as follows:   Select sys_context ('userenv', 'authentication _ type') from

Guarantee of successful installation of oracle11g

Guarantee of successful installation of oracle11gEnvironment: LSB Version: core-4.0-amd64: core-4.0-noarch: graphics-4.0-amd64: graphics-4.0-noarch: printing-4.0-amd64: printing-4.0-noarch:Distributor ID: RedHatEnterpriseServerDescription: Red Hat

Modify the ORACLE field order

Modify the ORACLE field order First, you need to have a pl/SQL statement, but there is still a visual interface for this database. 1. First, log on to PL/SQL as a sys user2. query the ID of the table you want to change. Take my local data as an

Oracle11g installation problem summary

Oracle11g installation problem summary Test environment: win7 64-bit flagship edition + jdk7 (64-bit) Installed Software: oracle 11g R2 64-bit After the database is installed according to the general online tutorial, a bunch of problems are found.

Oracle generation random date and time

Oracle generation random date and time 1. Generate a random date   For example, to generate an arbitrary date within January 1, 2015: /** Analysis: any date within, that is, the date range is (2015)* Can be converted to + (0,365 ),* In this example,

Oracle Memorandum 1

Oracle Memorandum 1 Database Administrator: Install and upgrade the Oracle database to create a database, tablespace, table, view, and index... Develop and implement backup and repair plans database permission management, tuning, and troubleshooting.

Total Pages: 2147 1 .... 2131 2132 2133 2134 2135 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.