i m new to pl/sql and trying to print even numbers up till 100 using the following code: Declare i number; sum number:=0; x number:=2; n number; Begin for i in 1..100 loop ...

I have a fairly complex query that will be referencing a single date as a start or stop date multiple times throughout. I m going to have to run this query for 3 different fiscal years, and don t want ...

Working with Oracle 11g here. I m trying to figure out how to write a specific query against a sample table below: ID TYPE PRIORITY STATUS DATE ----------------------------------------------...

the following text is an excerpt of oracle documentation Oracle® Database PL/SQL Language Reference 11g Release 1 (11.1) : Unhandled exceptions can also affect subprograms. If you exit a ...

What would be the datatype in java equivalent to the PL/SQL datatype BINARY_INTEGER?

This is one of those "there s gotta be a better way" questions. Let me set up the problem, then I ll give you my hacked solution, and perhaps you can suggest a better solution. Thanks! Lets take this ...

I have a number of pl/sql procedures that can take several minutes to run. While developing them, I ve added a few print statements to help debug and also provide some feedback and progress indicators....

I m new to PL/SQL and I m trying to use a table of records, but I don t know how to use this feature. What is the problem? DECLARE TYPE TIP IS RECORD ( F1 ...