Oracle

By operating an Oracle database using OLE DB, you successfully implement a BLOB-type field on a picture, but sometimes a ORA-01036 error occurs, and the query is illegal variable name/number, I don't know who can explain the meaning of illegal

1. Install JRE TAR-ZXVF jdk-7u25-linux-x64.gz MV jdk1.7.0_25//usr/local/java Vim/etc/profile Export Java_home=/usr/local/java Export path= $PATH:/usr/local/java/bin Export class_path=.: $JAVA _home/lib/dt.jar: $

Late last month: Select Last_day (Add_months (Sysdate,-1)) from dual;Last second of the month: select Trunc (Add_months (sysdate,1), ' mm ')-1/24/60/60 from dualWeek Monday Date: Select Trunc (sysdate, ' Day ') +1 from dual Number of days since the

Oracle Database Tutorial BackupI copy the database folders in "D:oracleoradata" and the Database folders in "D:oracleadmin" from Machine A to the corresponding folder in Machine B, and then change the Listener.ora, Tnsnames.ora filesListener.ora

Oracle creates stored procedures in two ways Create or replace procedure Getdefault isBegin Execute immediate ' Create global temporary table deftemp (PID varchar2 (5)) on commit delete rows ';SELECT * from Deftemp; End Method Two/*Let's

ORACLE 11G when exported with export, empty tables cannot be exported. There is a new feature in 11G that does not allocate segment when there is no data in the table to save space Workaround: 1, insert a line, and then rollback will produce

This requires the ability to query a batch of records and simultaneously modify the update status of the batch so that the data being updated is fetched by another server Add row level lock, query to record and then traverse result set update state?

Select Userenv (' language ') from dual; Query results: Simplified Chinese_china. Al32utf8 --Modify the Oracle Database Tutorial character set: (In SQL Plus) Sql> Conn/as sysdba; sql> shutdown immediate; Database closed. Database dismounted.

Sql> set timing on; Set display ' Used Time: XXXX ' Sql> set Autotrace on-; setting allows profiling of executed SQL Sql> set trimout on; Remove the trailing spaces for each line of the standard output by default off Sql> set Trimspool on; Remove

We can use the following statement to view the path saved by the list of servers The code is as follows Copy Code Ls-l/ETC/YUM.REPOS.D If the return result is that the folder is empty, then the next

First, the introductionNever thought that deleting data from a table would be a problem. However, when the amount of data in a table is very large, deleting data can be a big problem. This only describes the resolution process and does not involve

New userLog in with system userCREATE USER by TEST1;Create User: Creates a command, followed by a user name;Identified by: followed by password; Query usersSELECT * from(Query All users, show details)SELECT * from(Query All users, show

First, install the Oracle databaseStep: Reprint a very good document: Http://www.linuxidc.com/Linux/2015-02/113222.htmNote: The installation will check dependencies, some may not find, MO Panic, rpm QA | grep package name, if already exist, install

SQL is the language used to access the ORACLE Database. PL/SQL expands and enhances SQL functions, and introduces stronger program logic.PL/SQL supports DML commands and SQL transaction control statements. DDL is not supported in PL/SQL, which means

A customer's exadata environment causes database downtime due to a large number of hardware faults. After analysis, it is confirmed that a disk of a cell node has an exception, leading to someAfter the disk of the cell node is offline, the asm

Assume that the original host cannot be started at all (such as hardware faults), you can only find the parameter files used by the database in the storage ASM:[Grid @ lunar5 ~] $ Ss SQL * Plus: Release 11.2.0.4.0 Production on Mon Feb 15 21:48:15 20

Most Web applications today require at least some basic security policy. For example, websites that provide password-protected content, websites with only the backend of administrators, blogs and personal magazines, e-commerce websites, and

Anyone who has used Oracle knows that Oracle has a data type named VARCHAR2, which is used to indicate a string with an indefinite length. VARCHAR2 is also recommended by Oracle. However, VARCHAR2 has a problem: a maximum of 4000 characters can be