Oracle

Oracle jdeveloper develops J2EE applications based on the ADF frameworkProgramThe configuration of the data source must be involved. After exploration, we finally figured out how to configure the data source in jdeveloper and how to configure the

Syntax:Replace (char, search_string, replacement_string)  Usage: SetCharString inSearch_stringConvert all to stringsReplacement_stringAnd no matching strings will be changed.  Example: SQL> select Replace ('fgsgswsgs ', 'fk', 'J') from

There are three ways to create a database: 1: use ORACLE dbca (Database Configuration Assistant) to create a database 2: Create a database manually (this is complicated and requires manual parameter configuration) 3: Use Oracle managed filed to

An Oracle ORA-01033 power failure or network disconnection may occur 1. Go to CMD and run set oracle_sid = fbms to ensure the correct Sid is connected; 2. Run sqlplus "/As sysdba" SQL> shutdown immediate to stop the service SQL> startup Start the

Connection: http://hi.baidu.com/mythstar365/blog/item/dabb9d8075572c9bf703a675.html (Windows 7 flagship edition) Windows 7 is so annoying! I have installed SQL Server on my computer.2005. The installation process is fine. It will be done soon, but

Every DBA in the Process of database management should inevitably encounter all kinds of errors (ORA-1547, ORA-904, ORA-1578 ......). Some errors are often called "classic errors" by Oracle DBAs due to frequent and complex causes ". The ORA-3113

Oracle CEO Larry herison According to foreign media reports, Oracle CEO Larry Ellison said on Saturday that sun is expected to make a profit soon. Oracle completed the acquisition of sun for $7.5 billion last month. Oracle executives have long

Oracle 10g Linux Installation notes I. Create a user and a directory 1. Create user group#/Usr/sbin/groupadd oinstall#/Usr/sbin/groupadd DBA2. Create a user and set a password#/Usr/sbin/useradd-G oinstall-g dba Oracle# Passwd Oracle3. Create a

Insufficient permissions are reported when creating a tablespace. The following problems are caused: Create tablespace test1 datafile 'd: \ mydf. dbf' size 10 m;1. Create a tablespace and report insufficient Permissions2. view the permissions of the

1. If Oracle 9i is installed, the default value in the National charset is al16utf16. If you want to change al16utf16 to utf8 Follow the previous method Update SYS. Props $ Set Value $ = 'utf8' where name = ''nls _ nchar_characterset ''; The charset

Differences between Oracle database and MySQL database: 1. Group function usage rules In MySQL, group functions can be used at will in select statements. However, if a group function exists in a query statement in Oracle, other column names must

ORA-00922: Option Missing or invalidError cause: the statement syntax is incorrect. For example, the name is incorrect or the keyword is incorrect. For non-standard names, they are generally created using double quotation marks.Solution:Identifier

1. Environment Settings 1.1 Network Connection (both the source and target databases must be configured)Run Oracle Net Configuration Assistant to add a local service name. You can also directly modify the (tnsnames. ora) file. The content is as

CREATE TABLE AREAS ( Radius number (5 ), Area number (14,2) ); Method 1: Use gotoDECLARE Pi constant number (9, seven): = 3.1415927; Radius INTEGER (5 ); Area NUMBER (14, 2 ); BEGIN Radius: = 0; LOOP Radius: = radius + 1; IF radius = 4 THEN GOTO

SQL> alter database add logfile thread 1 group5 ('+ Data/myrac/onlinelog/myrac1_redolog_group5_01') size 100 m; SQL> alter database add logfile member '+ Data/myrac/onlinelog/myrackets redolog_group5_02' to group 5; SQL> alter database add logfile

Create or replace function udf_weekofyear (v_date in date, formate in varchar2) return charAsV_ret char (6 );V_ret1 char (2 );V_ret3 number;Begin V_ret3: = to_char (v_date, 'iw ');If v_ret3 = 1 and to_char (v_date, 'mm') = '12' then -- determine

Lv_ SQL: ='Insert into etl_sucess_amountSelect seq_ OS _etl_amountid.nextval as amountid, 1, amount_data, amount_hour,Serviceid, portalid, mouduleid, actionid, reserve1_id, reserve2_id, reserve3_id,Reserve4_id, amount, amount_timeFrom(SelectTrunc

1. Block Cleanout description Article arrangement reference: http://www.orawh.com/60.html Block clean out refers to changing the data in a block from dirty to clean. It is equivalent to telling the people behind the block that the data in the block

Oracle memory structure and instance Management 1. Memory Structure: The overall structure of the Oracle database is as follows: Each Oracle database is composed of an Oracle Instance and a database (data file, control file, and redo log file). The

Online logs are classified into current online logs and non-current online logs. the corruption of Non-current online logs is relatively simple. Generally, you can solve the problem by using the clear command. Corrupt non-current online logs:1.