Oracle

1, Database status query: Sql>select status from V$instance; 2, the Database monitoring status query: C:/Documents and Settings/skate_db>lsnrctl status    1, Database Status command results detailed:   [email protected]/export/home/oracle >  sqlplus 

One, character functionsThe character function is the most commonly used function in Oracle, so let's see what the character functions are:Lower (char): Converts a string to a lowercase format.Upper (char): Converts a string to an uppercase

Find the smallest non-0 digits to add together.High precision.1#include 2#include 3#include 4#include 5#include 6 using namespacestd;7 #defineLL Long Long8 Chars[10000005];9 inta[10000005],b[10000005];Ten intt,p; One intMain () A { -scanf"%d",&t); -

Http://blog.sina.com.cn/s/blog_a45aac720100yu3h.htmlError-util.jdbcexceptionreporter>: Breach of agreementError-util.jdbcexceptionreporter>: OALL8 in an inconsistent state!Recently been entangled in this problem for a long time, yesterday finally

function Syntax:sign (n)function Description: The symbol of the decision value N, if n > 0, returns is 1, if n Examples of functions:One,Select sign (+) as "positive number", sign ( -100) as "negative -100", sign (0) as "0" from dual;650) this.width=

1.--Creating table SpacesCreate tablespace cmdb_db datafile ' \home\cmdb_11.dbf ' size 100m autoextend on next 50m extent management local;2.--Build UsersCreate user cmdb_1023 identified by admin default Tablespace cmdb_db;3.--give permissionGrant

Build table Information1. Table Structure EMP----Employee Information Sheetename VARCHAR2 (30),--NameEmpno Number (5),--NumberDeptno Number (5),--Your departmentJob varchar2 (20),- Types of jobs (categories of personnel), such as manager managers,

1. With-as-select syntax: equivalent to temporary tableWith T as (SELECT * from emp where deptno=10)select * from T;2. Case syntax and decode syntaxDECODE (Value,if1,then1,if2,then2,if3,then3,..., else)1 Select(2 Caseename3 when

--1. Deleting temporary tables drop table biz_bus_station_direct_0711;--2. Placing site data, etc. into a temporary tableCreate Tablebiz_bus_station_direct_0711 asSelectLs.line_no Line_no, Bb.line_name line_name, T1.line_direct line_direct,

CREATE TABLE SpaceMethod 1:The code is created as follows:PL/SQLCreate a tablespace (typically a table space with n stored data and an index space):Create tablespace table space nameDataFile ' Path (to build the path first) \***.dbf ' size

Problem: When using MyBatis BULK INSERT, MySQL uses the foreach tag to connect each record by a comma ",".However, Oracle does not support it.Oracle supports the following notation:InsertID= "Insertstudents">INSERT into Student (ID, name, age,

Oracle's flash-back technology is a data recovery technology that only restores user logic errors ,The flashback is for committing a commit transaction, no committed transaction, using rollback1. Flash back version Query Flashback Version QueryThe

OracleSynonymsOracle synonym for (synonyms) similar to view features, but more powerful. Most database objects in an Oracle database, such as tables, views, materialized views, sequences, functions, stored procedures, packages, synonyms, and so on,

Select Max(Sun) Sun,Max(Mon) Mon,Max(Tue) Tue,Max(Wed) Wed,Max(Thu) Thu,Max(Fri) Fri,Max(Sat) SAT from(SelectDecode (D,1, DD) Sun, decode (d,2, DD) Mon, decode (d,3, DD) Tue, decode (D,4, DD) Wed, decode (d,5, DD) Thu, decode (d,6, DD) Fri, decode

First, select basic syntax:SELECT *| {[DISTINCT] column|expression [alias],...} fromtable;Select identifies which columns are selected.From identifies the table from which to select.1. Remove all columns from the tableSELECT * from EMP;Connected to

In SQL sorting, Oracle defaults to a binary ordering method. The case has different values, and the uppercase values are in front. Sometimes, we need to deal with situations where we want to sort by ignoring the casing. There are several ways to

1. Declaring cursorsDeclareteacher_id Number(5); Teacher_namevarchar2(5); Teacher_titlevarchar2( -); Teacher_sexChar(1);cursorTeacher_cur is SelectTid,tiname,title,sex fromTeacherswhereTid117;2. Open the cursorOpen cursor name;Declareteacher_id

Prior to installing Oracle, but after the first installation, you do not know how to enter the user name and password into the inside, now teach you how to enter Oracle to execute the corresponding commandSolve the problem with ora-280000 the

Index:Query user_indexes can get more information about the indexes that the user has created.Query user_ind_partitions can get detailed information about the partition index that the user has created.Query User_ind_columns can get detailed

1:root User execution: Df-k/tmpFree space is greater than 400M can2:cat/etc/issue command to view Linux versions3:uname-r command to view the kernel4: Check the relevant packagesThe command is: RPM-Q related package5: Build two