Oracle

1. Declaring cursorsDeclareteacher_id Number(5); Teacher_namevarchar2(5); Teacher_titlevarchar2( -); Teacher_sexChar(1);cursorTeacher_cur is SelectTid,tiname,title,sex fromTeacherswhereTid117;2. Open the cursorOpen cursor name;Declareteacher_id

A view is a stored query definition.1. The syntax for creating a view is as follows:Create [OR REPLACE] [Force | Noforce] VIEW view_name[(Alias,alias,...)] Asselect_statement [with CHECK OPTION [CONSTRAINT CONSTRAINT]] [with READ only];Where: OR

One, the data blockThe unit in which Oracle manages storage space in a database data file is a block of data. A data block is the smallest (logical) unit of data in a database and is the smallest I/O unit. Corresponding to the data block, the

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

Long time not to write the text, recently hollow write a little. Oracle database The number of domestic users is mainly in the enterprise, where there is a byte storage called blob, and can not be directly seen.Sometimes in order to debug the need,

1. Standard SQL specificationOne, single IF1, if A= ... Then.........end if;2, if a= ... then......else....end if; two, more IfIf a=. Then......elsif a=. Then....end if; The middle here is "elsif", not else IF. Special attention is needed

--Creating a stored procedure for adding a local database Create or replaceprocedure Pro_electric_record as begin insert into Electric_meter_record (Id,basestati On_id,name,meter_number,createtime) Select Sys_guid (), substr (s.sname,0,36),

Create a database1 Creating an Oracle database using the Database Configuration Assistant toolStep One Action windowThere are 4 choices. A CREATE Database B metabase option C Delete database D Administrative TemplatesStep Two Database Template

--Data paging scripts--Create a header structure that contains the data pagination code element declarationCreate or Replace package Data_controlIsType type_cursor_data is REF CURSOR;V_totalline int; --Total number of data rowsV_totalpage int;

installation of Oracle database :One:Install the time can be set to unlock the user generally by default is to unlock SOCTT users and HR users;Oracle's Super User is SYSDBA This user can also set a password when installing, aYou can set the password

12. Check the average score of the course with at least 5 students enrolled in the score table and begin with 3.Select cno,Count(CNO),avgfromgroup by has Count(CNO)>=5 and substr (CNO,0,1)=' 3'13, the query score is greater than 70, less than 90 of

additionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

One, theOracle data dictionary is composed of the following views mainly:1.user ViewUse User_ as a prefix to record information about user objects2.all ViewAll_, which is used to record the information of the user object and the object information

There are many date conversion functions in Oracle, and the common commands are as follows: The To_char () command converts a timestamp to a user-specified date format, such as: SELECT to_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from

Source: http://www.cnblogs.com/ningvsban/p/3603678.htmlThere is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.Workaround:1) Insert a row, and then rollback will produce segment.The method is to

---restore content starts---First, error injection(1) User name explosion (for: oracle8,9 and 10g):http://192.168. 2.10 /Ora2.php?name=1' and 1=utl_inaddr.get_host_name ((select User from Dual))-- (2) Fetching information based on error injection

Need to use a geoserver to combine with Oracle to display GIS informationResults when the layer is displayed, tomcat errorsAfter querying the data, we need to establish a spatial indexWhen you create an index, you don't know what to name and which

Java usesJdbc:oracle:thin:@11.1.0.14:1521:orclConnecting to an Oracle database appears:Ora-12505,tns:listener does not currently know of SID given in Connect descriptorError.Indicates that a service with Sid ORCL on the server does not exist and can

SELECT * FROM V$sqlarea t ORDER by t.last_active_time DESCNote: Some related statements, such as executing this statement, must have DBA authority although this statement is common but useful when needed to detect a person executing a SQL statement

I. Related content1. Master the basic concepts of user, program and authority.2. Master the command of user operation.Second, the specific operation(a) Select the title:1. Description of the programme which one of the following is incorrect? CA.