Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 12486 Views
- TCS, I also Faced
- E-Mail Answers
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
Can cursors be part of a trigger body?
What is the requirement of self-join?
How do you sort in sql?
Is it possible to read/write files to-and-from PL/SQL?
What is PL/SQL Records?
Is big data nosql?
What are the built in functions of sql?
how to get @@error and @@rowcount at the same time? : Sql dba
Can we use threading in pl/sql?
How do I order columns in 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
define sql delete statement ? : Sql dba
What is oracle pl sql developer?
What is the difference between cross join and natural join?
What is restrict in sql?
