|
Key Features
- Automatic Variable Substitution (auto binding)
- Stored Procedures/Functions - Freely usable from SQL and even C/C++
- Exception Handling
- Overload functions by type and number of parameters
- Packages
- Triggers with
procedural code
- Cursors - For-loop Implicit cursors,
Explicit cursors with arguments
- REF Cursors - strong and weak, stored procedures with REF cursor parameters
- Cursor Attributes: %IsOpen, %Found,
%NotFound, %RowCount
- Cursor Operations: Open,Open-For, Fetch, Close
- Iterative
statements - For/While/Loop
- Conditional
statements - If-Elsif-Else-Endif
- Nested blocks
- Scalar Datatypes: Numeric,Varchar,Date
- Complex Variable Types: Record, %TYPE, %ROWTYPE
- SQL: Insert/Update/Delete/ Select Into scalar or record type variables
- Transactions: Commit/Rollback
- Platforms: Windows, Linux and iPhone. More being added!
|
Try Out StepSqlite in your browser right now!
Sign In
Sign Up - FREE
Tutorial
Benefits
FAQ
Feedback
|