Oracle

Oracle Query User Table space: SELECT * from User_all_tablesOracle queries all functions and stored procedures: SELECT * FROM User_sourceOracle Queries All users: SELECT * FROM All_users.select * from Dba_usersOracle View Current User connection:

Routine Check database awr report, there is an UPDATE statement executed several times, each execution time more than 30 seconds, this SQL statement is simple, is to modify the data according to the primary key condition, the number of primary keys

1: To SYSDBA login system, first create a userSql> Conn/assysdbaconnected.sql> Create user yshy identified by yshy; User created. SQL> grant connect to Yshy; Grant succeeded. SQL> grant resource to yshy; Grant succeeded. SQL> grant create synonym to

We may need to manipulate the Oracle database in our tests, such as a scenario where the data is inserted into Oracle while another tool reads from it, and how to ensure that the data being read is sequential, that is, first inserted into the first

Oracle database requires proficiency in the following1, the writing of stored procedures and cursors, cursors written in the stored procedure, triggers2, the function of the writing3. Backup and Recovery4. User and Rights Management5. Functions and

Oracle:Find all SubordinatesSELECT * from tbl_test start with id=1 connect by prior Id=pidFind all SuperiorsSELECT * from tbl_test start with id=5 connect by prior Pid=idSQL Server:SQL Server recursion gets subordinate and current levelWith CTE

Unable to log on at logon: No listener ——— start Service Oraclexetnlistener Listener does not currently recognize the request service in the connection description ———— Restart service oracleservicexe check Tnsnames.ora ho St ValueWhen PL/SQL is not

Create 3 new log groups sql> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo06.log ') SIZE 500M;sql> ALTER DATABASE ADD LOGFILE GROUP 5 ('/u01/app/oracle/oradata/orcl/redo05.log ') SIZE 500M; sql> ALTER DATABASE ADD

CREATE TABLE Test_leiji (rpt_month_id number (8),Current_month number (12,2));Insert into Test_leiji (rpt_month_id, Current_month) VALUES (200901, 380128.344363);Insert into Test_leiji (rpt_month_id, Current_month) VALUES (200902,

One, the ordering of child nodes of the department with child nodes, calling child stored procedurescreate OR REPLACE PROCEDURE "Pro_init_sort" Ascursor Cur_department_all is Select * FROM Tbl_department; Var_count number; Var_out_count number: = 0;

Http://www.cnblogs.com/david-zhang-index/archive/2012/04/10/2441015.html Operations on Fields Operation method Update Field Name ALTER TABLE table_name Rename column column_old to column_new;

EXPDP does not rely on and reference Nls_lang settings, but completely in accordance with the database itself to convert the character set, usually the data is not small when the Exp/imp Guide database has been used, to the large amount of data

Turn into Oracle to do the project, sister's, too pit Dad, Oracle does not have the concept of database, is to build roles, assign permissions, seemingly very powerful, after building the right to check the data when the error said that the users

http://www.blogjava.net/lukangping/articles/340683.html/* creates a memory space parameter allocated for bitmap index to speed up indexing */Show parameter create_bit;/* Change the storage parameters of the index */Alter INDEX INDEX_NAME PCTFREE

Oracle11g recursion + exists Execution Plan Change There is a recursive query that runs fast on 10g, but cannot run on 11g.SQL> select * from v $ version;BANNER--------------------------------------------------------------------------------Oracle

How to view the Oracle client version and the oracle client In practice, you will always encounter issues that require you to view and verify the ORACLE client version, because one server may have multiple Oracle client versions; you may also need

Difference between Oracleindexunusable and invisible Extracted from the 11g Official Document: UNUSABLESpecify UNUSABLE to mark the index or index partition (s) or index subpartition (s) UNUSABLE. the space allocated for an index or index partition

Usage of ForeignKey outside Oracle (1) Oracle Foreign Key usage (1)1. Objectives Demonstrate how to use a foreign key in an Oracle database2. What is a foreign key? 1) in Oracle databases, foreign keys are one of the methods used to achieve the

Oracle Primary Key Usage Oracle/PLSQL: Primary Key Usage1 goal The example shows how to create, delete, disable, and enable a primary key.2 preface-what is a primary key? In Oracle, a primary key indicates a single data table column that uniquely

ORACLE _ create and manage tablesZookeeper ORACLE _ create and manage tables ① Common database objectsTable: A Basic Data Storage set consisting of rows and columns.View: logically related data set extracted from the table.Sequence: provides regular