Oracle

Oracle Learning1. Create a constraint for the table :ALTER TABLE name ADD CONSTRAINT constraint name constraint contentExample: Alter bable infos add constraint un_stunsme unique (stuname)//UNIQUE constraint;ALTER TABLE scores add constraint

LessonaimWhile retrieving data from the database, you may need to restrict the rows of data that is displayed or specify The order in which the rows is displayed.This lesson explains the SQL statements, Youuse to perform these actions.? filter rows

select * from T_user where user_name like CONCAT ('% ', #{search_name}, '% ') select * from T_user where user_name like '% ' | | #{search_name}| | ' % ' select * from T_user where user_name like CONCAT ('% ', #{search_name}, '% ') select * from

Wrote a complex SELECT statement, suddenly Oracle reported: ora-25153 temporary table space is empty, this error, and then the online search, found the following workaround: Create a new temporary tablespace.First you have the system permission, log

The use of virtual machines on the physical machine to build RAC environment encountered a lot of "pit" and key points, here slowly one by one aftertaste summary.Physical machine: Intel (R) Core (TM) i7-5600u CPU @ 2.60ghz,8g MemoryVirtual machine

Before importing and exporting data, it is customary to check to see if our own machine can connect to a remote Oracle host, and the detection method is tnsping service_name. My machine is as follows:c:\users\zx>tnsping ORCLHost: lenovo-pc, service

1, default automatically check my Objects by default, plsql developer login, Brower will select all Objects, if you are logged in the user is a DBA, to expand the tables directory, the normal situation will need to wait a few seconds, and choose my

Yesterday I installed Oracle, today try automatic Backup, I installed Linux and Oracle These two days is the purpose of this.In the case of SQL Server, regular backups can be done with SQL Server Management Studio, which is convenient. But to do

Grouping functions: Acts on a set of values and returns a value to a set of data;Use of grouping functions:Commonly used grouping functions:AVG (averaging), sum(sum), min(minimum), Max(max), Count(Total), Wm_concat ( Row to column )Example :Select

String typeFixed length: char nchar n denotes Unicode encodingVariable length: varchar2 nvarchar2Numeric type: Number (p,s) P: integer digits, S decimal placeInteger integersBinary_float Single floating pointBinary_double Double floating pointFloat (

Http://www.2cto.com/database/201204/127180.htmlOracle implements the method by which the stored procedure returns a collection of query results-the method that implements the stored procedure to return a collection of query results, from the network

Today in the company's server installed a system, in the database guide the time has not been in, was originally 10g. dmp file, import 11g, suspect version incompatible, later put the. DMP table Open, change the version number inside to 11g, and

How Java passes a set of objects to an Oracle stored procedure, as in the following example:CREATE OR REPLACE TYPE test_object as OBJECT ( ID number, name VARCHAR2 (32)); CREATE OR REPLACE TYPE Tables_array as Varray (+) of Test_object;drop table

 Method One:[Email protected] ~]# Su-grid[Email protected] ~]$ Sqlplus/as sysasmSql*plus:release 11.2.0.3.0 Production on Thu Jul 3 09:36:27 2014Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition

Oracle Sql*plus Common Commands 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,

In ubuntu14, download the oracle-java8, ubuntu14apt-get through apt-get1. Install jdk1.8(1) download the oracle-java8 through apt-get, first, add the ppa source, equivalent to adding a software Repository Sudo add-apt-repository ppa:

Concepts of User and Schema in Oracle In database theory, database users and database models are not necessarily related. For detailed explanations of database models, you can find them

How to Use log miner to analyze oracle logs, mineroracle When we accidentally mistakenly cause the database data to be lost or changed, we need to restore the database objects based on time points to find the data we need. This time point cannot be

Oracle creates databases and users, and oracle creates Databases In the past, mysql and SQL server were mostly used during development, while oracle was rarely used and unfamiliar. mysql and SQL server were used in a similar way, the usage of oracle

New feature 3 of Oracle12c -- ASM & Grid 1. Enhancements to Automatic Storage Management (ASM) 1.1. Flex ASM In a typical Grid Architecture Installation, each node has its own ASM instance running and plays the role of the database storage container