|
|
Replies |
Author |
Last Post |
General DBA Scripts
* Show database uptime in days and hours - http://www.orafaq.com/scripts/sql/uptime.txt
* Create database user like an exiting user (with exact privs) - http://www.orafaq.com/scripts/sql/cre8like.txt
* Switch from one database user to another without password (su.sql) -http://www.orafaq.com/scripts/sql/su.txt
* Dynamically ZIP large process trace files - http://www.orafaq.com/scripts/sql/trc_zip.txt
* Tabular display of redo-log archiving history (logs/hour) - http://www.orafaq.com/scripts/sql/archdist.txt
* List control file structures with usage limits - http://www.orafaq.com/scripts/sql/ctlimits.txt
* Log all database errors to a table - http://www.orafaq.com/scripts/plsql/db-error.txt
* Demonstrate database and schema level triggers - http://www.orafaq.com/scripts/plsql/db-trig.txt
* Limit resources using the Database Resource Manager - http://www.orafaq.com/scripts/sql/rsrc.txt
* Log Miner - extract undo statements from log files - http://www.orafaq.com/scripts/sql/logmnr.txt
* Database cursor usage (open_cursors parameter) - http://www.orafaq.com/scripts/sql/cursors.txt
* On-line table reorganizaton using the DBMS_REDEFINITION package - http://www.orafaq.com/scripts/sql/tabreorg.txt
* Create a Primary key column on a table were this is not yet available - http://www.orafaq.com/scripts/plsql/add_pk.txt |
1 |
William Hill |
William Hill
Mon Aug 02, 2010 |
General PL/SQL Scripts
Update/ delete from a huge table with intermittent commits - http://www.orafaq.com/scripts/plsql/plsloop.txt
Select records from a cursor into PL/SQL table - http://www.orafaq.com/scripts/plsql/plstable.txt
Password encrypt/decrypt using DBMS Obfuscation Toolkit - http://www.orafaq.com/scripts/plsql/password.txt
Pass result sets (REF CURSOR) between procedures and functions - http://www.orafaq.com/scripts/plsql/refcurs.txt
Random number/ string generator package - http://www.orafaq.com/scripts/plsql/random.txt
# Function to test for Leap Years - http://www.orafaq.com/scripts/plsql/leapyear.txt
Send e-mail messages from PL/SQL (using UTL_TCP) - http://www.orafaq.com/scripts/plsql/smtp.txt |
2 |
William Hill |
William Hill
Mon Aug 02, 2010 |
General SQl Script
"Who am I" script - http://www.orafaq.com/scripts/sql/whoami.txt
Select the Nth highest value from a table - http://www.orafaq.com/scripts/sql/maxvalue.txt
Select the Nth lowest value from a table - http://www.orafaq.com/scripts/sql/minvalue.txt
Demonstrate default column values - http://www.orafaq.com/scripts/sql/default.txt
Count the number of rows for ALL tables in current schema - http://www.orafaq.com/scripts/sql/countall.txt
Demonstrate Oracle database types and object tables - http://www.orafaq.com/scripts/sql/objopt.txt
Demonstrate VARRAY database types - http://www.orafaq.com/scripts/sql/varray.txt
Demonstrate Oracle temporary tables - http://www.orafaq.com/scripts/sql/temptab.txt
# Delete duplicate values from a table - http://www.orafaq.com/scripts/sql/deldup.txt |
1 |
William Hill |
William Hill
Mon Aug 02, 2010 |
SQL Tutorials3
http://www.sqltutorial.org/
http://beginner-sql-tutorial.com/sql.htm
http://www.sqlcourse2.com/
http://www.w3schools.com/sql/sql_intro.asp
http://www.plsql-tutorial.com/
http://www.sql-tutorial.com/
http://www.db.cs.ucdavis.edu/teaching/sqltutorial/
http://www.exforsys.com/tech-articles/pl-sql/step-by-step-oracle-plsql-tutorial.html |
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
SQL Tutorial 2
http://www.quackit.com/sql/tutorial/
http://www.tizag.com/sqlTutorial/
http://www.baycongroup.com/tocsql.htm
http://sqlzoo.net/
http://www.webdevelopersnotes.com/tutorials/sql/index.php3
|
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
SQL Tutorial
http://www.w3schools.com/sql/default.asp
http://www.sql-tutorial.net/
http://www.1keydata.com/sql/sql.html
http://www.sqlcourse.com/
http://www.firstsql.com/tutor.htm |
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
What is the maximum number of triggers, can apply to a single table?
12 triggers. |
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
What is the output of SIGN function?
1 for positive value,
0 for Zero,
-1 for Negative value. |
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
What are the more common pseudo-columns?
SYSDATE, USER , UID, CURVAL, NEXTVAL, ROWID, ROWNUM |
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
Other way to replace query result null value with a text
SQL> Set NULL ‘N/A’
to reset SQL> Set NULL ‘’ |
1 |
William Hill |
William Hill
Fri Jul 30, 2010 |
Invite Friends
