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
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 (, '----------
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,
--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
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 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;
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.
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 '
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
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
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 '
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
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 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
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
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
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
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.
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