Oracle

--Table Space usage QuerySELECT TBS table space name,SUM (totalm) total size M,SUM (USEDM) has used space m,SUM (REMAINEDM) remaining space m,SUM (USEDM)/sum (Totalm) *100 percent used,SUM (REMAINEDM)/sum (totalm) *100 remaining percentageFrom

First, Oracle common related SQL statements1. Connect to the databaseSu-oracle-c "Sqlsplus User/Password Note: First time login with Sqlplus/as SYSDBANote: Close the database: Note: Shutdown can be turned off option, from the mildest to the most

Sometimes you need to restart the Oracle database on Linux.Note Start the database first, and then listen on the startup database.Su oraclesqlplus/nologconnect/as sysdbastartup//exit Sqlplusexitlsnrctl start//shut down the database before opening

Reason and method of Oracle user being lockedBe told that the test user is locked when logging in1, with the DBA role of the user login, unlock, first set the specific time format, in order to see the specific timeSql> alter session set

The difference between Oracle and SQL Server development is that developing a database application with SQL Server typically builds a database and then designs a database object in the database, such as tables/views/stored procedures/functions

Oracle can only be natively connected and not connected to other computers on the networkOracle listens only to local 127.0.0.1, causing the network other computers to not connect to the workaround:Modify the Listener.ora listening file to change

CREATE TABLE CDPT (ID Number (6),Name VARCHAR2 (30),Constraint pk_id primary key (ID));Change the delay segment creation attribute of the database to false to execute this sentence in SQL plusALTER SYSTEM SET Deferred_segment_creation=false;Create a

1, reduce the burden of the network: through the MV data from a database distributed to a number of different databases, through multiple database access to alleviate the network burden on a single database. 2, build distribution environment: By

1. Two tables (multiple tables) associated update--the modified value is calculated by another table　　Update Customers A　　Set City_name= (select B.city_name from tmp_cust_city b where b.customer_id=a.customer_id) 　　where exists (select 1　　From

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

1 , in the installation Oracle before installing the following component packages first, enter the following statements directly. Yum Install binutils*-yYum Install compat-lib*-yYum Install gcc*-yYum Install glibc*-yYum Install ksh*-yYum Install

Online Baidu to appear this phenomenon reason, said seems to be quite reasonable, so copy come over:when you debug a procedure, function, or package, the company's firewall kills the session connection if there is no action for a long time. This

One, temporary table spaceThe temporary tablespace contains only the ephemeral data generated during the session, improving the concurrency of multiple sort operations that cannot be done in memory, while also improving the efficiency of space

Left paddingSelect Lpad (' ABCDE ', ten, ' 0 ') from dual; = = "00000abcdeSelect Lpad (' ABCDE ', ten, ' X ') from dual;== "XxxxxabcdeThe syntax format is as follows: Lpad (String, Padded_length, [pad_string]) string prepares to be populated, and

Http://blog.sina.com.cn/s/blog_4df2251d0100hkzv.htmlFirst step, on the cmd command line, enter SqlplusStep two, follow the prompts to enter the user name and password1. View processes and Sessions parametersSql> Show parameter processesNAME TYPE

SELECT * FROM t where rownum=1 can query out data, while select * from T where rownum=2 can not query out data. In the case of where rownum = 1, the first row passes the test, is output and rownum goesto 2. No other row ever satisfies the predicate

I. Overview of Oracle Table spacesTablespaces are a logical structure in an Oracle database. From the logical level, the table space contains segments, the objects in the database are organized in the form of segments, such as table segments, index

1. There are two forms of case-when expression--simple case function case sex when'1'Then'male' when'2'Then'female'ELSE'other'END--Case search function Casewhen sex='1'Then'male'When sex='2'Then'female'ELSE'other'END2. When a case is used in a

OracleDatabaseBackup and Restore commandsData export:1 full export of database test, user Name System Password Manager exported to D:\daochu.dmpExp System/[email protected] file=d:\daochu.dmp full=y2 Exporting the system user in the database to the

This week is working overtime, Flash again Thursday, every day overtime time to go fast. The company bought 3 23-inch display, Dell's, can be arbitrarily rotated. First gave me this project group use, do not know calculate a kind of reward ... It's