Discover PL/SQL

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

Showing posts with label Pivot. Show all posts

Showing posts with label Pivot. Show all posts

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 No comments:

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

Older Posts Home

Subscribe to: Posts (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.