oracle 11g sql certification

Two test samples were made in the art of simulating Oracle performance diagnostics. The book says not to bear relies_on. Cache (Result_cache relies_on (test1,test2)). The test proved incorrect, and the function F1 () did not use relies_on, but the changes on the table affected the function. C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 19:46:44 2014Copyright (c) 1982, 20

machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from Nls_instance_parameters;View the value of N

Oracle 11g how to clear the execution plan of an SQL statement in the share pool, 11 gpool In the past, if the execution plan was slow due to binding snoop on a 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it hard to parse it, after searching for a long time, I did not find the me

My environment is like this: Win7 64-bit + Oracle 11g + PL/SQL 9.04 Since PL/SQL does not support 64-bit data at the moment, only Oracle client 32-bit data can be used, so you need to download it from the official website: Remember: you must download a 32-bit package) Http:/

sensitive. In SQL * Plus, each SQL statement must end with a semicolon. If the statement is long, You can distribute the statement text to multiple rows and end with a semicolon. 2.1 common Oracle 11g Data Types Character Type CHAR type CHAR indicates a fixed-length string. If the length is insufficient, spaces are

How to clear the execution plan of an SQL statement in the share pool in Oracle 11g In the past, if the execution plan was slow due to binding snoop on Oracle 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it hard to parse it, after searc

variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download and install the PL.SQL.Developer configuration appConfigure Tools->preferences->conne

Imitating the example of Oracle performance diagnostics in two experiments, the book says that if you don't use relies_on, the change action on the object that the function depends on does not cause the result cache to fail operation (Result_cache relies_on (test1, TEST2), the test proves wrong, the function F1 () does not use relies_on, but the changes on the table affect the function. C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protecte

Label:Previously on the 10g database, if the binding snooping caused the execution plan is slow, want to clear the execution plan of a SQL, let it hard parsing, for a long time did not find a direct operation share pool method (total cannot alter system flush Shared_pool), SQL can only be hardened by parsing the table DDL. Now finally found, using Sys.dbms_shared_pool.purge, can be used directly under

Tag:cahttpcom use data Transfer from:http://www.360doc.com/content/14/0602/10/4903283_382949382.shtml This you need to install a 32-bit Oracle client to use Plsql, But at this time sqlplus can not be used, hehe . I tried the following method, successfully, haha 1) install Oracle 11g 64-bit 2) Install 32-bit Oracle cl

1, Oracle date in the internal representation is numeric format, precision from century to seconds.2. The default date representation format is DD-MON-RR (not yy)The difference between YY and RR:3. Date Operation functionExample:The second parameter of Next_day can also be a number that represents a date after a few days. Last_day is the last day of the month in which the date was asked.ROUND (' dd-11-2014 ', ' month ') is accurate to the month, ' Day

Tags: Unlock index family repeat completely delete int nbsp Read letNot NULL non-null field +not null Unique only Primary key primary key (ensure data cannot be duplicated) FOREIGN key foreign key Check must Drop purge completely removed Cascade Delete: Delete A department, the staff in the department then delete the --->on delete cascade Empty: Transfer employees from the department to Null, delete Department --->on delete set null Cannot move: Delete the employee first, then delete the

Tags: ext Let pen he play back center bre screensSharing a form to generate Excel file for SQL query in Oracle Forms. This form can is used in Oracle Forms 6i and 10g/11g. Below is the shot of this form and could was download from the following LINK:EXCEL_REP.FMB A procedure Create_ Excel_file is attached in program U

I have just joined a new project recently. The requirements have been completed and will enter the detailed design stage. The project framework should use a multi-project system framework that is being developed by other project teams and use this main framework to develop modules of our own system. I have learned about the composition of this framework over the past few days, mainly uses the WCF Service, entityframework 4.1 Framework, and ext. NET component development, by the way, I learned EF

SQL: Oracle 11g create table, function, trigger, sequence, 11 gtrigger -- Place directory drop table BookPlaceList; create table BookPlaceList (BookPlaceID int primary key, -- NUMBERBookPlaceName nvarchar2 (500) not null, BookPlaceCode varchar (100) null, -- location parameter BookPlaceParent INT null -- BookPlaceKindId nvarchar (500) null -- place DIRECTORY para

There are two types of data type conversions for Oracle: Implicit conversions and explicit conversions. Try to use explicit conversions when you use them.Implicit conversions are typically Varchar2 or char conversions to number and date, or vice versa. Example,hir_date> ' 1-jan-2014 ' string is implicitly converted to the date type, and select ' 53.5 ' +23 from dual is implicitly converted to the number type for the string.An explicit conversion:An ex

Sort after adding nulls last in descending order, put null in the finalSelect To_char (sysdate, ' Q ') from dual;Dual pseudo-table public synonym because it has a record for easy readingSelect RowNum, ' A ' | | Rownum,mod (rownum,2) from dual connect by rownumSelect Rownum,to_date (' 2016-05-01 ', ' YYYY-MM-DD ') from dual connect by rownumSelect sysdate,sysdate+1/24,sysdate+1/1440 from dual;Select To_char (sysdate, ' Fmyyyy-mm-dd h24:mi:ss ') from dual;Select 100+NVL (null,0) from dual;Select c

syntaxes: case when field name = ... then ... (infinite access) else ... end Case field name when ... then ... (infinite access) else ... end Don't write End is a pig, forget n+1 times Decode () function The decode () function is somewhat similar to the use of Case...when Decode (field name, ' Value 1 ', ' corresponding value of value 1 ', ' Value 2 ', ' value 2 corresponding value ' ... (Infinite Connection) ..., ' Default ') Vm_concat () function Select Sname,student.sno,wm_concat (CNO) fro