SQL database for enrollment system
End-to-End Hash Logon
This code is is a sample application demonstrating an End-to-End has logon process where the user's password is hashed using MD5 and compared to the stored MD5 hash of the password in the SQL database. The Hash is protected while travelling over the network by using RSA Public Key crypto between the client and the SQL Server (while changing the password) and between the DLL and the SQL database (while verifying the password).
Employee Time of Arrival (ETA) prognosticator
Got an employee or co-worker who's always late? Someone who makes their own hours? Do you want to know when they'll show up? This SQL*Plus script will cue you in to their arrival time.
EMERGENCY SHUTDOWN
Start a SQL*Plus session on your PC. Better yet, on somebody else's. Then fire off this script and, with a worried look on your face, get your DBA to come over and check it out. (Intermediate to Advanced).
Dollars And Cents To English
This PL/SQL stored function returns the English language translation of the dollars and cents input. (Range: -999999999999999.99 through 999999999999999.99).
Document Generator
generates document having the list of all the tables including their column names data types and with their extended properties also in the database
DBMS JOB job scheduler - status script
This SQL*Plus script shows data on scheduled jobs, non-broken jobs, broken jobs, and jobs currently running under the DBMS_JOB package.
DBMS JOB job scheduler - INTERVAL examples
Here are nineteen examples of scheduling jobs to run at different intervals using the DBMS_JOB package. (Intermediate to Advanced)
Subscribe to:
Posts (Atom)