Discover PL/SQL

Simple examples of PL/SQL using Oracle's HR schema

Tuesday, March 3, 2009

Links to PL/SQL Code in My Main Blog

Execute Immediate: Count Rows in All Tables
Validate a Date
Character Set
Loop Creates Pivot

Posted by Lynn Tobias at 11:47 AM

Labels: Character, Date, Execute Immediate, Oracle, Pivot, PL/SQL

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

By: Twitter Buttons

Links

Oracle SQL Developer
OTN: PL/SQL Technology Center
Oracle® PL/SQL User's Guide and Reference 11g
Steven Feuerstein

Labels

%[Row]Type (1) Anonymous Block (2) Attributes (1) Audit Trail (1) Autonomous_Transaction (1) Bind Variables (1) Blob (1) Blocks (2) Boolean (2) Case (1) Character (1) Chr(10) (1) Clob (1) Close (1) Compile (2) Continue (1) Count (1) Cursor (3) Data Types (1) Date (1) DBMS_Output.Put_Line (3) Dbms_Warning (2) Dup_Val_On_Index (1) ElsIf (1) Error (1) Errors (1) Exception (1) Exception Handling (2) Exception_Init (2) Execute Immediate (1) Fetch (1) For Loop (2) Function (4) Functions (1) GoTo (1) HR Schema (1) If (2) InitCap (1) Inline (1) Insert (1) Instead of (1) Invalid (1) Labels (1) Lob (1) Log File (1) Loops (4) Named Block (1) Nested Cursor (1) Null (1) Nvl (1) Open (1) Ora- (1) Oracle (40) Others (1) Parameters (1) Pivot (1) PL/SQL (40) PLSql_Optimize_Level (1) PlSql_Warnings (2) PLW- (1) Pragma (3) Prefixes (1) Procedures (4) Propagation (1) Raise (1) Raise_Application_Error (1) Refcursor (1) RowType (1) Savepoint (1) Scope (2) SQL%NotFound (1) SqlCode (2) SqlErrM (2) Standards (1) Subprogram Inlining (1) SubType (1) Trigger (2) Types (1) Update (1) User-Defined Types (1) User-Raised Exception (1) Variables (2) Visibility (1) While Loop (1)

Amazon.com Widgets

Knowledge Base for PL/SQL

About Me

Lynn Tobias: I've been in IT almost since birth. I've done many things with many languages and operating systems, but finally found a home when I started learning Oracle.

SQL is just plain fun when you're trying to resolve a puzzle. Always searching in the books for that new function or statement, I was able to get certified in 9i SQL.

I took a hiatus from it all for personal reasons, but I'm back in college and am currently studying Database Administration with plans of getting certified.

Want to drive me crazy? Tell me you can't do that in SQL. Anyway, hope you enjoy the blog.

View my complete profile

StatCounter.Com

Picture Window theme. Powered by Blogger.