Oracle

(1) Ibatis XML configuration: The following notation is simply escaped namelike '% $name $% '(2) This can cause SQL injection problems, such as the parameter name into a single quotation mark "'", the resulting SQL statement will be: name like '% '%

The difference between function and procedure in Oracle:1). You can understand that a function is a 2 of a stored procedure. A function can have no arguments, but it must need a return value, and the stored procedure can have no parameters and does

SQL is as follows:Select min (es.sku_price) sku_price, ei. item_idFrom Eb_item ei, eb_sku eswhere ei.item_id = es.item_idand ei.audit_status = 1and Ei.show_status = 0GROUP by EI. item_idThe results are as follows:After changing the min in the SQL

I. Installing Oracle 11G error message under WIN10 [INS-30131] Initial setup failure required to perform setup verificationSolve:Use the following permissions to create the C-Drive Share command in CMD (Run as Administrator):NET share

Reference article: http://blog.itpub.net/24052272/viewspace-2129175/In the process of transmission, Oracle is normally transmitted in plaintext, such as SQL and the results of execution.Take a look at the tests done:Client Ip:192.168.0.104,oracle

PhenomenonRemote Client Toad connection, the card is not responding. The Oracle server uses the tsping {IP address} prompt to connect. Follow the prompts to query the appropriate questions, prompting for possible configuration problems,

# Tnsnames.ora Network Configuration file:d:\develop\oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. LISTENER_ORCL=(ADDRESS= (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

Make sure the landlord is logged in as an administrator:1. First, create a (new) User: Create user username identified by password; Username: User name for new username Password: New user's passwordYou can also not create a new user, but

SELECTFrom (SELECT A1. , ROWNUM RNFrom (SELECT h.*From Tbc_adownblk_hist HWHERE 1 = 1ORDER by Adownblkid ASC) A1WHERE ROWNUM WHERE RN >= 1Want to sort must be written in this notation--Add ' prefix ' to different dictionary valuesMethod OneSelect

Create table space parameters in detailSyntax Description:CREATE?[UNDO]? TABLESPACE tablespace_name[DATAFILE datefile_spec1 [,datefile_spec2] ......[ { MININUM?EXTENT integer [k|m] | BLOCKSIZE integer [k]|logging clause|FORCE LOGGING|DEFAULT?

Connection query: Join(1) Equivalent connection: Usually connected with primary foreign key(2) Non-equivalent connectionCases-- count each person's name. Department name, salary, salary level select ename,d.dname,e.sal,s.grade from emp e,dept

I. Creating index Considerations1. Estimated Index size2. View the amount of space available in the Index table space3. View temporary table space size4. Creation of business idle period5, can consider the online, parallel, nologging modeSecond, the

SQL (Structured Query Language): Structured Query LanguageThe specifications for its use are:Keywords to capitalize, other lowercaseWhen the WHERE clause is written, each condition occupies one line, and when the statement is started on another line,

Create a database fileCreate a database fileCREATE TABLESPACE MyDataBase LOGGING DATAFILE ‘D:\Oracle\database\MyDataBase.dbf‘ SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL; 1

1. Delete the contents of the original databaseDrop user username cascade;My database name is test, so the SQL statement is:Drop user test cascade;2. Create TABLE spaces:The statement is: Create tablespace localtest datafile '

(1) using rowID methodQuery duplicate data: SELECT * from Person a where rowid! = (select Max (ROWID) from person B where a.cardid=b.cardid and a.pname=b.pname);Delete duplicate data: Delete from person a where rowid! = (select Max (ROWID) from

Usually use the self-related tree structure table to store the data of the tree structure, the hierarchical relationship between the data represents the parent-child relationship in the tree structure, and is usually described by the relation

Select Max (SS.SIZE_GB), avg (SS.SIZE_GB)From (select s.*, RowNum rn2From (select A.*From (select t1.*, rownum RNFrom (SELECT TRUNC (first_time) time,SUM (Block_size * BLOCKS)/1024/1024/1024 SIZE_GBFrom V$archived_logGROUP by TRUNC (first_time)ORDER

Database version:Oracle 11.2.0.3 RACExperimental Purpose:View Oracle transaction information through the undo blockExperimental Details:1 Starting a transactionSql> select * from T1;ID NAME---------- ------------------------------1 YCR2 Zhy3 Wya5 LJ4

Hidden parameters (hidden parameters), used internally by Oracle, starts with ' _ '.You can view all of the hidden parameters in the following two ways:[SQL]View PlainCopy SELECT i.ksppinm Name, I.ksppdesc description, CV.KSPPSTVL VALUE,