Oracle

That's too bad, Dad! Installation: 1.Chroma application Service2. PL SQLSteps and procedures for installing Oracle 11g:The first step: only the Oracle 11g bit database can be installed to ensure that the Chroma application Service can connect

In the early days of the National Day, Oracle 11 was installed on CentOS 6.5 to test colleagues, and what was used was normal. Before the festival I take a day off, call me that the system in the machine can not log in from the command line, enter

Remote ImportImp sdtyzh/[email protected]10.1. 69.99/sdtyrz file=e:\hongtastock_account.dmp log=E:\hongtastock_account.logfromuser= Hongtastock_account touser=sdtyzh ignore=yimp sdjyhtyw/[email protected]10.1. 69.99/sdtyrz file=e:\hongtastock_

Create or replace procedure times isII Positive:=1;BeginLoopDbms_lock.sleep (1);Dbms_output.put_line (ii| | ' ' | | To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss '));ii:=ii+1;Exit when ii>10;End Loop;End/Results:Sql> exec times;1 2016-10-08 11:26:572 201

Client: WIN10Server: Oracle server installed on Linux1, download Plsqldeveloper11.zip, Instantclient_11_2.rar and unzip to the corresponding directoryD:\instantclient_11_2, D:\PLSQL Developer2. Add environment variables on WIN10Variable name:

Sometimes, when the graphical interface cannot be used, we need to manually delete the database, with the following steps:First, manually delete the file system database1. Stop monitoring, prevent new connections, and at the same time, the database

Example of data sampleSecond, split single lineSELECTId_,regexp_substr (Name_,'[^,]+',1, rownum) H2 from(SelectId_,name_ fromTest_reg_count TwhereT.id_=2) CONNECT by Level Length (name_)-LengthReplace(Name_,',',"'))+1;--orSELECTId_,regexp_substr

Data Description:Select * fromDave;ID NAME 8Anqing1Dave2BL1BL2Dave3DBA4sf-Express5DmmSelect * from B1;ID NAME 1 Dave2 bl3 Big Bird4 exc 9 Huaining1. INNER JOIN (join)Join defaults to INNER join.The following 3 ways of writing the

1:mysql generally use the auto-grow type, when the table is created as long as the primary key of the specified table is auto increment, when inserting a record, no need to specify the primary key value of the record, MySQL will automatically grow;

Oracle Database View Execution planOracle-based application system many performance problems are caused by poor application SQL performance, so, SQL performance optimization is very important, analysis and optimization of SQL performance we

[Date: 2011-08-05]Source: Linux Community wangshengfeng1986211[Font: Big Small]2010-07-01 15:031. SET AUTOTRACE on EXPLAIN(Set AUTOT on exp)The Sqlplus command, which displays the execution plan while executing the SQL statement, sets exp (lain) to

[Date: 2014-11-21]Source: Linux Community Stevendbaguo[Font: Big Small]Starting with Oracle Database 10g, Oracle has created a scheduled task named Gather_stats_job after the library is built to automatically collect CBO statistics. This automatic

ORA-01722: Invalid number.In general, it is because the attempt to convert a string to a number fails because the string may contain characters that are not numeric.There are two possible causes for this problem:1) The SQL statement executed

Concept:1. directory structure of similar books2 . Oracle 's Index object, an optional object associated with the table, to increase The speed of SQL query statements3. Theindex directly points to the location of the row containing the queried

Concept:A sequence, in Oracle, is an object that is used to provide an ordered column of data that does not duplicate the value of the ordered data column. 1. sequence can automatically generate unique values2. is an object that can be shared3. a

Concept:View: The so-called view is to extract one or more tables of data to generate a map, management view can also achieve the effect of the original table, convenient data management and security operations.A view is actually a query SQL

Scenario: Encountered 100 million data volume data needs to do some statistical analysis according to the user name, want to do some aggregation calculation is basically not possible, so the intention is to create a partition according to the date

Operate http://huangsir007.blog.51cto.com/6159353/1854392 based on the previous articleOracle User sys, System differences:SYS user is superuser, has the highest privileges, has the SYSDBA role, has the CREATE DATABASE permissionThe system user is a

Corrected a script, encountered some of the differences between the two databases, recorded:Trigger: Difference Mysql ORACLE Description Create statements different Create Trigger ' AA ' before INSERT

There are two methods: SCN and time stamp two methods of recovery.I. Recovering deleted and committed data through the SCN1. Obtain the SCN number of the current databaseSelect Current_scn from V$database; (Switch to SYS user or System user