The virtual Magic 8-Ball SQL*Plus script will answer any yes-or-no question. Just ENTER your question, shake the screen vigorously, and press ENTER. Just like the real thing, but without the icosahedral die suspended in liquid. Mystical.
Download SQL projects
Spell Number
Spell,Write,Convert digital number to text word number for more than one language(English /Arabic ..). Easy way just use function to do it from 123456789123456789 and more, The Default Currency is my (Riyal you can chaing to Doller) and 1/100 Currency( Karsh you can chaing to Cent) you can change or use parameters, Function Is ar_num(number,[Currency] Default =Riyal,[1/100] Defualt =karsh,[0/1] spell 1/100,[Ar/En] language), and more
Round Time
Based on the value of the i_minutes input, this PL/SQL stored function returns the i_date_and_time input rounded to the nearest hour, half hour, quarter hour, etc. With SQL*Plus test script.
Registration and Enrolment System - Thesis Version
Since enrolment system is not that big system so included the Registration as well to make it more interesting to use
Querie Active Directory(LDAP, ADSI)
Ledger Running Balance
To calculate Running Balance of ledger or bank statement using a query. This requires an auto number field in MS Access or number field in SQL with its identity set to yes and seed 1.
Giftland Wedding DBMS
I have developed this DBMS as part of my assignment for one of my modules. It's a DBMS for weddings. It is not a great design but can form a basis for anyone who would like to develop a database using Oracle SQL Plus. I hope someone designs it much better.
GEO Query
Provides a SQL example routine for doing Geographic Radial Searching and a lot of information regarding GEO Coding and formulas.
Subscribe to:
Posts (Atom)