Oracle

DescriptionOracle Database ServerOperating system: CentOSip:192.168.0.198Port: 1521Sid:orclOracle Database version: ORACLE11GR2Specific operation:1. root User Login ServerMkdir-p/backup/oracledata #新建Oracle数据库备份目录Chown-r

Oracle database language types generally fall into five major types1 DDL (data definition language) Definition languageCREATE TABLE: Creating tablesALTER TABLE: Modify tablesdrop TABLE: Delete tables (delete the table as a whole, the table structure

Chinese Medicine Department inquires the Discharge patient Information Report the following errorThen see the SQL for the interfaceThen run the code inside the Plsql,ErrorProcessing method:1. Determine the location of the errorNow determine where

1 Create or Replace functionMca_detail_material_val (P_material_codeVARCHAR2,--actual Parameters2P_material_nameVARCHAR2,3P_mca_noVARCHAR24 ) 5 RETURN varchar2 as6 7 --Item code/name

In general, the Oracle database language can be divided into the following 5 major categories:1.DML Data manipulation language (data mannipulation Language): Querying, manipulating datasheet rows SELECT: Retrieving database table or view

Because of certain requirements, the production environment needs to have both database server and client installed on the same machine because Plsql does not have 64-bit clients. Unable to read the 64-bit database Oci.dll file, so need a 32-bit

1 Nested Loops Join--we use the set Statistics_level=all to observe the execution plan of the following table join statement:--T2 table is accessed 100 times (drive Table access 1 times, drive Table Access 100 times)--This set Linesize 1000 has an

Service-side Character Set modification 1, confirming the service-side character set1 Select userenv ('language' from dual;2. Modify the service-side character set to first log in to Oracle as a DBA. Run commands directly under the Windows system

1.SQL is divided into 5 major categories:DDL: Data Definition languageDCL: Data Control LanguageDML: Data Manipulation languageDTL: Data Transaction languageDQL: Data Query Language2.DDL (data definition Language): Create,drop,alter,rename toThere

database table structure:Insert the SQL statement: InsertId="Insert"ParameterType="com. Structure "> INSERT intoSTRUCTURE (ID, structurename, parentid, Structuretype, description, DeptID, Propertycompanyid, Sort,

How Oracle 11g completely uninstallsMethod/Step 1:Disable Oracle Services: Enter Computer Management, in the service, find all services at the beginning of Oracle, right-click to select StopMethod/Step 2:In the Start menu, locate Oracle->universal

The following tests are based on the EMP table under the Scott userFirst Test with a while loop and insert 999 data into the EMP table1 Declare2I Emp.empno%Type:=1;3 begin4 whileI +5 Loop6 Insert intoEMP (empno,ename,sal)Values(

--Create a userCreate user xiaoyi identified by root;--Modify the user's passwordAlter user xiaoyi identified by root;--View the table space owned by the userSELECT * from Dba_users t where t.username= ' Xiaoyi ';--Create a table spaceCreate

1- save Excel file as (text file (Tab delimited) (*.txt))2- Open PL/SQL Create temp table jh_info, Open tool - text Importer3- Open the file location in the upper left corner, select the prepared txt file, and open it. 4- Switch to Oracle data,

This is the first to meet the entire library is normal, but a table query error situationA table data can be checked, but a sort of check on the errorSELECT * from Acct_daily_bak;SELECT * from Acct_daily_bak ORDER by open_time Desc;Ora-01578:oracle

Oracle Recovery method for accidental deletion of dataLearning the database, we are just learning attitude, consider how to use the database command statements, did not think about the work, if the wrong operation, can lead to irreparable loss. When

Permissions:Create sessionCREATE tableUnlimited tablespaceConnectResourceDbaCases:#sqlplus/nologSql> Conn/as sysdba;Sql>create user username identified by passwordSql> Grant DBA to username;Sql> Conn Username/passwordSql> select * from

There is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.Workaround:1) Insert a row, and then rollback will produce segment.The method is to insert data into the empty table and then delete it,

With...as ... Statement is used to define a query statement as a name and can then be referenced in subsequent query blocks. The query block with definition has a high priority when the query name repeats with the existing table name. The WITH

Set the script for automatic archiving and Archiving Root User Mkdir-p/home/temp Cd temp Mkdir bin log tmp Chown-R oracle: oinstall/home/temp/bin Chown-R oracle: oinstall/home/temp/log Chown-R oracle: oinstall/home/temp/tmp