y游标整理（Y-cursor finishing）.docVIP

y游标整理（Y-cursor finishing） (nothing) Rating: Post rate: 94.00% R: 2005-09-13 09:55:20 RT, thank you! I can use [0] to drop a sheet brick [0] reference report management TOP response times: 3 hevin (nothing is impossible) Rating: 2 # 1 building score: 0 reply to: 2005-09-13 11:02:59 cursor cursorName is select_statement Ex. : Cursor mycursor is select * from tabname I can use [0] to throw a plate brick [0] reference report management TOP essence recommendation: oracle interview topic summary - (300 points)! hevin (nothing is impossible) Rating: 2 2 / f. We will discuss various DDL and TCL statements for accessing ORACLE databases. The query The SELECT statement is used to query data from the database, when using the SELECT statement in PL/SQL, should be used together with the INTO clause, the return value of a query is given in the INTO clause variables, variable declaration is in DELCARE. The SELECT INTO syntax is as follows: SELECT [DISTICT | ALL] {* | column [, column,... } INTO (variable [, variable,...] | record) The FROM {table | (sub - query)} [alias] The WHERE... The SELECT statement in PL/SQL returns only one row of data. If you have more than one row of data, then use the explicit cursor (the discussion of the cursor we will be doing later), and the INTO clause should have variables that are the same as the number of columns in the SELECT clause. The INTO clause can also be a record variable. % the TYPE attribute In PL/SQL, variables and constants can be declared as built-in or user-defined data types to reference a column name, while inheriting his data type and size. This dynamic assignment method is very useful, for instance variable reference column data types and size changed, if you are using the % TYPE, the user doesnt have to modify the code, otherwise you have to modify the code. Ex. : V_empno SCOTT. EMP. EMPNO % TYPE; V_salary EMP. SALARY is % TYPE; Not only the column names can be used with % TYPE, but the variables, cursors, records, or declared