By writing a "SELECT" statement with the "ROWNUM" keyword ... search_field = 'search value' AND ROWNUM = 1; IF record_exists = 1 THEN DBMS_OUTPUT.put_line('Record Exists') ELSE DBMS_OUTPUT.put ...

The query can use any DBMS-specific SQL statement or syntax that is valid for the DBMS. However, the query cannot contain a semicolon because to the SAS System, a semicolon represents the end of a ...

These arguments must be enclosed in parentheses. The CONNECT statement establishes a connection with the DBMS. You establish a connection to send SQL statements to the DBMS or to retrieve DBMS data.