A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters. Stored procedures are supported by most DBMSs, but there is a fair amount of variation in their syntax and capabilities.
In order to execute a stored procedure, you need to know its name and its associated signature— the number of parameters, the type of each parameter, the mode of each parameter (IN, OUT, IN/OUT), and the result type.
Oracle Database SetupFunction created.
MySQL Database SetupQuery OK, 0 rows affected (0.01 sec)
Invoking GetStoredProcedures for MySQL
Figure :shows how to run the solution for the MySQL database.
Invoking GetStoredProcedures for Oracle
Figure :shows how to run the solution for the Oracle database.
Invoking GetStoredProcedures for Unknown Vendor
Figure :shows how to run the solution for an unknown database vendor.
JDBC Related Interview Questions
|Core Java Interview Questions||JSP Interview Questions|
|Java Servlets Interview Questions||EJB(Enterprise JavaBeans) Interview Questions|
|JSTL(JSP Standard Tag Library) Interview Questions||JNDI (Java Naming and Directory Interface) Interview Questions|
|Java Bean Utils Interview Questions||AWT (Abstract Window Toolkit) Interview Questions|
What Is Jdbc Programming?
Database Metadata, Part 1
Database Metadata, Part 2
Exploring Driver Property Information
Rowset Metadata A
Web Access To Metadata,part 1
Web Access To Metadata, Part 2
Rdf And Jdbc Metadata
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.