Oracle

--date converted to stringSELECT Date_hire, To_char (Date_hire, ' Month dd yyyy ') HIREFrom Employee_pay_tbl;SELECT Employee_tbl. emp_id,Employee_tbl. Last_Name,Employee_pay_tbl. POSITIONFrom Employee_tbl, EMPLOYEE_PAY_TBLWHERE Employee_tbl. emp_id =

Oracle's use of the SUBSTR functionGets a string that specifies the starting position and length of the string substr (string, start_position,[length] )Such as:SUBSTR ('This is a test', 6, 2) wouldreturn ' is'SUBSTR ('This is a test', 6) wouldreturn 

--Create Tablecreate table Technologycompany (ID VARCHAR2 (+) default sys_guid () not NULL, Flowid VARCHAR2 ( (), Conpanyid number, iscommunication VARCHAR2 (Ten)) tablespace USERS pctfree Initrans 1 Maxtrans 255 Storag E (initial 64K minextents 1

1. mysql Paging query(1) Keyword: LIMIT beginindex, MaxRow(2) Example:The limit clause can be used to limit the amount of data returned by the SELECT statement, which has one or two parameters. If two arguments are given, the first parameter

Build table:Create TableA (IDvarchar( -), namevarchar( -));Create TableB (Namevarchar( -), agevarchar( -));Create TableC (Namevarchar( -), Deptvarchar( -));To construct the data:Select * from A; Select * from b; Select * from C;A, B Association

Users who are always concerned about Oracle database know that Oracle Performance optimization guarantees the robustness of Oracle database. Here are two principles to note.Principle One: Note the connection order in the WHERE clause:Oracle uses a

ASM Installation of Oracle InstallationThe last time we talked about building an Oracle environment, let's look at the installation of ASM automated storage Management in Oracle and the creation of ASM disks today.ASM: Automated Storage Management

Problem:Find out the names, jobs, and salaries of employees with lower wages in the EMP table than any salesperson ("salesman").Analysis:Salespeople have a lot of records in the EMP table, everyone's salary is not equal, if the return "than any

First, table partition　　(i) Classification of table partitions1. Range partition (range)2. Hash partition (hash)3. List partition4. Compound partition: Range-Hash (range-hash), Range-list (range-list)　　(b) Scope Zoning:A range partition is a

Problem Description:Implementation of Oracle automated backup scripts.Error tip 1:Message file RMAN.MSB not foundVerify that Oracle_home is set properly。。。。。。Cause of Error:Automatic execution does not recognize the corresponding command and

In Oracle, sequence is the serial number, which automatically increases each time it is taken. Sequence is not related to tables. 1. Create SequenceFirst, create sequence or create any sequence permissions.Create the following statement: CREATE

(Modified) oracle11g listens to the configuration of multiple hosts and uses pl/SQL to connect to and operate multiple databases. Many friends in the development project do not use a single database, but have a single host as the database server for

Troubleshooting of SQL plus logon failures caused by su switching in OracleProblem description:The oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment suddenly fails to

Create an oracle database, user, tablespace, and role permission setting script/* Divided into four steps *//* Step 2: create a temporary tablespace */Create temporary tablespace contract_tempTempfile 'd: \ oradata \ contract_temp.dbf'Size 50

How to detach an oracle11g Client 1. Disable oracle service: Go to computer management. In the service, find all services starting with oracle, right-click and choose stop. 2. In the Start Menu, find the Universal Installer, run Oracle Universal

Common Oracle functions-character and mathematical functions Various functions are often used in the development and use of oracle. This chapter summarizes simple strings and mathematical functions, which will be convenient to use in the future, it

Oracle & #160; 11 & #160; password set to never expireFollow these steps:1. Check the user's proifle, which is generally default:SQL> SELECT username, PROFILE FROM dba_users;2. view the password validity period settings of the specified profile

Trigger 2 (learning notes), trigger learning notesDML triggers (statement triggers) Triggered by a DML statement. An INSERT, UPDATE, or DELETE operation is triggered when the user executes the INSERT, UPDATE, and DELETE operations. Example 1,New

Use cursor to convert the format of specified fields in the data table in Oracle (pinyin to numbers) Application Scenario: Convert [sannanyinv] to [3 male and 1 female] In the NNDP field of the data table TB_USER. Main Script: A cursor script +

Oracle lock 1: DML lockDML lock, also known as data lock, is used to ensure data integrity when multiple users operate on data. DML lock prevents conflicting DML and DDL operations at the same time. DML Locks include Row Locks (TX) and Table Locks