Submitted by heartin on Sat, 06/07/2014 - 07:17
You can retrieve the rows into the cursor using a query and then fetch the rows one at a time from the cursor.
General steps when using a cursor with simple LOOP:
Submitted by heartin on Sat, 06/07/2014 - 07:14
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
Submitted by sneha on Fri, 06/06/2014 - 23:40
Steps verified for versions: 5.6.19. Steps last verified on: 7/JUN/2014.
We can easily install the free MySQL community server on Windows following the below simple steps:
Step 1: Download MySQL community server latest version. Current download page link is http://dev.mysql.com/downloads/mysql.
Submitted by heartin on Sun, 06/01/2014 - 12:41
Setter injection and constructor injection are two of the ways in which we can inject data into an object through xml configuration files. We will reuse the same examples we were working on till now for this note also.
Setter Injection (Property Initialization)
If you have a property in your bean class, you can initialize it using the property tag within the bean tag.
Submitted by heartin on Sun, 06/01/2014 - 12:16
We will use Gradle build tool in this example for creating your first spring program. All other notes in this section will be using Maven in general. You can refer to our notes section on Gradle for learning more about Gradle and translating the maven dependencies I specify. If you go to the Spring Framework page, you can see dependency details for Maven or Gradle builds.
Pages