View source for Yurttas/PL/DBL/postgres/F/01/Company-B/q17.sql

← Yurttas/PL/DBL/postgres/F/01/Company-B/q17.sql

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: writer.

You can view and copy the source of this page.

<syntaxhighlight lang="sql" line start="1" enclose="div">/*
REM
REM q17.sql
REM
REM Delete all tuples in the works relation for employees
REM of 'Small Bank Corporation'.
REM
*/

SELECT current_schema();
SET search_path to "companyb";

DELETE FROM Works
WHERE companyname = 'Small Bank Corporation';
</syntaxhighlight>

Return to Yurttas/PL/DBL/postgres/F/01/Company-B/q17.sql.

Retrieved from "http://wiki.zcubes.com/Yurttas/PL/DBL/postgres/F/01/Company-B/q17.sql"