Begin
For j in 4403201000 .. 4403202000
Loop
If mod (j, 100) = 0 then
Dbms_output.put_line (j);
End if;
End loop;
End;
what will be the output of this question
Answer Posted / shilpa.oracle
You've probably gone beyond the limit Oracle can cope with
for a number variable.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is sql scripting?
what is the difference between delete and truncate commands? : Sql dba
What are the packages in pl sql?
What are tables in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How insert into statements in sql?
What is raw datatype in sql?
how to use case expression? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
What does sign mean sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the basic sql commands?
Define commit?
Can we use pl sql in sql server?
What are the constraints available in sql?