Oracle

First, the failure to comeA day at noon, the unexpected interruption of power, the computer room ups due to heavy load and did not take over power supply, all servers restarted ...When all servers are restarted, the device and the business operation

Row_number () over (partition by col1 ORDER by col2)The result grouping number is returned, the results are grouped in the Col1 field, each group is sorted by Col2, and the record numbers are sorted by these groupings, and each group starts with 1

1. Right-click the computer, select Properties, add environment variable Nls_lang:simplified Chinese_china. ZHS16GBK2. Go to the registry, click HKEY_LOCAL_MACHINE-->software-oracle-->key_oradb11g_home1, locate Nls_lang, set the value to: simplified

---restore content starts---Import Export (dos window) Database export:1 Export the database test fully exported to D:\daochu.dmpEXP username/password @orcl file=d:\daochu.dmp full=y2 Exporting the system user in the database to the SYS user's

First, oralce the boot sequence:1. Start the listener first (corresponding to port 1521):[] #lsnrctl start2. Start Oracle instance:[] #sqlplus/as sysdba (carriage return)Sql>startup　　　　--Starts the default DB instance in the environment variable

Oracle's flash-back technology is a data recovery technology that only restores user logic errors ,The flashback is for committing a commit transaction, no committed transaction, using rollback1. Flash back version Query Flashback Version QueryThe

Oracle System usersSys,system, Sysman, Scott.Log on using System user[Username/password] [@server] [As Sysdba|sysoper]eg:system/123456 @orcl as SysdbaTo view the currently logged in User:Show userViewing users in a data dictionarySelect username

OracleSynonymsOracle synonym for (synonyms) similar to view features, but more powerful. Most database objects in an Oracle database, such as tables, views, materialized views, sequences, functions, stored procedures, packages, synonyms, and so on,

Select Max(Sun) Sun,Max(Mon) Mon,Max(Tue) Tue,Max(Wed) Wed,Max(Thu) Thu,Max(Fri) Fri,Max(Sat) SAT from(SelectDecode (D,1, DD) Sun, decode (d,2, DD) Mon, decode (d,3, DD) Tue, decode (D,4, DD) Wed, decode (d,5, DD) Thu, decode (d,6, DD) Fri, decode

Today the system officially on the line, busy three months finally some harvest. Special trip to take photos, various opening ceremonies ... Last night, the bus to the station 5:30 this morning.Tried a few Oracle tools, the native SQL developer

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

1. Open CMD,CD to the Oracle directory, such as D:\app\xty\product\11.2.0\dbhome_1\RDBMS\ADMIN2.sqlplus username/Password @ instance name, connect to database3. Execute @awrrpt. SQL carriage returnFirst step input type: HTMLEnter the number of days

stored procedure Create OR REPLACE PROCEDURE ADMIN. Insert_obj (objefirt_parms in NVARCHAR2, objedatt_parms in NVARCHAR2, objesect_parms in NVARCHAR2, objecontent_parms in NVARCHAR2, isrelease_parms in INTEGER, objecode_parms in NVAR CHAR2, tags_

Helloworld.sqlSet Serveroutput onDeclare--Description sectionBegin--ProgramDbms_output.put_line (' Hello world ');End/If statement. sql--Determine the number of user inputSet Serveroutput on--Receive keyboard input--num: Address value, at which the

1. Data typeVARCHAR2 ()Number ()DATEClobBlob2. Copy table: CREATE TABLE TableName as SELECT * from emp3. New column: ALTER table name Add (field Name field type default defaults);4. Modify columns: ALTER table name MODIFY (field Name field type

1:root User execution: Df-k/tmpFree space is greater than 400M can2:cat/etc/issue command to view Linux versions3:uname-r command to view the kernel4: Check the relevant packagesThe command is: RPM-Q related package5: Build two

Next_day () Gets the date of the next one days of the current date, from the literal meaning easily understood to be the date of the following day to get the current date. For example: Select Next_day (to_date (' 20160330 ', ' YYYYMMDD '), 1) from

First, the archived switch1. Check if the archive is open:sql> archive log list;2. Set the archive pathSql> alter system set log_archive_dest_1= ' LOCATION=D:\ARCH2 ';3. Open Archivesql> shutdown immediate; --Close the databasesql> startup Mount;

In Oracle, there are three kinds of equals: <>,!=,^=For example:SELECT * FROM test where name<> ' xn '. The returned result is a record where name is not xn and name is not empty. But this is not the same as what we want to get, because our goal is

What is the cause of the large amount of empty data that sometimes occurs when you use the left association?This is because the field in the primary table is empty until the primary table is associated with another table, and then the field