Oracle

Use of the CONTAINS function in Oracle 1. Find a student's address in BeijingSELECT Student_id,student_name from Students WHERE CONTAINS ' Beijing ' )Remark:beijing is a word that is enclosed in single quotation marks.2. Check the student's address

Second, the steps are as follows1. Create a DirectoryData pump requires the creation of a directory for the files and log files to be created and read, this parameter is used to define a directory, the previous mentioned data pump mainly work on the

First, about the uninstallation of OracleIn the previous blog we mainly introduced the basic concepts of Oracle, architecture, installation procedures, etc., but the design of the uninstallation of Oracle did not do a detailed introduction, but if

1 Query Implicit parametersSELECT x.ksppinm NAME, Y.KSPPSTVL VALUE, X.ksppdesc describFrom Sys.x$ksppi x, SYS.X$KSPPCV yWHERE x.inst_id = USERENV (' Instance ')and y.inst_id = USERENV (' Instance ')and x.indx = Y.indxand x.ksppinm like '%&par% '2

A table connection is required for multiple table queriesConnection can be divided into: (self-Baidu)Cross Join (Cartesian product of the digital logic, no explanation)Equivalent connectionFor example: SELECT * from T_a, t_b where t_a.xx = t_b.xxNo

--condition Comparison/*=,! =,<>,,=,any,some,allis Null,is not Nullbetween x and Yin (list), not In (list) exists (sub-query) Like _,%,escape ' ' _\% escape ' \ '*/--any some can select E.ename, e.job,e.sal from EMP E where e.sal as long as any one

SQL Usage tips in Oracle: Use | | As a connector, for example: selectlast_name| | job_id as "Employees" from Employees; When adding aliases to a column, you can enclose it in double quotation marks, which keeps the alias in lowercase,

1. Export the database instance:operate under the cmd command:Exp database user name/password @ server ip:1521/ Example file=c:\devdb.dmp full=y2. Import the database instance:Create the related database, set up the related table space + user +

Original source: Little BMW's father-the dream homeIn front of, but also intermittently introduced some such as sql*plus and so on Oracle's basic content,For a large database such as Oracle, its own operation and maintenance is also a great thing,So

How [Oracle] observes the conflicts between various lock types in tableExample:SESSION#15 Create a table:SID 15==============CREATE TABLE T1 (C1 number)Partition by range (C1)(partition P1 values less than (' 11 '),Partition P2 values less than (' 21

In fact, a multi-table query refers to an operation that takes data out of multiple tables and displays it.Reason for the existence of the SELECT * from Scott.emp,dept.emp Cartesian productActual:SELECT * from Scott.emp E, scott.dept d WHERE

Function: Used to return specific data, functions can be executed directly in the SQL statement, including return for data manipulation, and return a separate function valueStored procedures: Used to complete a specific task (business of the program)

Common functions:• Statistics: Count (), returns the result based on the actual amount of data in the table;• Sum: Sum (), which is a statistic for numbers, sums• Average: Avg (), various data types support• Max: Max (), various data types support•

When Oracle is installed, the specified SID already exists on this computer if it appears. Such an error. This is the second time you've installed your Oracle, and the error is that you didn't have to clean up the original stuff about Oracle, so let'

[Oracle] fast way to construct large amounts of data:CREATE table tab001 (ID integer primary key, Val varchar2 (100));INSERT INTO tab001Select I+j,rpad (To_char (i+j), +, ' A ')From (With DATA2 (j) as (Select 0 J from DUALUNION ALLSelect j+1000 from

There are several items in the Oracle constraint state that can be confusing, for each of them: enable/disable--whether to enable/disable validate/invalidate--Confirmation/Not confirmed Deferrable/not deferrable--can be

Oracle's table creation and transaction management- CURD，根据查询结果创建新表- 事务管理 - 什么是事务 ，为什么要用事务 - SQL99事务隔离级别 - Oracle事务隔离级别 - 事务回滚 - 隐式回滚 - 显示回滚 - 事务提交 - 隐式提交 - 显示提交 - 事务回滚点1, curd, create a table according

Special Note: I blog part of the reference network other blogs, but I have personally written and verified through. If you find that the blog has errors, please prompt to avoid misleading other people, thank you! Welcome reprint, but remember to

Tag:field   lex   cron    Execution    ram     Authorization grant    common    type   otf    Create a table table spaceCREATE TABLESPACE waterboss DATAFILE ‘E:\oracle\beckDb\waterboss.dbf‘ -- 物理文件存放在磁盘的具体路径 SIZE 10m -- 初始物理文件的大小 AUTOEXTEND ON --

Specify the instance name and modify IP address of the listener in the Listener.ora file:View instance name: [localhost$] Echo $ORACLE _sidLISTENER = (description_list = ( DESCRIPTION = ( address = (PROTOCOL = IPC) (KEY = EXTPROC1521))