Oracle

SELECT INSTR (' aaac ', ' AAC ') from DUAL; --2select SUBSTR (' ABC ', 2, 1) from DUAL; --bselect ' AA ' | | CHR (ASCII (' B ') + 1) from DUAL; --Aacselect * from V$version; SELECT * FROM product_component_version;--query table space Select

The database version is oracle10g In a database server operation: will need to transfer the database a cold backup, cold backup, I am very simple. Start-to-run: / as // log in to the database with DBA Authority Sqlplus > shutdown

1.castCAST (' Other ' as NVARCHAR2 (30))2.forDeclareV_guidChar( +); Channelidstrsvarchar2(4000):="';beginV_guid:=Sys_guid (); --Delete temp_stocktransdetail; forCinch(SelectChannelid fromChannelwhereRowNum9) Loop Channelidstrs:=Channelidstrs||','

Always wanted to learn Oracle but didn't make up your mind. This time borrowed a book, must learn Oracle.Currently learning Oracle 11g from getting started to mastering Oracle TechnologyThe basic theory of relational databaseData Model :

Management of Oracle UsersCreate userOverview: In Oracle, to create a new user using the Create USER statement, you typically have DBA (database administrator) permissions to use.Create user username identified by password; (Oracle has a problem,

Oracle minus KeywordsThe minus keyword in sqlThere is a minus keyword in SQL that uses two SQL statements to find out the results of the first SQL statement, and then see if the results are in the results of the second SQL statement. If so, the

If the test List has 3 table field IDs, the name address is as follows:ID Name Address1 Little Two Beijing2 Little Two Tokyo3 Little Two Beijing4 Xiao Liu NanjingIf you want to identify duplicate data for name and address.SELECT * FROM (select

The Oracle installation directory is deleted manually, note that because the installation failed, automatic unloading is not to delete clean, be sure to do it yourself. Also delete the/programfiles/oracle. At this point, only the Oracle entity on

For unknown processes to crs_stop-f the process nameStart againCRS failed to start Crs_start-all Crs-0184:cannot communicate with the CRS daemon.Because Crs_start is an application-level directive, it fails when it starts CRS[Email protected] ~]$

View the current user's table space[SQL]View Plaincopy Select Username,default_tablespace from user_users; Modify the user default table space[SQL]View Plaincopy Alter user username default tablespace new table space;

CREATE TABLE Space[SQL]View Plaincopy Create tablespace ' ' datafile ' ' Size 500M Default storage (Initial 200m Next 50m Minextents 20 Maxextents 500) Online Example:[SQL]View Plaincopy Create

Risks of incorrect selection of Oracle Database Design Field Types A hidden danger of inaccurate data types. The following constructs a table storage date field, one storage varchar2, and one storage date for a test. I have also written two blogs

DATAGUARD add and modify REDOLOG size, dataguardredolog Dg online log group size change environment (single instance, Centos 6.5X64, oracle 10.2.0.5, filesystem storage) redo online LOGselect * from v $ logfile where type = 'standby '; # The query

Oracle users, oracle users Create user ng_zj identified by ng_zjDefault tablespace tbs_testTemporary tablespace tbs_test_tmp;Grant connect to ng_zj;Grant resource to ng_zj;Grant create table to ng_zj;Grant create sequence to ng_zj;Grant create

PLSQL _ How to determine how long it takes to insert a long script into 0.1 billion pieces of data v $ SQL/v $ sqltext/v $ sqlarea/v $ SQL _plan (CASE) (monitor SQL efficiency), sqlarea 2014-08-27 BaoXinjian I. Summary When executing a PLSQL

Oracle homepage on the Web The code in this example only describes how to use common Oracle paging methods on the Web. It does not involve MVC, code optimization, and so on. For more information, see. Zookeeper ---------------------------------------

Oracle Database optimization and optimization steps Identify the current status of the system System server model CPU speed and quantity Memory size I/O device status Network Conditions Number of system users and number of concurrent

ORACLEPSU upgrade SummaryFirst, go to psu. first, let's take a look at readme.html. From this, we can know the detailed upgrade steps that have been rolled back. And avoids many pitfalls.Before executing the PSU, you must first confirm the version

Detailed process of user interaction with OracleDB Interaction with Oracle DB The following example describes the Oracle database operations at the most basic level. This example shows an Oracle DB configuration in which the user and the

Connection sequence in the WHERE clause of Oracle performance optimization learning notes ORACLE uses the bottom-up sequence to parse the WHERE clause. According to this principle, the join between tables must be written before other WHERE