You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost/3051:horses' user 'sysdba' password 'masterkey';
Database: 'localhost/3051:horses', User: sysdba
SQL> select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3;
RDB$RELATION_ID
0
1
2
SQL> set term ^;
SQL> execute block
CON> returns (
CON> id integer
CON> )
CON> as
CON> begin
CON> for execute statement
CON> 'select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3'
CON> on external 'localhost/3051:horses' as user 'sysdba' password 'masterkey'
CON> into :id
CON> do suspend;
CON> end^
Submitted by: @sim1984
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost/3051:horses' user 'sysdba' password 'masterkey';
Database: 'localhost/3051:horses', User: sysdba
SQL> select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3;
RDB$RELATION_ID
SQL> set term ^;
SQL> execute block
CON> returns (
CON> id integer
CON> )
CON> as
CON> begin
CON> for execute statement
CON> 'select RDB$RELATION_ID from RDB$RELATIONS order by RDB$RELATION_ID rows 3'
CON> on external 'localhost/3051:horses' as user 'sysdba' password 'masterkey'
CON> into :id
CON> do suspend;
CON> end^
============
0
0
0
SQL> set term ;^
SQL>
Commits: 44798fb FirebirdSQL/fbt-repository@cf13bed
The text was updated successfully, but these errors were encountered: