Oracle

Add several password-related issues to note after upgrading from 10g to 11g:1.11g default start password is case-sensitive, you can set the parameter to Sec_case_sensitive_logon =false Shield2. The 11g password is valid for 180 days by default and

drop table test Purge;CREATE TABLE Test (ID number,Code varchar (20),Name varchar (20));INSERT into test values (1, ' 201401 ', ' aaa ');INSERT into test values (2, ' 201402 ', ' BBB ');INSERT into test values (3, ' 201402 ', ' CCC ');INSERT into

Reprint: http://www.cnblogs.com/yangxia-test/archive/2012/09/20/2695617.htmlImplementing select Top N in Oracle:Because Oracle does not support the SELECT top statement, it is often used in Oracle with order by and RowNumTo implement the query for

NVL2 (EXPR1,EXPR2,EXPR3) function: If the parameter expression EXPR1 value is null, the NVL2 () function returns the value of the parameter expression Expr3, or expr1 () if the parameter expression NVL2 value is not null The EXPR2 function returns

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

Description: JAVA springmvc+mybatis (Oracle and MySQL) HTML5 new tall background framework1. Support App mobile app (Android and iOS) interface call (JSON interface can be interfaced with other programs)2. New tall Changquan html5+css3.0 development

Use OCI to list data in all data table ' Email_info 'Ditto, just use OCI to writeRelated PHP (PHP training PHP tutorial) code:The following is a reference fragment:PUTENV ("Oracle (Oracle Training) _sid=orasid");$connection = Ocilogon ("username",

CREATE OR REPLACE TRIGGER trg_kc_sprk_iBefore INSERT on KC_SPRKFor each ROWDECLAREVSCBH VARCHAR2 (40);ICount number;IFOR number;BEGINSelect T.bhqz into VSCBH from Xt_djbhgz t where t.gzid=8;--Here is a prefix for getting a field from another table,

--Create table/*create table test_table (STUDENT VARCHAR2 ($), SUBJECT VARCHAR2 (+), GRADE number) Tablespace Syste M pctfree pctused Initrans 1 Maxtrans 255 storage (initial 64K minextents 1 Maxextents Unlimited); *//*insert into test_table

[Oracle] Get the data analysis you want from a string resourceRequirements: Order analysis, according to the game, account level, game account occupation, district clothing, price range analysis of the transaction data movement。Target: Order

Principles of SQL optimization Use column names as much as possible --sql Optimizing the Order of 2:where parsing: right-to-left Select * from zl_yhjbqk where dy_dj = ' 1K or less ' and xh_bz=1Select * from Zl_yhjbqk where xh_bz=1

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,

ORA-01720 and ORA-01031 errors when GRANT/SELECT View, ora-01720ora-01031 For information about ORA-01031 errors when creating a view, refer to an article I 've previously compiled: Create view failed with ORA-01031: insufficient privileges,

Oracle11gRAC manually uninstall grid and nodeinstall1. log on to the ORACLE_HOME page of the grid as the root user. [Root @ db01] # source/home/grid/. bash_profile[Root @ db01] # cd $ ORACLE_HOME/crs/install/ 2. Execute the following two scripts

How to Use UNIQUEConstraint Oracle | PL/SQL Unique index (Unique Constraint) Usage1 goal The following example shows how to create, delete, disable, and use uniqueness constraints.2. What is a uniqueness constraint? A uniqueness constraint refers to

Oracle Check Constraints Oracle | PL/SQL Check constraints usage1. The target instance explains how to use the CHECK constraint (create, enable, disable, and delete) in Oracle. 2. What is the Check constraint? The CHECK constraint adds additional

OracleApex practical notes Series 2-File Upload Management1. Page Design Page A has several region, one of which is used for file list management (including display, download, and delete) and. There is A button on page A. Clicking it will call page

ORACLEprofile limit maid 4 -- CREATEPROFILE Â Â Æ ª ² Í Ê çoracle profile Ï µá Ð µäzúä ä£ £%öö %%%%%%µ%» â  £%%%%%%%%%%%%%%%%%%%%%%%%%%% comment ''¨ profile ° Í Ê Ó Ã profile ø Ø Ð × Ê Ô'' ° Í Ü Â ë ø öööCREATE PROFILE Note:Oracle recommends that

IT Ninja Turtles-Oracle query Tree Structure The select statement in Oracle can use the start with... connect by prior clause to implement recursive queries. connect by is used in structured queries, The basic syntax is: Bytes -----------------------