Oracle9i topic
Oracle does not support Limit similar to MySQL. But you can still limit the number of rows of the returned result set. If you only want to return to the previous ten records, you can write: SELECT * from Table Where Rownum <10; but The following statement is wrong: Select * from table where rownum> 90 and rownum <100; this is because Oracle thinks this condition is not true, so there is no return. You should write this: Select * from table where rownum <101; Minus Select * from Table Where Rownum <91;
2. CURSOR C_PPP IS
Select PPP.A, PPP.B, PPP.c, PPP.D
From PPP
For update of ppp.b, ppp.d nowait;
What does "for Update of PPP.B, PPP.D NOWAIT" mean? "NOWAIT" is there or not?
Lock immediately, NOWAIT represents it immediately, the default is Wait, that is, someone is waiting for him to release it.
3. There is a table, filtered in the table, fill it into the DataGrid
DataView DV = New DataView ();
DV.TABLE = TH_ROLE.GETTABLE ();
DV.ROWFILTER = "ID = '1'";
//dv.sort = "ID DESC";
this.dataGrid1.datasource = DV;
THIS.DATAGRID1.DATABIND ();
4. SQL Server / Oracle Comparison
PL-SQL:
SELECT Utertable. *,
T.Name
From BM T,
UserTable
WHERE T.ID = utertable.bm
T-SQL:
SELECT *, BM.NAME AS BM_NAME
From utertable, bm
Where uterable.bm = bm.id
5. One person seems to function in Split (Oracle)
Create or Replace Procedure Test1is ls varcha2 (255): = '1K, 34, 6R'; POS Integer: = 0; Begin Pos: = INSTR (LS, ','); While Pos> 0 LoopInsert INTO BM (ID) Values (Substr (LS, 1, POS - 1)); LS: = Substr (LS, POS 1); POS: = INSTR (LS, ','); end loop; commit; end test1;
6. Selection of the lower flux
DropDownList_Board.Items.FindByValue (DropDownList_Board_text) .Selected = True
7. Remove the record in BB from the table AA
SELECT ID
From aa
WHERE (ID NOT IN
(Select Bb.ID)
From AA, BB
WHERE aa.id = bb.id))
