Oracle

Because the computer does not have the Oracle server side installed, so after installing Plsql still cannot connect Oracle database, download an Oracle Client tool on the Internet, is green free install, decompression is good. I put my cloud on the

"Shared sql:1. Unified writing Style2. Using bound variables"To find the SQL statement that is not shared:Look for SQL statements with smaller executions in v$sql to see if these SQL statements are executed frequently.Select Sql_fulltext from V$sql

[Email protected] ~]# su-oracle[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.1.0 Production on Tue Dec 15 09:23:28 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0

Because of the use of a secure platform. Does this platform actually support services in Oracle? "." And that's because Oracle was installed in the domain at that point. The original thought was to modify the service name. A lot more, the last

Today you need to write a oracle10g backup script on an old Windows2003.IP1 is a Windows2003 system with a 10G database installed (D:dbbackup is the database backup directory), IP2 to a normal Windows2003 system without installation (D:DBBACKUP2 is

ORACLE10G The database host is already connected to the storage using RDAC, planning to add additional capacity IBMV Series storage (requires the use of Dm-multipath Multi-path software), can multiple multipath software coexist? Does the SD device

CREATE OR REPLACE FUNCTION f_pinyin (p_name in VARCHAR2) RETURN VARCHAR2 asV_compare VARCHAR2 (100);V_return VARCHAR2 (4000);FUNCTION F_nlssort (P_word in VARCHAR2) RETURN VARCHAR2 asBEGINRETURN nlssort (P_word, ' nls_sort=schinese_pinyin_m

Use scenario: Convert a column value to a comma-delimited string Example: For example, query all of the table space below, now to get all the table space with a comma-delimited string (such as the time of Rman duplicate skip tablespace) SQL>Select

Create a table:Cteate table name (column 1 type,column 2 type);view table Structure DESC table nameAdd a field ALTER TABLE name Add (column type);Modify the field type ALTER TABLE name modify (column type);Delete a field ALTER TABLE name drop column

Experiment two: Data manipulationExperimental Hours:4 hoursExperiment Type: Comprehensive typeExperimental requirements: CompulsoryFirst, the purpose of the experiment1, master SQL data query statement;2, master the use of SQL aggregation function.3,

First of all, the Oracle 9i added a new system comes with the sorting function1. Sort by first letterNew in oracle9i, according to pinyin, radicals, stroke sorting function. Setting the Nls_sort valueSchinese_radical_m Sort by radical (first order),

1. Grammatical differencesThe definition of the variable type, the position in the out, the position of the variable definition, the position of the cursor, and the position of the exception;2, MySQL does not return keyword, using leave label way to

I. Configure the Yum source and install the readline* configuration local yum 1, Mount disc Mount/dev/cdrom/mnt/media 2, create a new local Yun source configuration file vi/etc/ Yum.repos.d/local.repo Add the

Oracle uses SqlplusInstallation, one-click installation, very simple. The installation process, be sure to remember the passwordTo connect to the local server, you can open cmd directly:Can be directly without landing, if login need to enter the

Oracle Case When usage introduction1. Case-When expressions have two forms--Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' END --case search function CaseWhen sex = ' 1 ' Then ' man ' When sex =

Oracle Database uses sqlplus connection error and direction key garbled solution, oraclesqlplus Connection ErrorAfter the installation, I log on to the enterprise background (http: // ubuntu: 1158/em) and report an error when connecting to oracle

Different showparameterpfile results when started with pfile or spfile Normal start: SQL> show parameter pfileNAME type value =----------- startup spfile string/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilesingle1.or a start SQL> startup nomount

Oggdiredoes not purgelogtable OGG Director does not purge log table. Source: OGG Director does not Purge Log Table (Document ID 1637931.1) Applicable:Management Pack for Oracle GoldenGate-Version 12.1.2.0.1 and laterInformation in this document

Simple usage of substr and instr functions in Oracle, oraclesubstrinstr Simple usage of the substr function in Oracle Substr (string, truncation start position, truncation length) // returns the truncated word Substr ('Hello world',) // return 'H' *

Explain how to switch between the three modes of Oracle dg and oracledg Oracle dg Switching ==========================================1 maximum performance mode maximum performance ------ default