Database Oracle Tips and Tutorials, Resources

Search :   All Categories3DS MAX ASP C and Cpp ColdFusion Database Dreamweaver Flash HTML Java Javascript Linux Maya MS Excel MS PowerPoint MS Word Paint Shop Pro Perl and CGI Photoshop PHP Premiere Python Visual Basic Web Hosting XML Fireworks After Effects

Oracle tutorials

22 FAQs on Oracle SQL SELECT query statements  By lisa Rate It  | Review A collection of 22 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on starting and ending transactions, committing and rolling back transactions, transaction/statement-level read consistency, read committed isolation level, locks and dead locks.    Hits:506    Rate:  5.0(out of 5)    Vote:1   Submit Date :2006-12-05   Rate It   |  Error   |  Review

Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Clien  By lisa Rate It  | Review A collection of 25 FAQs on Oracle command-line SQL*Plus client tool. Clear answers are provided with tutorial exercises on creating tnsnames.ora and connecting to Oracle servers; SQL*Plus settings and environment variables; saving query output to files; getting query performance reports.    Hits:402    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-01-10   Rate It   |  Error   |  Review

Oracle DBA FAQ - Understanding SQL SELECT Query Statements  By lisa Rate It  | Review A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries.    Hits:344    Rate:  5.0(out of 5)    Vote:1   Submit Date :2007-04-07   Rate It   |  Error   |  Review

Oracle SQL Cheat Sheet  By Jamie Royce Rate It  | Review A quick reference guide of commonly used functions and commands in Oracle SQL that I find myself constantly referring to. A very useful resource which is regularly updated.    Hits:170    Rate:  5.0(out of 5)    Vote:1   Submit Date :2007-12-24   Rate It   |  Error   |  Review

Oracle Data Dictionary Tutorial  By paul Rate It  | Review Oracle's Data dictionary — meta-data — system & object privileges — dictionary structure — “user” tables — “all” tables — “dba” tables — “v$” tables — frequently used tables — usage examples — exercises — using the dictionary in PL/SQL programs — optional exercise.    Hits:115    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-18   Rate It   |  Error   |  Review

Oracle and Java Tutorial  By paul Rate It  | Review JDBC overview — “thin” driver — OCI driver — connecting to Oracle — a generic database access class — insert, update and select examples — exercises.    Hits:79    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-18   Rate It   |  Error   |  Review

Oracle SQL Tutorial  By paul Rate It  | Review SQL*Plus — schemata — data types — Oracle SQL DML & SQL DDL examples — editing commands — using external files — the dual pseudo-table — introduction to transactions — optional exercise — references.    Hits:65    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-12   Rate It   |  Error   |  Review

Oracle DBA FAQ - Introduction to PL/SQL  By lisa Rate It  | Review A collection of 17 FAQs to introduce PL/SQL language for DBA and developers. This FAQ can also be used as learning tutorials on creating procedures, executing procedures, using local variables, controlling execution flows, passing parameters and defining nested procedures.    Hits:19    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-09-05   Rate It   |  Error   |  Review

Oracle PL/SQL Tutorial  By paul Rate It  | Review Need for PL/SQL — declarative vs. procedural — anonymous blocks — debugging — a first program — code compilation — code execution — procedures & functions — PL/SQL in SQL — SQL in PL/SQL — cursors & loops — operators & built-in functions reference tables.    Hits:18    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-12   Rate It   |  Error   |  Review

Advanced Oracle/Java Turorial  By paul Rate It  | Review Binary large objects — Java stored procedures — call specifications — triggers.    Hits:10    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-12   Rate It   |  Error   |  Review

Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Fun  By lisa
A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.    Hits:0    Rate:  0.0(out of 5)    Vote:0   Submit Date :2008-04-26   Rate It   |  Error   |  Review

Oracle SQL Cheat Sheet  By Jamie Royce
A quick reference guide of commonly used functions and commands in Oracle SQL that I find myself constantly referring to. A very useful resource which is regularly updated.    Hits:170    Rate:  5.0(out of 5)    Vote:1   Submit Date :2007-12-24   Rate It   |  Error   |  Review

Oracle and Java Tutorial  By paul
JDBC overview — “thin” driver — OCI driver — connecting to Oracle — a generic database access class — insert, update and select examples — exercises.    Hits:79    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-18   Rate It   |  Error   |  Review

Oracle Data Dictionary Tutorial  By paul
Oracle's Data dictionary — meta-data — system & object privileges — dictionary structure — “user” tables — “all” tables — “dba” tables — “v$” tables — frequently used tables — usage examples — exercises — using the dictionary in PL/SQL programs — optional exercise.    Hits:115    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-18   Rate It   |  Error   |  Review

Advanced Oracle/Java Turorial  By paul
Binary large objects — Java stored procedures — call specifications — triggers.    Hits:10    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-12   Rate It   |  Error   |  Review

Oracle SQL Tutorial  By paul
SQL*Plus — schemata — data types — Oracle SQL DML & SQL DDL examples — editing commands — using external files — the dual pseudo-table — introduction to transactions — optional exercise — references.    Hits:65    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-12   Rate It   |  Error   |  Review

Oracle PL/SQL Tutorial  By paul
Need for PL/SQL — declarative vs. procedural — anonymous blocks — debugging — a first program — code compilation — code execution — procedures & functions — PL/SQL in SQL — SQL in PL/SQL — cursors & loops — operators & built-in functions reference tables.    Hits:18    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-11-12   Rate It   |  Error   |  Review

Oracle DBA FAQ - Introduction to PL/SQL  By lisa
A collection of 17 FAQs to introduce PL/SQL language for DBA and developers. This FAQ can also be used as learning tutorials on creating procedures, executing procedures, using local variables, controlling execution flows, passing parameters and defining nested procedures.    Hits:19    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-09-05   Rate It   |  Error   |  Review

Oracle DBA FAQ - Understanding SQL SELECT Query Statements  By lisa
A collection of 33 FAQs on Oracle SQL SELECT query statements. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views, sorting and counting query outputs, grouping outputs and applying group functions, joining tables, using subqueries.    Hits:344    Rate:  5.0(out of 5)    Vote:1   Submit Date :2007-04-07   Rate It   |  Error   |  Review

Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Clien  By lisa
A collection of 25 FAQs on Oracle command-line SQL*Plus client tool. Clear answers are provided with tutorial exercises on creating tnsnames.ora and connecting to Oracle servers; SQL*Plus settings and environment variables; saving query output to files; getting query performance reports.    Hits:402    Rate:  0.0(out of 5)    Vote:0   Submit Date :2007-01-10   Rate It   |  Error   |  Review