Discover PL/SQL

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

Showing posts with label Prefixes. Show all posts

Showing posts with label Prefixes. Show all posts

Monday, March 2, 2009

Prefixes

c_    Cursor
f_    Function
l_    Label
p_    Procedure
t_    Type
v_    Variable

Posted by Lynn Tobias at 9:26 PM No comments:

Labels: Oracle, PL/SQL, Prefixes

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.