Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Write a PL/SQL to print even numbers upto 100.

Declare
NUM1 number:=0;
begin
loop
NUM1 := NUM1+2;
dbms_output.put_line (NUM1||',');
exit when NUM1=100;
end loop;
end;
Comment

PREVIOUS NEXT
Code Example
Sql :: calculer pourcentage mysql 
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause 
Sql :: logical operators in sql 
Sql :: sqlcmd no headers 
Sql :: Search In the Database using Text 
Sql :: alter in sql 
Sql :: query inner join 
Sql :: mysql order by rand limit 1 really slow 
Sql :: uuid sqlalcomany 
Sql :: mssql default connection string 
Sql :: create atable copy in pgsql 
Sql :: offset in postgresql example 
Sql :: sql check constraint 
Sql :: rownum in sql 
Sql :: generate random data in mysql 
Sql :: update multiple rows 
Sql :: how convert into in in sql query 
Sql :: syntax error at or near "AUTO_INCREMENT" 
Sql :: oracle job schedules 
Sql :: postgres insert new row advance count 
Sql :: set value to null postgres 
Sql :: mamp mysql password 
Sql :: mysql earlier than date 
Sql :: data types in sql 
Sql :: postgres drop type 
Sql :: postgres enumerated type 
Sql :: sql constraints 
Sql :: delete join sql server 
Sql :: select first and last row mysql 
Sql :: how to link java and mysql 
ADD CONTENT
Topic
Content
Source link
Name
1+6 =