2-2-7 Other Methods of Using SQL · ITPEC FE Textbook

ITPEC Textbook

Reading settings

Text size 20 px

Line spacing 1.75

Theme

Reading mode

Guest settings stay on this device. Sign in to sync reader settings.

Chapter 4 · DatabasePractice

Highlighted text? Practice this concept. Highlighted passages and figures open related questions.

Practice related questions (1)Progress & bookmarks

Current section

2-2-7 Other Methods of Using SQL

p. 277

Progress

Not marked complete

Related questions in this lesson 1

DECLARE CURSOR in the original cursor list1

Progress and bookmarks

p. 277

2-2-7 Other Methods of Using SQL

(1) Other data manipulation languages

• INSERT statement: This statement is used when a tuple is inserted (i.e., added) into the table.

Original textbook table, example or syntax box, with its complete original layout. Source text: INSERT INTO Table name VALUES ( Data 1, Data 2, ••• ) — p. 277 · Enlarge

• UPDATE statement: This statement is used when the data in the table is updated (i.e.,
changed).

Original textbook table, example or syntax box, with its complete original layout. Source text: UPDATE Table name SET Column name = Updated value WHERE Update specification condition — p. 277 · Enlarge

p. 278

• DELETE statement: This statement is used when a tuple is deleted from the table.

Original textbook table, example or syntax box, with its complete original layout. Source text: DELETE FROM Table name WHERE Delete specification condition — p. 278 · Enlarge

(2) Cursor

Cursor is used when data in the database is used in the host language system (i.e., embedded SQL). Usually, host language (i.e., programming language) handles data in units of records, while SQL handles data in units of sets. Therefore, the cursor acts as a bridge by fetching and transferring one row at a time.

• DECLARE CURSOR statement: This statement defines the derived table to be processed
and assigns the cursor. · 1 question

Original textbook table, example or syntax box, with its complete original layout. Source text: DECLARE Cursor name CURSOR FOR SELECT … Note: Dynamic SQL is also available that prepares the SELECT statement at the time of execution by using the PREPARE statement. — p. 278 · Enlarge

• OPEN statement: This statement starts the process of cursor.

Original textbook table, example or syntax box, with its complete original layout. Source text: OPEN Cursor name — p. 278 · Enlarge

• FETCH statement: This statement reads data from the position of cursor.

Original textbook table, example or syntax box, with its complete original layout. Source text: FETCH Cursor name INTO Variable name — p. 278 · Enlarge

• CLOSE statement: This statement terminates the process of cursor.

Original textbook table, example or syntax box, with its complete original layout. Source text: CLOSE Cursor name — p. 278 · Enlarge

Section progress

Practice declare cursor in the original cursor list (1)

Original chapter exercises

Original chapter exercises →

New FE Textbook Vol.1 · IT Fundamentals · First Edition, April 2015