Oracle

This article transferred from: http://www.cnblogs.com/QDuck/archive/2010/08/11/1797225.html1. View All Users: SELECT * from Dba_users;   SELECT * from All_users; SELECT * from User_users;2. View user or role system permissions (System permissions

After the database is installed, enable the OEM.Emctl Start DbconsoleIf there is a problem with login Http://oracle11g:5500/em/consoleTry rebuilding an OEMFirst Emctl Stop DbconsoleEmca-deconfig Dbcontrol Db-repos DropEnter Oracle SID,SID must be

The Oracle startup process involves several modes, which involve different files, each state of the database doing different things, and these patterns are suitable for different maintenance needs, the main mode has three kinds: nomount, MOUNT, OPEN.

Today do bootstrap treeview, require input Node ID ID, parent node ID PID, textBut the SQL aliases executed are all uppercase, so the question of how to find the next ORCL alias is lowercaseThe code is as follows:Select t.fun_id "pid", T1. fun_id id,

--1 Import data to the database times the ora-01653:unable to extend table error, online Check the following reason is due to lack of table space;Querying table space Usage statementsSelect a.tablespace_name,a.bytes/1024/1024 Total, (a.bytes-b.bytes)

Environment:Oracle Standalone 11.2.0.4Parameter file location: >show parameter SPFileEdit parameter file: >create pfile= ' D:\init.ora ' from SPFile*.optimizer_index_caching= #这个初始化参数代表一个百分比, the values range from 0 to 99. The default

Java code: First define a method that reads a BLOB field from an Oracle database and writes bytes to an output stream. 1 Public Static voidwriteimg (outputstream os) {2 Connection con;3 Try {4Con =connectionfactory.getconnection

When looking at Oracle execution plan, you often encounter access and filter, the brain capacity is too small, always confusing the difference between the two ... Tidy up a little.Access: Indicates that the corresponding predicate condition affects

--5 constraints, PRIMARY KEY constraints, FOREIGN KEY constraints, UNIQUE constraints, check constraints, non-null constraints.--Add PRIMARY KEY constraint Alter table table_name add constraints Constraint_name Primary key (column_name);--Syntax

--Select SyntaxSelect [DISTINCT | All]select_list fromtable_list[Where_clause] [Group_by_clause] [Having condition] [Order_by_clause] --Syntax Description Select: Query The action keyword, you must have it. [DISTINCT | All]: The query field is in

SelectCase when (grouping (GLBM) =1) Then ' total ' else DECODE (Glbm,null, ', GLBM) end GLBM,Case when (grouping (HPZL) =1) Then ' else DECODE (hpzl,null, ' ', Hpzl ') End HPZL,Case is (grouping (SYXZ) =1 and Grouping (HPZL) =0) Then ' subtotal '

The subquery result set in EXISTS is not empty, and the value of the EXISTS () clause is true.The subquery result set in EXISTS is empty, and the value of the EXISTS () clause is false.The subquery result in not EXISTS is non-null, the value of the

Recently developed a small problem encountered, after executing a section of SQL found that the table is lockedDisplay error: Ora-00054:resource busy and acquire with nowait specifiedBaidu later found that the session process stuck, it can be said

1, Introduction: Oracle Hierarchical Query is a unique feature of Oracle, mainly used to return a dataset, the dataset has a tree relationship (there is a PID in the dataset that records the ID of a record in the current dataset).2, the hierarchical

1. Create User User1Create user User1 identified by xxxxDefault Tablespace xxxx_tableTemporary Tablespace TempProfile defaultGrant connect to User1;2, Way one: Batch table to empowerSelect ' Grant select on Pposuat_17. ' | | table_name | | ' to

Java Connection configuration for Oracle DB cluster: ]Connection configuration for Oracle clusters

Find the user and the corresponding tablespace:===================> select Username,default_tablespace from Dba_users;Service name (Tnsnames.ora inside corresponds global_dbname) ===================> show parameter service_nameInstance name

1, take the first day of the year and the last day of the yearSelect Trunc (sysdate, ' YYYY '), Add_months (Trunc (sysdate, ' YYYY '), 1 from dual TSelect To_char (Trunc (Add_months (Last_day (Sysdate),-1) + 1), ' yyyy-mm-dd ') "The first day of the

Oracle transaction isolation is a different degree of data isolation for transactional read operations, divided into read_uncommitted, read_committed (default), and SERIALIZABLE.Oracle TRANSACTION ISOLATION level serializable to resolve dirty reads,

from:http://blog.csdn.net/iw1210/article/details/11937085Intent: Implement SELECT top 1 * FROM TableNameUsage of the row_number () over () analysis function in OracleRow_number () over (partition by col1 ORDER by col2) indicates that sorting is