Basic Pl sql
Related Posts:
For loop in oracle Pl sql for loop is an iterative statement that allows to execute a series of statements a fixed number of times. The foll is a syntax for loop stat… Read More
How to call stored procedure from within another......? CREATE OR REPLACE PROCEDURE EMPANNSAL(P_SAL IN OUT NUMBER) IS BEGIN P_SAL := P_SAL*12; END EMPANNSAL; / -- INVOKING FROM THE HOST VARIABL… Read More
Basic Pl sql 1 Views 2.Conversion_Functions 3.Bind Variables 4.Constraints 4 Exit Loop … Read More
Convert Number Into Words 1. How can you convert a number into words using Oracle Sql Query? Please see the query below:- SELECT TO_CHAR (TO_DATE (523, 'j'), 'jsp') from d… Read More
How to check if a stored procedure is exist........? Oracle data dictionary also called as system catalogue.the data dictionary which contain information about database. 1.The data dictionary … Read More
0 comments:
Post a Comment
Thank you for your comments we will get back to soon