Oracle

-------How to create a normal user in Oracle 12c-------[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 12.1.0.2.0 Production on Sun Nov 29 21:43:50 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 12c

Get table field:SELECT *From User_tab_columnswhere table_name= ' user table 'ORDER BY column_nameGet Table Comments:SELECT *From User_tab_commentswhere table_name= ' user table 'ORDER BY table_nameGet field Comments:SELECT *From

Data grouping,grouping function max, min, avg, SUM, Count Find the name of the person with the highest pay Select ename from emp where sal = (select Max (SAL) from EMP); 10% increase in salary for all employees below average

Instructions for using Oracle function ListaggAt work, customers often come up with the requirement that they want to enumerate the dates one by one in a summary merge., the original data is this:Customers want to be able to achieve such a summary

Experimental object: Two Linux stand-alone Oracle 12C databases (both large and small versions are consistent), data migration takes a cold backup way. The path of the target machine is inconsistent with the source library and needs to be rebuilt

ALTER TABLE UserInfo Add (msn varchar2 (20));1. Build a table CREATE TABLE UserInfo ( ID Number (6), Name VARCHAR2 (20), Sex number (1), Age Number (3), Birthday date, Address VARCHAR2 (50), Email VARCHAR2

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is

Purpose of this function: Returns a tableImplemented in Oracle, example:1--in the types:2Create or replace type objtable as Object3 (4S_usercode VARCHAR2 (32767),5S_username VARCHAR2 (32767)6 );7 8 CREATE OR REPLACE TYPE tabtemp as TABLE of objtable;

Oracle's Best Flexible architecture (Optimal flexible Architecture, referred to as OFA) refers to the naming conventions and storage location rules for Oracle software and database files and folders. It can be used as a good set of habits, which

Oracle/plsql:Lpad FunctionThis is the Oracle/plsql lpad function with syntax and examples of the Oracle tutorial explains.DescriptionThe Oracle/plsql lpad function pads The left-side of a string with a specific set of characters if string1 is Not

ExecuteThe syntax for immediate is as follows:ExecuteImmediate'SQL';ExecuteImmediate'Sql_select' intovar_1, var_2;ExecuteImmediate'SQL'Using[In|out|in out]Bind_var_1,[In|out|in out]bind_var_2;ExecuteImmediate'Sql_select' intovar_1, var_2

Stored Procedure creation Syntax:Create or Replace procedure stored procedure name (param1 in type,param2 out type)AsVariable 1 type (value range);Variable 2 type (value range);BeginSelect COUNT (*) into variable 1 from table A where column name

Today, we need to make room on this machine, found that Oracle has a DBF file accounted for about 30G, the data file corresponding to the user usually rarely used, and then want to handle it-delete table space operations.The native database is a

View v$session_wait can be used to view the current wait events for the system and information about the resources that correspond to the wait events, thus identifying the type of bottlenecks and their objects. V$session_wait's P1, p2, and P3 tell

The use of decode in OracleDecode function usage in OracleMeaning explanation:Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value)The function has the following meanings:IF condition = value

First, download: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlDownload the corresponding version according to your actual needs.Two, configureUnzip the downloaded instantclient-basic-win32-11.2.0.1.0 compressed package into the

Database SQL optimization Summary-millions of database optimization solutions, Database SQL (1) select the most efficient table name sequence (only valid in the rule-based seo/'target = '_ blank'> Optimizer ): the ORACLE parser processes the table

Outer Join, left Outer Join Definition: Used to query records that meet the connection conditions and do not meet the connection conditions. Query emp table records SELECT * FROM emp;Empno ename job mgr hiredate sal comm deptno1 7369 smith clerk 7902

Oracle 11g R2 for Win7 flagship edition (64-bit) Installation Steps, 11gwin7 Databases have many versions. Which one should I learn? Everything is rational. Although there are many database versions, the essence is the same. The changes are just

Prediction and offset of OracleEBSMRP ModuleThe Oracle ebs mrp module defines the basic concepts of prediction and subtraction based on the original prediction. It uses the planned sales order to reduce the corresponding prediction quantity to get