![]() ![]() CLOSE the cursor in the Execution Section before you end the PL/SQL Block.FETCH the data from the cursor into PL/SQL variables or records in the Execution Section.On the next screen, click on Cursor & Pointer in the left pane. OPEN the cursor in the Execution Section. However, if you are having problems seeing the white mouse pointer, you can easily change the size and the colour of the cursor in Windows 10 to make the mouse pointer more prominent and easier to spot on the screen.DECLARE the cursor in the Declaration section.There are four steps in using an Explicit Cursor. ![]() Select_statement – A select query which returns multiple rows General syntax for creating a cursor: CURSOR cursor_name IS select_statement Ĭursor_name – A suitable name for the cursor. It is created on a SELECT Statement which returns more than one row. Such a user-defined cursor is known as an Explicit Cursor.Īn explicit cursor is defined in the declaration section of the PL/SQL Block.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |