Oracle

Oracle hard parsing and soft parsing are the problems we often encounter, what will produce hard parsing, what happens to soft parsing, and how to avoid hard parsing. The following description gives the The emergence of soft and hard parsing, as

The new technology is too fast, the old machine wants to install an operating system, in the development department is only the Windows 2008 installation disk, installation of Windows 2008 is very fast, and not the personnel settings.However, when

The One   concept cursor is a memory workspace for SQL, defined by the system or user as a variable. The role of a cursor is to temporarily store blocks of data that are extracted from the database. In some cases, the data needs to be transferred

Usage of instr in Oracle:The format of the InStr method isINSTR (The source string, the string to find, starting with the first few characters, to find the ordinal number of matches)Returns the location found, or 0 if it is not found.For example:

ORA-00904 Invalid identifierThe reason for this error is most likely that one of the field names in your SQL statement is incorrectly written, or the table name is wrong, and so on, in short, it is very complicated! The field name does not

Solutions to Oracle Exp-00003 problems the day before yesterday in the Guide data occurred in the Exp-00003 error, before also encountered such a problem, the solution is to the database server on the computer, the problem solved, but this is from

/** June 14, 2018 Chaozhou Oracel Statistics 2017 electricity consumption, by industry classification of the first ten */ Select * from (select T.YHBH user number, T.YHMC User name, t.jldbh metering point number, (select M.dmbmmc from

First, download: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlThis is the homepage of the Oracle Instant client download, and there are many versions available for download.But pay attention to third-party

You might ask, why is there a connection between Oracle and HDFS, the storage systems that belong to different scenarios? Indeed, from the technical point of view, they are really unrelated, but using the "holistic learning " idea, out of the

First, the Oracle Installation Guide:Oracle does not charge for the use of, if you use in the work, you must remember to pay, do not make mistakes in payment.Oracle's content is divided into two parts: the development section, the Management Section,

Create tablespace liangtbs datafile '/home/oradata/lgjdb/liangtbs01.dbf ' size 50m autoextend on;create tablespace Testtbs datafile '/home/oradata/lgjdb/testtbs01.dbf ' size 50m autoextend on;CREATE USER Junuser identified by "Oracle"DEFAULT

A lot of friends have encountered in the operation of the database mistakenly delete some important data, if the database is not backed up and the data is very important how to do to retrieve the data mistakenly deleted? I am here to introduce

Oracle's import tool, very fast, here to remember the use of external tables, usually external tables to remember too much syntax for example:CREATE TABLE PROD_MASTER ( "EMPNO" NUMBER, "ENAME" VARCHAR2(50), "HIREDATE" DATE, "DEPTNO"

OpenJDK is sun at the end of 2006 to open up Java project, where the "open source" is the usual sense of open source, that is, the source code can be reused, such as IcedTea, ultraviolet are derived from the openjdk source of the distribution

Oracle Password expiration settings and password change issuesStudied: https://jingyan.baidu.com/article/ce09321b5608612bff858ff3.htmlSqlplus/as Sysdbaselect * from Dba_profiles s where s.profile= ' DEFAULT ' and resource_name= ' password_life_time

1 using the source installationUse the following command to install, just some time, it will download a lot of files, and you want to make sure that your network environment is good:sudo add-apt-repository ppa:webupd8team/javasudo apt-get updatesudo

To create the user's syntax:Create user username identified by password default Tablespace table space quota size on table space;Note: While user names are written in lowercase when they are created, they are capitalized when stored in a data

Original: http://www.talkwithtrend.com/Article/178339In the process of database construction, high availability is one of the most important concerns in the construction of data Center database in every enterprise, which is directly related to

好久没写东西了，今天写一篇凑个数吧，来公司一年多了，感觉自己到了一个小瓶颈期了。 以前每天很多新东西，都是忙着学，感觉没时间写博客总结一下，大部分都是写笔记，现在又是没东西可以写，每天干着95%都是重复的工作，大部分时间在运维，但我内心是把自己当做dba的，毕竟当初老大把我从java开发拉倒系统组^_^ 上次一个技术把表中的数据删除，这次是另一个技术把正确的包给覆盖了，我给恢复了，哈哈哈---有用的话看一下Reference Blog: 6761458虽然包恢复原理一样，但是操作差异一点，

Today, when using Navicat to connect Oracle, I faint some pits, and I hereby record it!Landlord is a 64-bit WIN10 system, has just begun to configure 32-bit OCI. After configuring the connection or the prompt "Connot load OCI dll,87:instant Client