Everything about database,how to,example,guide, - Oracle Tutorialhttp://teachmesql.net/MSSQL Tutorial,MySql Tutorial,access Tutorial,Foxpro Tutorial,Oracle Tutorial,PowerBuilder,how to database,intro to database,intro to mysql,intro to sql,intro to foxpro, - RainbowSoft Studio Z-Blog 1.8 Arwen Build 81206zh-CNCopyright 2008 teachmesql.net. Some Rights Reserved.Tue, 07 Sep 2010 23:33:19 +0800Three problems of Oracle Indexa@b.com (rain)http://teachmesql.net/post/513.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/513.htmlIndex (Index) is common database object,Its setting stand or fall, use proper,The performance that affects database application process and Database greatly.Although a lot of data say the use of index,DBA and Developer people also often with its contact with,But the author discovers,Still not little person is misunderstood to its existence,In the light of the common problem in using because of this,Discuss three issues.The database that place of all give typical examples uses this language is Oracle 8.1.7 OPS On HP N Series, give typical examples is real data entirely,The reader does not need to note specific data size,And after should noticing to using different method,The comparison of data.Article place is told basic it is truism,But the author tries to pass concrete example,The key that will let you understand a business truly.

...]]>Oracle Tutorialhttp://teachmesql.net/post/513.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=513http://teachmesql.net/cmd.asp?act=tb&id=513&key=2ee4a39bThe space of Oracle database runs skilla@b.com (rain)http://teachmesql.net/post/503.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/503.htmlIn Oracle database,The use state that DBA can be expressed certainly through observation or view understands current space,The adjustment that makes a likelihood then decides.

One. Express free space of the space

...]]>Oracle Tutorialhttp://teachmesql.net/post/503.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=503http://teachmesql.net/cmd.asp?act=tb&id=503&key=c44abfb3The character set in Oracle 8i is piled up in disorder settle waya@b.com (rain)http://teachmesql.net/post/504.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/504.htmlOne, problem description

The SQL statement editor that SQL Plus WorkSheet is interface of graph of a window,To those like window interface and liking the user of character interface,This tool got relative to SQL/PLUS very big welcome.But from Oracle 8i later,If install what choose when Oracle 8i,be to fasten at English character set,To our China,Can choose simplified Chinese character set normally (ZHS16GBK) ,After installation is successful,Program of moving SQL Plus WorkSheet,Can appear all Chinese show and the circumstance that inquiry all piles up for chaos as a result.

...]]>Oracle Tutorialhttp://teachmesql.net/post/504.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=504http://teachmesql.net/cmd.asp?act=tb&id=504&key=17930ab9Understand Oracle database deeply start and shuta@b.com (rain)http://teachmesql.net/post/505.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/505.htmlThe database that Oracle database offerred a few kinds to differ is started and close kind,The function that the article will introduce to these are started and shut the distinction between means and them to differ severally in detail.

...]]>Oracle Tutorialhttp://teachmesql.net/post/505.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=505http://teachmesql.net/cmd.asp?act=tb&id=505&key=77e64b28Why duration need not index according to the library will search dataa@b.com (rain)http://teachmesql.net/post/506.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/506.htmlUse SQL language when you,When issueing an inquiry statement to the database,ORACLE will accompany generation " executive plan " ,Namely this statement will be passed why to plant data search program is carried out,It is to carry complete list scanning, still search for through index wait for other means.Search plan choose with ORACLE optimize implement be closely bound up.

...]]>Oracle Tutorialhttp://teachmesql.net/post/506.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=506http://teachmesql.net/cmd.asp?act=tb&id=506&key=97e9d456Oracle database system uses experience sixa@b.com (rain)http://teachmesql.net/post/507.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/507.htmlThe usage of 1.having clause

The travel form that Having clause decides to clause of Group By undertakes controlling, allow to involve constant only in Having clausal condition, get together the row in form function or clause of Group By.

...]]>Oracle Tutorialhttp://teachmesql.net/post/507.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=507http://teachmesql.net/cmd.asp?act=tb&id=507&key=c048ec77The use of file of Oracle database password and safeguarda@b.com (rain)http://teachmesql.net/post/508.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/508.htmlSchematic:System of Oracle relation database won wide application with its outstanding performance,And the serious content that makes sure the security of the database is database management job.The article is the author on the foundation that supervises the work in safety of summary Oracle database,To file of password of Oracle database system found, use and safeguarded detailed introduction,Consult for everybody.

...]]>Oracle Tutorialhttp://teachmesql.net/post/508.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=508http://teachmesql.net/cmd.asp?act=tb&id=508&key=c92cdd4aOracle database manages script to name a standarda@b.com (rain)http://teachmesql.net/post/509.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/509.htmlThe data dictionary in Oracle is the very important one part in the database,The information that provided relevant database,It is all Oracle user (from the design of final user of application, application developer arrives database manager) very main news source.Of data dictionary found,It is in Oracle the database is founded after ending,Run a few relevant databases to manage script to finish.Should use Oracle to unite installation implement (Oracle Universal Installer) when founding a database,The lexical view that Oracle server concerns and script can be installed automatically finally.But upgrade when need when current Oracle database server,Database manager must want to run the SQL that founds these view or script afresh by hand.After installing a database,Scenario of Oracle database administration is deposited in the operating system.To UNIX and NT operating system,Be located in respectively below diverse physical list,See the watch is shown 1 times:

...]]>Oracle Tutorialhttp://teachmesql.net/post/509.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=509http://teachmesql.net/cmd.asp?act=tb&id=509&key=f6f70ac5The analysis of code of Oracle common error and solvea@b.com (rain)http://teachmesql.net/post/510.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/510.htmlThe process that using ORACLE passes,The mistake that we often can encounter a few ORACLE to arise,To abecedarian,These wrong likelihoods are a bit ambiguous,And these errors that the likelihood does not realize how to handle generation temporarily,Oneself are used in appear compare frequent wrong code to make an analysis one by one,The hope can help you find to add up to the method that manage solves these mistakes,The different view that also hopes you can put forward you at the same time.The method that communicates as a kind after all,Individual opinion hard to avoid too biased,And sure also existence is worn insufficient,The place that make mistake unavoidable.The purpose that writes this article wants to pass namely mutual the communication between is promoted jointly,Collective progress.

...]]>Oracle Tutorialhttp://teachmesql.net/post/510.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=510http://teachmesql.net/cmd.asp?act=tb&id=510&key=e75410d3Foundation of Oracle PL/SQL languagea@b.com (rain)http://teachmesql.net/post/479.htmlTue, 03 Mar 2009 09:37:52 +0800http://teachmesql.net/post/479.html
? ?The advantage of PL/SQL

? ? from version 6 began PL/SQL to be gone to by reliable conformity in ORACLE,The convenience sex that once master the advantage of PL/SQL and its particular data,manages,So the scenario that you imagine very hard to ORACLE was short of PL/SQL.The product that PL/SQL is not an independence,He is a conformity to the technology in ORACLE server and ORACLE tool,Can regard PL/SQL an engine inside ORACLE server,The Sql statement with single processing of Sql statement executant,PL/SQL engine handles PL/SQL program block.When PL/SQL engine is handled when PL/SQL program block,The SQL statement in ORACLE server is carried out implement the SQL statement in handling Pl/sql program block.

? ?The advantage of PL/SQL is as follows:

? ? . PL/SQL is a kind of high-powered language that is based on clerical processing,In can moving in any ORACLE environments,Supportive place know exactly about sth commands according to processing.The data definition that handles SQL through using PL/SQL task and data control element.

? ? . PL/SQL supports type of all SQL data and all SQL function,Back kind of all ORACLE object at the same time

? ? . PL/SQL piece can be named and store in ORACLE server,Also can be called by other PL/SQL programs or SQL command at the same time,Any clients / server tool can visit PL/SQL program,Have very good but sex of put sb in a very important position.

? ? . Can use ORACLE data tool to manage memory the security of the PL/SQL program in the server.Can other user visits accredit or cancel database the ability of PL/SQL program.

? ? . PL/SQL code can use any ASCII text editors to write,The operating system that can run to any ORACLE so is very convenience

? ? . To SQL,ORACLE must handle each SQL sentence in same time,Below network environment this makes each be called independently with respect to imply must be handled by Oracle server,This takes up many server time,Cause network jam at the same time.And PL/SQL is with whole statement piece send a server,This reduced network jam.

? ?PL/SQL cake compose

The language that ? ? PL/SQL is compose of a kind of cake,The unit that forms PL/SQL program is logic piece,Program of a PL/SQL included one or more logic piece,Every piece can differentiate for three parts.As identical as other language,Variable must state before use,What PL/SQL offerred independence is special at treating unusual share with,PL/SQL was described below piece different share:

? ?Statement part (Declaration Section)

The data type that ? ? states the part included variable and constant and initiative value.This part is by key word DECLARE is begun,If do not need statement variable or constant,So negligible this one part;The statement that those who need a specification is cursor also is in this one part.

? ?Executive part (Executable Section)

? ? executive part is PL/SQL piece medium instruction part,Begin by key word BEGIN,All executable statements are put in this one part,Other PL/SQL piece also can put in this one part.

? ?Unusual processing part (Exception Section)

? ? this one part is optional,Handle in this one part unusual or wrong,To the bat around of unusual processing we undertake at the back.

? ?PL/SQL piece syntactic


...]]>Oracle Tutorialhttp://teachmesql.net/post/479.html#commenthttp://teachmesql.net/http://teachmesql.net/feed.asp?cmt=479http://teachmesql.net/cmd.asp?act=tb&id=479&key=f42a28ae