Oracle

I. Software PreparationAddress: Oracle websiteinstallation package: Because of personal learning, so install the server side can be, do not need the client.A total of two compressed files, extracted together to extract to a folder. I use: win32_11gr2

One, Oracle connection type☆ Description: According to their own understanding of the type of classification, not the official definition.1. Internal connection① equivalent Connection② Non-equivalent connection③ Natural Connection2. External

If the database date format is set to Dd-mon-yy, then this YY specifically indicates that year, for example: 12-12-13 the last 13 is 2013 or 1913 or other? This is related to the current date, YY represents 2 years as the format of the year,

/* divided into four steps *//* 1th step: Create a temporary tablespace */create temporary tablespace user_temp tempfile ' D:\oracle\oradata\Oracle9i\user_ TEMP.DBF '//Temp tablespace storage location size 50m //Table space Initial size

Oracle 11g Required Background processes: Pmon, dbwn, LGWR, CKPT, Smon, VktmPmon: Process Monitoring process1. The first background process initiated by an instance2, monitoring the responsibilities of other Oracle background processes, restart

CREATE OR REPLACE FUNCTIONLong_to_char (In_rowid rowid,in_ownervarchar, In_table_namevarchar, In_columnvarchar2)RETURN varchar asTEXT_C1varchar2(32767); Sql_curvarchar2( -);--set serveroutput on size 10000000000;--beginDbms_output. ENABLE

1: Querying the database for table space usageSELECTF.tablespace_name, (T.total_space-f.free_space) "Used (MB)", F.free_space "free (MB)", T.total_space "Total (MB)", (ROUND((F.free_space/T.total_space)* -))|| '% 'Per_free

Oracle's simplest auto-start with systemAs the saying goes, the user is God, they sometimes ask a question is very simple, just need a word, a minute to finish, but to our DBA, it may be at least half an hour or even half a month to meet his

Archive: The redo log is archived, re-written to the new redo log file, the process of log switching is called log swith, the switch will produce checkpoints. All the data before the checkpoint has been archived.There are at least two redo log

How do I create an oracle tablespace?1. If it is opened in a tool such as PL/SQL, directly modify the following code [Italic bold section] to execute2. Ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\", which is the path where you

EMP Employee table (EMPNO employee number/ename Employee Name/job work/mgr Superior number/hiredate Employment Date/sal Salary/comm Commission/deptno department number)Dept Department Table (DEPTNO department number/dname department name/loc

I. GENERAL EnquirySELECT Total.name Tablespacename,Free_space,(Total_space-free_space) Used_space,Total_spaceFrom (select Tablespace_name, sum (bytes/1024/1024) free_spaceFrom Sys.dba_free_spaceGroup by Tablespace_name) free,(select B.name, sum

Verification Number: ^[0-9]*$To verify N-bit numbers: ^\d{n}$Verify that at least n digits: ^\d{n,}$Verify the number of m-n bits: ^\d{m,n}$Verify numbers starting with 0 and non 0: ^ (0|[ 1-9][0-9]*) $Verify that there is a positive real number

1.oracle exists the RowNum keyword, which is a pseudo-column (a special column that the system assigns on the result set)SELECT * from Oracletable WHERE rownum=1The above statement is capable of querying the first row of records.SELECT * from

PL/SQL-stored procedures and plsql stored procedures I. Stored Procedure Stored Procedure is a set of SQL statements for specific functions. Compiled statements are stored in the database. You can specify the name of the stored procedure and provide

Case of configuring static listening to resolve ORA-12514 errorsToday to do Linux under the DG configuration, encountered a phenomenon, tnsname. ora file configuration are normal, tnsping is also normal, listening is also normal, but still reported

Use the oracle10g official documentation to find the template of the listener file (listener. ora ). **************************************** ******************************** *************************************** Original Works are from the blog

Query and compile data dictionaries in oracle If you need to write a data dictionary during project delivery, you can use the following method to first run a line-by-line SQL statement. Select. TABLE_NAME AS table name,. COLUMN_NAME AS field name,

Common orcle statements -- 1. create temporary tablespace AUTOMONITORV5_temptempfile 'd: \ ORACLE \ KARL \ ORADATA \ ORCL \ automonitorv5_temp.dbf' size 50 m autoextend on next 50 m maxsize 10240 m extent management local; -- 2. create tablespace

To_date errors caused by different Oracle Language Environments I wrote a stored procedure and used a function in it. The function contains a to_date (dateFrom, 'yyyy/mm/dd'). After running the function, I found that the data was inserted