Oracle

Eg: Create materialized view mv_asset_query_countRefresh force on commitEnable query rewriteAsSelect count (T. sbbh)From pmsbi. f_sb_sbxx T, d_pm_company T1, pmsbi. d_bds T2, d_pm_asset_style T4, d_pm_zzc T5, d_pm_asset_type T6Where T. ssjdm =

24. query table space usage select. tablespace_name, round (. abytes/1024/1024) totalmb, round (. abytes-f. fbytes/1024/1024) usedmb, round (F. fbytes/1024/1024) freemb, (1-round (F. fbytes/. abytes, 2) * 100 "% used", round (F. fbytes/. abytes, 2) *

###### Analyze the log file logmnr ############## 1) in init. set utl_file_dir parameter in ora 2) Restart oracle3) create directory file DESC dbms_logmnr_d; dbms_logmnr_d.build; 4) add Log File Add/Remove log handler) Start

Instance: Create a userinfo database table: Of course you can write it like this:Drop table userinfoCreate Table userinfo(Englishname varchar (30 ),Chinesename varchar (30 ),Sex varchar (10 ),Age int,Birthplace varchar (100 ),Birthdate date

1. Prerequisites: The Oracle client has been correctly installed. 2. Install sqlplus 3. Find the Oracle/product/10.2.0/db_1/Network/admin/tnsnames. ora file and append it to the file: Connection configuration name =(Description =(Address_list

Cert_1 used to be varchar (3000), and the current type is blob. During database migration, the import tool cannot be used for direct import. Therefore, SQL is used.     DeclareDirections blob;Amount binary_integer;Offset

1. If If the Oracle tnslistener service is not started Net start oracleoradb10g_home1tnslistener 2. Shutdown Sqlplus sys/oracle10 @ tstdb as sysdba @ C:/stop.txt 3. startup Sqlplus sys/oracle10 @ tstdb as sysdba @ C:/start.txt The content

6. cursor statementNo parameter Declaration: cursor cur_name is select col1, col2,... from... where ...;With parameter Declaration: cursor cur_name (param1 data_type, param2 data_type,...) is select col1, col2,... from... where ...; 7. Use cursor

Synonym Synonyms     Synonyms (Oracle database only)Such a query statement always exists:Select sysdate from dual; (Query System Information)I have always stressed that dual is a virtual table. Although it is a virtual table, it isWhere is it

An error occurred while running an ocacle sqlldr (import data) command in Linux today.   Sqlldr username/password control = 'tbl _ EMP. CTL'   /Opt/Oracle/APP/Oracle/product/10.2.0/db_1/bin/sqlldr (Switch the user to a user in Oracle first)   1.

In Oracle, there is a wmsys user. Like sys, system, and other users, this user is created during Oracle installation.   The function starting with WM is the function of this user.   Wmsys users are mainly responsible for managing the daily work

About spool (spool is a sqlplus command, not something in SQL syntax .) For spool data SQL, you 'd better define your own format to facilitate direct import of programs. The SQL statement is as follows:Select taskindex | '| commonindex |' | tasktype

11. View the parameter information of a data table: Select partition_name, high_value, partition, tablespace_name, pct_free, upper, lower, max_trans, upper, next_extent, min_extent, max_extent, upper, freelists, lower, logging, buffer, num_rows,

################## Managing password security and resources ################# ### alter user user_name account unlock/open; ---- lock/open the user; Alter user user_name password expire; --- set the Password Expiration/* set the password

########### Basic SQL select ################ select col_name as col_alias from table_name; select col_name from table_name where col1 like '_ o %'; ---- '_' matches a single character/* uses a character function (intercepted on the right, the field

##################### Create/alter table ############### ######## alter table table_name drop column column_name; --- drop columnalter table table_name set unused (col1, col2 ,...); ---- the setting column is invalid, which is faster. Alter table

1. If the "Regional and language options" option is used after installation, the Oracle service cannot be started normally and the TNS will fail. 2. You cannot assign an IP address through DHCP when installing oracle. You must specify an IP address

SQL> Conn/As sysdba Connected to an idle instance. SQL> startup Oracle instance started. Total system global area 276824064 bytes Fixed size 778736 bytes Variable Size 137371152 bytes Database buffers 138412032 bytes Redo buffers 262144 bytes

Can be downloaded here Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html   Decompress it to C:/oracleinstantclient1. Set Path = C:/oracleinstantclient2. Set tns_admin = C:/oracleinstantclient3. Create a

Http://database.51cto.com/art/200703/41790.htm First, the table below describes the ing relationship with the DB2/400 data types, which is a one-to-many relationship. The specific ing relationship should be analyzed for specific issues. Note: The