Oracle classic Q A list [common]
Oracle classic Q A list [common] Directories01. What is the initial password after oracle is installed?02. What is the initial Default User and password of Oracle9
SQL Server, the stored procedures in Oracle are generally written as functions rather than PROCEDURE. Oracle stored procedures do not directly return record sets. Record Sets are returned through parameters in the form of cursors. A package can contain multiple stored procedures.Package name. Stored Procedure nameThe following is a typical
automatically process it, we only need to get the datareader and then read the data like sqlcommand in the past.
Directly execute SQL statements
":" Is used in SQL statements to indicate parameters.In SQL Server, we can use the SQL statement as follows: "insert into table (field1, field2) values (@ value1, @ value2)",
Tools-->preference-->window types-->sql window-->records Per Page 4. View Oracle Version Select Banner from Sys.v_$version 5. Automatic Login PL/SQL developer-> tools, preferences->oracle-> login History fixed user fill in the information, for example: Huilan231/[email PROTECTED]/ORCL 6. Beautify
Oracle function list:========================================================== ========================================================== ==================================PL/SQL single-row functions and group functionsA function is a program with zero or multiple parameters and a return value. Oracle has a series of
Oracle experiences 1 -- oracle introduction @ basic SQL statement @ conditional query @ sort data theory and case studies1. Oracle IntroductionOracle is the first word for English translation of oracle (Oracle bone inscriptions) U
not interfere with each other; the disadvantage is that the original optimizer only needs to parse a target SQL statement before the IN-List Expansion/OR Expansion and decide its execution plan, once IN-List Expansion/OR Expansion is performed, the optimizer performs the same resolution and decides the execution plan for each union all branch after equivalent re
1. Oracle Introduction
Oracle is the first word for English translation of oracle (Oracle bone inscriptions) Unearthed from Yin.. Oracle is the world's largest supplier of information management software and services. It was founded in 1977 and is headquartered in Redwood sh
Oracle SQL handler, yesDesigned for Oracle database developers and operatorsA carefully crafted Oracle client tool:Ultra-intelligent SQL Editor;Ultra-convenient table operations(You can update the data warehouse table by modifying the cell data of the table );Export data in
found: level specified global region invalid ORA-00081: address range [,) unreadable ORA-00082: the memory size of is not in a valid set [1], [2], ORA-00083 within [4]: warning: the SGA ORA-00084 that may corrupt the ing: The global region must be PGA, SGA, or UGAORA-00085: current call does not exist ORA-00086: User call does not exist ORA-00087: command cannot execute ORA-00088 on remote routine: Shared Server Cannot Execute Command ORA-00089: ORADEBUG command Invalid routines ORA-00090: fail
full table scan and choose the correct optimization mode: Oracle tuning:the Definitive Reference
3, the SQL adjustment strategy step
A lot of people ask SQL tuning where to start. The first thing to do is to capture the SQL statements from the library cache according to their activity status.
1, looking
"annual Salary"From EMP ORDER by 3 DESC;SELECT ename,job,sal from emp ORDER by Job,sal DESC;SELECT ename,job,sal from emp ORDER by Empno;Modify Default display widthSET line[size] {80|n}SET Line 100L display the SQL statement in the buffer you just enteredN Text modified section of error'/' (run) commandSAVEGET@ or Start command when the specified script file contents are loaded into the SQL buffer to runS
SQL optimization should be adjusted from five aspects:1. Remove unnecessary full table scans for large tables2. cache full table scan for small tables3. Verify the use of optimized Indexes4. Verify the optimized Connection Technology5. minimize the Cost of the Execution Plan
SQL statement:Is the only way to operate databases (data;70% ~ 90% of database resources; independent of the program design logic, com
the library cache object handle is stored in a hash map of the structure, then the library cache object handle is what to generate a hash value? The library cache object handle generates a hash value with its Name property and the Namespace property, and for the parent cursor is the SQL text and namespace property of the target SQL (value CRSR). Knowing the information stored in the shared cursor and how i
SQL Server parses xml to Oracle and SQL Server Oracle
Write a program: Read a table in SQLserver Based on the status bit and download the value of one of the fields. The value is of the XML type, insert the content of the XML file to another Oracle database, and update the t
backup set to unavailable.
Change backupset 33 unavailable;
A backup set marked as unavailable does not participate in crosscheck;
========================================================== ==================
========================================================== ==================
Restore directory record Deletion
1. $ ORACLE_HOME/rdbms/admin/prgrmanc. The SQL script regularly deletes records in the deleted directory.
2. to delete the o
Anonymous PL/SQL block reviewDECLARE (optional) defines the object to be used in a PL/SQL block BEGIN (MUST) EXECUTE statement EXCEPTION (optional) error-handling statement END; Must Anonymous blocks (starting with declare or begin) are compiled each time they are used. anonymous blocks are not stored in the database, and they cannot be called from other PL/SQL
website has a lot of useful scripts that you can go to see1, I personally is two ways, first in the backup recovery of the relative depth, followed by the optimizer to do a more in-depth study, and from 06 onwards, I have insisted on MOS on all aspects of the Oracle database article (this should be regarded as horizontal learning).2, Jonathan Lewis "cost Based Oracle Fundamentals" in the 4th chapter "Simpl
Oracle cold, stay at home and read the "Mastering Oracle SQL" 2nd, found that Oracle's function is still very strong, there are 200 optical functions, hsql is difficult to match. The next stubborn, it seems either to risk using Hibernate3.0 SQL mapping function, or to run the JDBC assembly VO. 1. Report Totals dedicate
point to a local directory, or a UNC path that is accessible to Oracle system users. This also means that if you have ArcSDE installed on a non-Oracle server, you must copy the shapes and raster libraries to the Oracle server. For more information, see Installing Oracle and ArcSDE on different servers.
No envir
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.