Advertisement
econz

Firebird - RDB$DB_KEY

Nov 1st, 2018
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.36 KB | None | 0 0
  1. EXECUTE block
  2. AS
  3. DECLARE vs_DB_KEY CHAR(8) CHARACTER SET OCTETS;
  4. BEGIN
  5.  
  6.    SELECT
  7.       FIRST 1
  8.       C.RDB$DB_KEY
  9.    FROM CIDADE C
  10.    WHERE
  11.       C.DESCCIDADE = 'FLORES DA CUNHA' AND
  12.       C.UF = 'RS'
  13.    INTO
  14.       :vs_DB_KEY ;
  15.      
  16.  
  17.    UPDATE CIDADE C SET
  18.       C.DESCCIDADE = C.DESCCIDADE || '*'
  19.    WHERE
  20.       C.rdb$db_key = :vs_DB_KEY ;
  21.  
  22.  
  23. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement