Oracle

1. First ensure that server port 1521 is turned onA. 1521 exception to firewall port increaseB. Firewall program add Oracle.exe exception (I don't deserve this)C. telnet 192.168.74.130 1521 test to be connectedError I encountered: Unable to open

Create DatabaseLink Jtkhjfdbconnect toKHJF identified byhellousing'( DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.196.57.197) (PORT = 1521)) (Connec T_data = (service_name = Jtkhjfdb )))';SelectParty_id,realname

Characteristics of the transaction (ACID)A (atomacity) atomicity: A transaction is a whole, and the processing statement that makes up a transaction forms a logical unit and cannot execute only part of it.C (consistency) Consistency: database is

TNS

1 CREATE OR REPLACE FUNCTIONTo_time (secinch Number)RETURN VARCHAR2 is2 /*Turn the seconds into a time and minute format3 Auth Lzpong 201/09/164 */5 BEGIN6 RETURNTRUNC (NVL (sec,0)/3600)||':'||SUBSTR (Numtodsinterval (NVL (sec,0),'Second'), the,5

Take a look at what information this view can bring to us (each column in the view is helpful):[Email protected]> Select pga_target_for_estimate/1024/1024 "PGA (MB)",2 Pga_target_factor,3 Estd_pga_cache_hit_percentage,4 Estd_overalloc_count5 from

If the data in the Oracle data table is not responding when it is being hacked, it is likely that the table is locked. Use the following command to resolve the locking problem.Lock table Status query. Copy and paste directly to it.--Lock Table Query

Operation Steps: (Open archive)In either node operation:[[email protected] ~]$ srvctl stop database -d mecbs[[email protected]  ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production  on mon sep 14 23:24:19 2015copyright  (c)

CREATE TABLE SpaceCreate tablespace usersDataFile ' D:\Oracle\oracle\oradata\users.dbf 'Size 100mAutoextend onNext 100m maxsize 20480mExtent management Local;Create userCreate user hy_pubres identified by 123;             Grant Create session to

1.Oracle string concatenationOracle supports string concatenation with the concat () function and automatically converts other types to strings except for "| |", but unlike MySQL's concat () function, Oracle's CONCAT () function supports only two

1. This is a block of code executed under Oracle's SQL windowDeclareV_CHAR1 varchar2 (100);V_CHAR2 varchar2 (100);V_c char (1); --Intermediate variablesBeginV_CHAR1: = ' &no '; --Replace transformationDbms_output.put_line (' Input data is: ' | |

SELECT * from XMLTABLE (' $B/deal_basic/user_deal_info ' passingXMLTYPE (' &xml ') as BCOLUMNS user_deal_id VARCHAR2 () PATH'/user_deal_info/user_deal_id ',Deal_inure_time VARCHAR2 () PATH'/user_deal_info/deal_inure_time ',Deal_expire_time VARCHAR2 (

Reprint to Http://www.blogjava.net/itspy/archive/2007/12/20/169072.htmlOracleProblem Description:The following error occurred while using JDBC to connect to the Oracle 10.2.0.1.0 database today:Connection refused (description= (tmp=) (vsnnum=15309312

1 Configuring operating system environment variables1.1 WindowsPath variable contains route informationCmd〉echo%path%Cmd> Set path=%oracle_home%\bin;%path%Registry value: "Oracle_home", "Oracle_sid" is set correctlyWhole Word Match Search value650)

How to find out which table the foreign key is built onSometimes when a table record is deleted, the foreign key constraint cannot be deleted.If you do not understand the relationships between tables, you can query to which table the foreign key is

To intercept some log information:2015-09-01 14:48:47,132 INFO [Org.springframework.beans.factory.xml.XmlBeanDefinitionReader]-Loading XML bean Definitions from class path resource [Org/springframework/jdbc/support/sql-error-codes.xml]2015-09-01 14:4

You can include the actual character "%" or "_" in the pattern using the exception clause, which determines the escape character. If the escape character appears in the pattern in the character "%" or "_", Oracle will interpret the pattern on this

Oracle to_number, to_char, to_date usage, to_numberto_date TO_DATE converts a string to a date type conversion function in the database.TO_CHAR converts a date or number to a string.TO_NUMBER converts a character to a numberTO_DATEUse the TO_DATE

Oracle's to_number, to_char, and to_date usageTO_DATE is to convert the string to the date type conversion function in the database TO_CHAR is to convert the date or number to the string TO_NUMBER to convert the character to the number TO_DATE using

Partition Table in oraclePartition tables in oracle are frequently used in the system and frequently appear in some systems with large data volumes. When talking about partition tables, we must first understand what partitions are. In fact, the