Oracle

Because of the problem of our initial data, we need batch import, we have created Oracle's MD5 algorithm to encrypt the username and password;Simple two-step operation:1. Write function:Create or Replace function "MD52" (passwd in VARCHAR2) return

Because a new 13T disk group is being added, it is decided to process it through ASMCA.As a result of the input ASMCA, there was no response, both before and after two days.On the third day, IBM's storage engineer has hung up on the heart of Mpio,

Today, using Navicat to connect to the Oracle database, the following error was reported: "ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK"From this error, it can be known that the client does not support the server-side

1. Preparatory workThe Oracle 11g R2 version of the database is installedCopy the ORACLE driver Ojdbc6.jar from the $oracle_home/jdbc/lib/of the database serverThe database has a table students, with 2 field IDs and a name2. Start Oracle Test1. Open

Tag: DDR Oracle command file recommended key load ISP cannotFirst, the basic conceptORACLE11GR2 RAC began to introduce the scan concept, usually through a DNS server or GNS server to resolve the scan, you can also use the/etc/hosts file to parse

One, table space 1.1 create TABLE space--Problem: Create a tablespace named HP, specifying a data file of hp.dbf, and a size of 10m.' C:\app\hp\hp.dbf ' size 10Mautoextend on next 5mmaxsize unlimited;1.2 Deleting a table spaceDrop tablespace hp;1.3

------------------ The reasons for the slow query are many, and the following are common: 1, no index or no index (this is the most common problem of slow query, is the defect of program design)The 2,i/o throughput is small, creating a

Oracle Kanji Pinyin (get full spell/pinyin initials/Pinyin intercept, etc.)The effect is as follows: Oracle character Set GBK no problem, UTF-8 needs to be modifiedSQL code--oracle Kanji to Pinyin package--1. Get full spellSELECT gethzpy.

First of all, of course, create the type in OracleCREATE OR REPLACE is OBJECT ( number, bid_price number, bid_publish_date DATE, bid_award_flag VARCHAR2(ten));Re-establish reference typeCREATE OR REPLACE is TABLE of

Stored procedures are not used in small companies, but if the business is complex or the performance requirements are more stringent when the stored procedures come in handy, some of the earlier version of Ibatis does not seem to support stored

--1, use month as conditional filter (to_char function and extract function)SELECT * from Test_date where To_char (DQSJ, ' mm ') like '%07% ';SELECT * from Test_date where extract (month from DQSJ) = 6;--2, get view nameSELECT * from User_views;--3,

[[Email protected] ~]$ DateTue Oct 14:20:56 CST 2017[Email protected] ~]$ Cat/etc/sysconfig/clock# The time zone of the system is defined by the contents of/etc/localtime.# This file was only for evaluation by System-config-date, does not rely in

--1) SQL statement for querying and locating database problems--oracle Common Performance Monitoring SQL statements. sql--1 Query Lock table informationSelect VP. SPID,Vs. P1,Vs. P1raw,Vs. P2,Vs. EVENT,Vsql. Sql_text,Vsql. Sql_fulltext,Vsql.

-Department: Department number, department name, address; --Employees: Employee number, employee name, job title, management number, entry date, salary, bonus, department number; CREATE TABLE Dept ( deptno INT PRIMARY key,dname

Environment: Oracle 11gThe existing A and B tables are associated with the A01 field, and the data in table A is not available in B. SQL as followsSelect Count (1 from (select A.*, (selectCount(1) from where b.a01=as fromwhere flag=0 Because flag

-----------------------------------Basic Data Type-----------------------------------1. Numeric typeNumber (P,s)The parameter P represents precision, and the parameter S represents the scale range.Precision refers to the number of all valid digits

First, the cause of the problem:A new feature in 11G that does not allocate segment when the table has no data to save space1, insert a row, and then rollback will produce segment. The method is to insert data into the empty table and then delete it,

Explain the SQL syntax example of the most efficient paging query in ORACLE, oraclesql -- 1: no order by statement. (Most efficient) -- (After testing, this method has the lowest cost. Only one layer is nested, and the speed is the fastest! Even if

Cmd: How to import and export oracle remote and local databases. cmd: How to import and export oracle Cmd Import and Export oracle Database Open the cmd window and enter the following command Supplement: I deleted my oracle database a few days ago

Oracle dbca times: ORA-12547: TNS: lost contact error resolution, dbcaora-12547 Preface Recently encountered a problem in the work, the error is Oracle dbca reported error: ORA-12547: TNS: lost contact, by looking for relevant information finally