326 (0)
Basic (2)
Plsql (41)
Sql (18)
 
61 Source Code Found
Sort By Descending Descending
Creating a View in PL/SQL InPLSQL
With a view you can build a select statement and then everytime you call the view it runs without you needing to build the SQL statement again. So if I created this View:... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:5543

 
Creating a Sequence in PL/SQL InPLSQL
sequence specifies a unique value. This one will give us the number 1 the first time we use it. Then it will give us 2 then 3 etc.. if for some reason the order gets messed up it will skip 20 numbers then give us the next number in the sequence.... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:6916

 
Selecting the Next available Sequence number in PL/SQL InPLSQL
The Dual table is a special table that exists in oracle, it keeps track of sequence information for you. You can query it to return the next number in your sequence like this:... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:3786

 
Creating a Synonym in PL/SQL InPLSQL
There are many uses for Synonymns, this is but one small example of using the Synonym Client to refer to the Customer Table... read more
Author: mobeenamjad Reviews:1 Date:12th Jun, 2007 Rating:Poor Accessed:4271

 
Deleting Constraints with a Table in PL/SQL InPLSQL
Deleting Constraints with a Table in PL/SQL... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:2850

 
Determining if a Operation Worked in PL/SQL InPLSQL
You can use the %NOTFOUND parameter to determine if the update was sucessful, and then insert if the update did not work... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:1894

 
A Simple Loop in PL/SQL InPLSQL
A Simple Loop in PL/SQL... read more
Author: mobeenamjad Reviews:1 Date:12th Jun, 2007 Rating:Poor Accessed:3201

 
Creating a Cursor in PL/SQL InPLSQL
Creating a Cursor in PL/SQL... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:2748

 
Loading Data from a Cusor in PL/SQL InPLSQL
This creates a cusor and then keeps looping until it has reached the end of the data using %NOTFOUND.... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:1997

 
Creating a Trigger in PL/SQL InPLSQL
This trigger will be added to the Customer table and will stop you from entering people whos name has the word SMITH in it.... read more
Author: mobeenamjad Reviews:0 Date:12th Jun, 2007 Rating:No Rating Accessed:3700

 
1 - 10 of 61 First | Previous | Next | Last  

Copyright © 2014 VisualBuilder. All rights reserved