</>
sqladvanced

Cursor - Technique 6

Work with database cursors

sql
DO $$
DECLARE
  rec RECORD;
  c CURSOR FOR SELECT id, total FROM invoices WHERE total > 1000;
BEGIN
  OPEN c;
  LOOP
    FETCH c INTO rec;
    EXIT WHEN NOT FOUND;
    RAISE NOTICE 'Invoice % => %', rec.id, rec.total;
  END LOOP;
  CLOSE c;
END;
$$;

Use Cases

  • database operations
  • data management

Tags

#sql#database#cursor

Related Snippets

Similar patterns you can reuse in the same workflow.

sqlbeginner

View - Technique 1

Create and manage database views

Best for: database operations

#sql#database
sqlintermediate

Index - Technique 2

Create and optimize database indexes

Best for: database operations

#sql#database
sqladvanced

Trigger - Technique 3

Create triggers for automatic actions

Best for: database operations

#sql#database
sqlbeginner

Procedure - Technique 4

Create stored procedures

Best for: database operations

#sql#database