Oracle

Third, stored procedures(a) What is a stored procedureA stored procedure is a named PL/SQL block that is stored in a database and is a database object. The application can invoke the stored procedure and execute the appropriate logic.Both stored

When two SQL literals are the same, and other environments are different, the two cursors cannot share the execution plan. They all have their own execution plans in the cache library. These two cursors are child cursors, and Oracle also creates a

Case-when usage, simple case functionA simple case expression that determines the return value using an expression.Grammar:Case Search_expressionWhen Expression1 then RESULT1When Expression2 then RESULT2...When Expressionn then RESULTNELSE

DECLARE Str Varchar(Ten);--define a string variable strBEGIN forIinch 1..10000000Loop-- INSERT into Fw_test (NAME) VALUES (' BBB ' + i);D ecode (' 1 ', ', ', ', ' DECODE ', ' 2 ', ', ', ', ' DECODE ', ' 3 ', ', ', ' 2 ' | | ' 3 '))) NVL2 (' 1 ',

Oracle is very memory-eating, and I'm often reluctant to download this very memory-eating app. Of course there is a solution, if you already have the Oracle database on the server, you only need to download the Oracle client, you locally installed a

One, concurrencyConcurrency is the most important feature of an OLTP database, but concurrency involves the acquisition, sharing, and locking of resources.Mysql:MySQL is a table-level lock-based, the granularity of the resource lock is very large,

Oracle database control files are very important files, which are automatically generated binaries when the database is created, which records the status information of the database, mainly including the following content? Name of the database, a

1, open the CMD Command dialog box, login Sqlplus (mainly if the administrator account, the user name needs to add as SYSDBA, the password format is [email protected]/instance name), enter the AWR Execute SQL statement (Note that The path is based

1. Turn off all Oracle services. Can be turned off in the Windows Service Manager;2. Open the registry: Regedit Open path:Hkey_local_machine\system\currentcontrolset\services\Remove all service names starting with Oracle under this path, which is a

Creation of Oracle Database tables:CREATE TABLE Log (Un char (20),PD Char (25))Tablespace users;Oracle Configuration in MyEclipse:1. Guide Jar Package:Right-click the project name, build path→configure build Path→libraries→add External JARs. →d:\app\

Alter any index to modify permissions on arbitrary indexesAlter any role to modify permissions for arbitrary rolesAlter ANY SEQUENCE permission to modify any sequenceAlter any snapshot permissions to modify any snapshotAlter any TABLE permission to

1. Develop WindowsFeature (program) in the Linux extension interface (in fact, from the Windows2008 before the release of the trial, it was found secretly hidden a UNIX interface option).2. The Windows Store can be downloaded to Ubuntu for

Today the user to execute a very simple SQL, the output result set is only tens of thousands of, involving three tables, the maximum is only 1 million of the data, the results are reported in the case of lack of table space, theory, such SQL should

PLM project has been formally tested in-line, data management is the most serious, easy to recover processing, to avoid data loss. Idea: Data export + timed backup + data cycle cleanup1, copy the Oracle installation directory Bin Exp.exe (can also

"ORA-04076: Invalid NEW or old description" may occur when the Oracle command line is operatingYou need to add "old" in the conditional statement before the job. (because it is in the when condition, so do not ":".)If you use if instead of when, the

Remember to implement MD5 encryption, in Oracle 11g and 12c there are different ways, in 12c is simpler, remember directly have predefined functions.But in the 11g to implement the need to do some additional processing, the following gives a MD5

SELECT DISTINCT AB. TABLE_NAME,Ab. Segment_name,Ab. Tablespace_name,Ab. OWNER,Sum (AC. bytes/1024/1024/1024) GBFrom Dba_lobs AB, dba_segments ACwhere AB. OWNER in (SELECT USERNAMEFrom Dba_users AWHERE a.account_status = ' OPEN 'and

In some databases (for example, MySQL), implement the self-increment ID as long as you specify it when you build the table,But in Oracle, with sequence to implement the self-increment ID,There are several ways to use the self-increment ID:1. Use

For example:SELECT ename, Job, DeptnoFrom EMPWHERE Deptno in (10, 20)and (ename like '%I ' or job like '%er ');Execute the SQL with the result set as follows:1 JONES MANAGER 202 CLARK MANAGER 10Remove the parentheses in the SQL query criteria

Issue Background Description:One day the customer has a demand, given a number of mobile phone numbers or phone numbers, to find out the relevant call records, as well as some related information.Customer-given called number:The results of the query