Comment Switches

August 30, 2006, 05:32:27 pm
by administrator

/*+ … */ *
Oracle SQL Hints Comment Syntax

Replies: 1    Views: 688    Started by: administrator

August 30, 2006, 05:35:17 pm
by administrator

/*ALCHEMY CREATE VIRTUAL TABLE MODIFY VALUE Tag SINGLE LETTERS CYCLE VALUES ...
Create Dynamic Virtual Tables

Replies: 2    Views: 734    Started by: administrator

August 30, 2006, 05:37:33 pm
by administrator

/*ALCHEMY DEFINE FIELDS ADD*/
Add Fields to Serduct Definition

Replies: 2    Views: 726    Started by: administrator

August 30, 2006, 05:39:04 pm
by administrator

/*ALCHEMY DEFINE TABLE TREE ADD*/
Add Folder to Table Tree

Replies: 1    Views: 632    Started by: administrator

August 30, 2006, 05:42:14 pm
by administrator

/*ALCHEMY DEFINE TABLE TREE LOCATION=###\###*/
Set location in Table Tree

Replies: 2    Views: 660    Started by: administrator

August 30, 2006, 05:44:56 pm
by administrator

/*ALCHEMY DEFINE TABLES ADD*/
Add Tables to Serduct Definition

Replies: 3    Views: 750    Started by: administrator

August 30, 2006, 05:47:48 pm
by administrator

/*ALCHEMY OPTIONS DATE TIME ON*/

Replies: 0    Views: 465    Started by: administrator

August 30, 2006, 05:49:14 pm
by administrator

/*ALCHEMY OPTIONS FROM CLAUSE BRACKET OFF*/
Used to remove all brackets from the FROM Clause

Replies: 1    Views: 643    Started by: administrator

August 30, 2006, 05:50:51 pm
by administrator

/*ALCHEMY OPTIONS GROOM CHAR COLUMNS ON*/

Replies: 0    Views: 479    Started by: administrator

August 31, 2006, 11:00:43 am
by administrator

/*ALCHEMY OPTIONS GROUP BY ORDINALS ON*/
Convert the GROUP BY items into numerical values

Replies: 1    Views: 628    Started by: administrator

August 31, 2006, 11:01:51 am
by administrator

/*ALCHEMY OPTIONS ORDER BY ORDINALS ON*/
Convert the ORDER BY items into numerical values or actual values

Replies: 1    Views: 606    Started by: administrator

August 31, 2006, 11:20:51 am
by administrator

/*ALCHEMY OPTIONS PROTECT ON*/
Protect Serduct information from being exposed

Replies: 0    Views: 426    Started by: administrator

August 31, 2006, 11:27:16 am
by administrator

/*ALCHEMY OPTIONS SQL ISNULL ON*/

Replies: 0    Views: 464    Started by: administrator

August 31, 2006, 11:29:26 am
by administrator

/*ALCHEMY OPTIONS SQL JOINS IN WHERE CLAUSE ON*/
Places join criteria in Where clause

Replies: 1    Views: 634    Started by: administrator

August 31, 2006, 11:30:35 am
by administrator

/*ALCHEMY OPTIONS SQL LIKE ON*/

Replies: 0    Views: 404    Started by: administrator

August 31, 2006, 11:31:36 am
by administrator

/*ALCHEMY OPTIONS SQL SUBSTRING ON*/
Suppress SQL Substrings

Replies: 0    Views: 432    Started by: administrator

August 31, 2006, 11:32:35 am
by administrator

/*ALCHEMY OPTIONS SQL TOP ON*/
The user can also replace ON with OFF

Replies: 0    Views: 411    Started by: administrator

August 31, 2006, 11:33:20 am
by administrator

/*ALCHEMY OPTIONS SQL UCASE ON*/

Replies: 0    Views: 413    Started by: administrator

August 31, 2006, 11:34:14 am
by administrator

/*ALCHEMY OPTIONS SQL UNIONS OFF*/
Turn off UNION logic

Replies: 0    Views: 408    Started by: administrator

August 31, 2006, 11:35:18 am
by administrator

/*ALCHEMY OPTIONS WHERE CONSTANTS OFF */
This tag can also have OFF replaced with ON, to turn UNION logic back on

Replies: 0    Views: 430    Started by: administrator

August 31, 2006, 11:55:28 am
by administrator

/*ALCHEMY SESSION STATE GET*/
Retain Control Tag Details

Replies: 1    Views: 665    Started by: administrator

August 31, 2006, 11:56:29 am
by administrator

/*ALCHEMY TABLE CONTROLTAGS ARE BASED ON SUPERFIELDS*/
Force Table level control tag script to be run

Replies: 0    Views: 447    Started by: administrator

August 31, 2006, 12:00:01 pm
by administrator

/*ALCHEMY USER VALIDATION IS AFTER CONTROL TAG SECTION*/
Controls the resolving timing of the Serduct SQL U

Replies: 1    Views: 690    Started by: administrator

August 31, 2006, 12:02:05 pm
by administrator

/*ALCHEMY VALIDATE USER IS OFF*/
Controls the resolving timing of the Serduct SQL U

Replies: 1    Views: 622    Started by: administrator

August 31, 2006, 12:03:55 pm
by administrator

/*CONTROL TAG BLOCK=#####*/
Used to Create multiple line control tags

Replies: 1    Views: 599    Started by: administrator

August 31, 2006, 12:05:22 pm
by administrator

/*CREATE USER OPTIONS GROUPS */
Allows users to group User Profile options

Replies: 1    Views: 606    Started by: administrator

August 31, 2006, 12:06:27 pm
by administrator

/*EXECUTE COMMAND*/
Oracle Assist

Replies: 0    Views: 475    Started by: administrator

August 31, 2006, 12:09:49 pm
by administrator

/*HIERARCHY SHOW <ALL> OPTION*/
Allows the user to select All filter values

Replies: 1    Views: 615    Started by: administrator

August 31, 2006, 12:39:00 pm
by administrator

/*HIERARCHY SHOW CHILDREN OPTION*/
Allow descendants of a hierarchy to be filtered on

Replies: 3    Views: 760    Started by: administrator

August 31, 2006, 12:40:11 pm
by administrator

/*LANGUAGE REFERENCE TABLE EDIT CODE=1,DESC=2*/
Language Reference Table

Replies: 0    Views: 403    Started by: administrator

August 31, 2006, 12:54:27 pm
by administrator

/*LOG USER OUT OR SECURITY TABLE */
SQL Termination

Replies: 0    Views: 398    Started by: administrator

August 31, 2006, 12:55:04 pm
by administrator

/*ORACLE PARSER OFF*/
Parsing of SQL Statements - Oracle

Replies: 0    Views: 420    Started by: administrator

August 31, 2006, 12:55:38 pm
by administrator

/*REPLACE TAGS=ON*/ /*REPLACE TAGS=OFF*/
Refresh Existing Control Tag Modes

Replies: 0    Views: 521    Started by: administrator

August 31, 2006, 12:56:57 pm
by administrator

/*SUPPRESS BY FIELD*/
Suppresses transactions in Summary Links

Replies: 0    Views: 418    Started by: administrator

August 31, 2006, 12:58:14 pm
by administrator

/*SUPPRESS BY GROUP FIELD*/
Used to suppress credit and debit values in a field

Replies: 0    Views: 414    Started by: administrator

August 31, 2006, 01:03:52 pm
by administrator

/*SUPPRESS CREDITS BY FIELDS*/
Used to suppress credit values at field level

Replies: 0    Views: 387    Started by: administrator

August 31, 2006, 01:04:48 pm
by administrator

/*SUPPRESS CREDITS*/
Used to suppress credit values at transaction level

Replies: 0    Views: 374    Started by: administrator

August 31, 2006, 01:05:48 pm
by administrator

/*SUPPRESS DEBITS BY FIELDS*/
Used to suppress debit values at field level

Replies: 0    Views: 402    Started by: administrator

August 31, 2006, 01:06:58 pm
by administrator

/*SUPPRESS DEBITS*/
Used to suppress debit values at transaction level

Replies: 0    Views: 433    Started by: administrator

August 31, 2006, 01:10:56 pm
by administrator

/*SUPPRESS SQL ERRORS*/
Suppress SQL Errors

Replies: 4    Views: 901    Started by: administrator

August 31, 2006, 01:13:16 pm
by administrator

/*VBSCRIPT*/
Section of Visual Basic Script

Replies: 2    Views: 823    Started by: administrator

August 31, 2006, 01:13:58 pm
by administrator

/*VBSCRIPT=###*/
Section of Visual Basic Script with timeout

Replies: 0    Views: 428    Started by: administrator

August 31, 2006, 01:15:00 pm
by administrator

/*WHERE CLAUSE SUPPRESS*/
Suppress field in where clauses if filtered

Replies: 0    Views: 479    Started by: administrator

August 31, 2006, 01:15:36 pm
by administrator

GO
Batch Delimiter

Replies: 0    Views: 1252    Started by: administrator