DECLARE
BEGIN
FOR result IN (
SELECT sysdate AS TODAY, sysdate+1 AS TOMORROW FROM DUAL
)
LOOP
dbms_output.put_line(result.TODAY|| ' ' || result.TOMORROW);
END LOOP;
END;
Code Example |
---|
Sql :: php delete database |
Sql :: declare temp table in sql |
Sql :: psql check if value in array |
Sql :: sql where not like in list |
Sql :: insert many to many sql |
Sql :: SQL SELECT TOP Equivalent in MySQL |
Sql :: top 3 salary in sql |
Sql :: union vs union all in sql |
Sql :: php insert null mysql |
Sql :: delete vs truncate sql server |
Sql :: Create the connection pool mysql2 |
Sql :: python get backup of sql |
Sql :: mysql group by |
Sql :: tsql edit table column |
Sql :: full outer join postgres |
Sql :: oracle drop type |
Sql :: sql left join with where clause |
Sql :: how to get table id sequence postgres |
Sql :: else if sql |
Sql :: having clause |
Sql :: changing column names in sql query results |
Sql :: SQL isnumeric DB2 |
Sql :: inser into example |
Sql :: oracle uptime |
Sql :: Unable to locate package libmysql-java |
Sql :: selecting specific day in colum sql |
Sql :: check if user defined table type exists in sql server |
Sql :: sql union |
Sql :: mysql having |
Sql :: how convert into in in sql query |