SQLGrid 3

 

  Extender Commands

The following is a list of extended commands for SQL Grid:

 

DESC

Describes Oracle objects like Tables, Views, Triggers, etc....

Example:

desc g3e_report;

Output:

Describe Table: G3E_REPORT

 

Field

Type

Nullable

Comments

G3E_RPNO

NUMBER(9,0)

N

 

G3E_USERNAME

VARCHAR2(80)

N

 

G3E_DESCRIPTION

VARCHAR2(240)

Y

 

G3E_RINO

NUMBER(9,0)

N

 

G3E_INTERFACEARGUMENT

RAW(2000)

Y

 

G3E_EDITDATE

DATE

N

 

G3E_LOCALECOMMENT

VARCHAR2(240)

Y

 

 

EDIT

Opens a the table or query into an editable grid and which can be used to edit, delete and add data.

Example:

edit g3e_generalparameters;

 

EXECUTE

Executes the specified PL/SQL.

Example:

execute ltt_user.editjob('JOBNO23243');

 

EXPLAIN

Explains the steps that Oracle's optimizer will take to execute the specified query.

Example:

explain select * from g3e_report where g3e_rpno=6;

Output:

Explain:

select * from g3e_report where g3e_rpno=6

Operation

Object Name

Optimizer

Rows

Bytes

Cost

SELECT STATEMENT 

 

CHOOSE

1

576

1

    TABLE ACCESS BY INDEX ROWID

G3E_REPORT

ANALYZED

1

576

1

        INDEX UNIQUE SCAN

M_P_G3E_REPORT

ANALYZED

1

 

 

Total:

3

1152

2

 

EXPORT

Creates INSERT scripts for all of the rows in the specified table.  Where and order by clauses may be specified to filter the script rows.

Example:

export g3e_report where g3e_rino = 5 order by g3e_username;

Output:

insert into G3E_REPORT
values (52, 'Cable Fill Report', 'Cable Fill HTML Report', 5, '?templates\xslt\cablefill.xsl1', SYSDATE, NULL);

insert into G3E_REPORT
values (101, 'Cable Fill by Gauge Report', 'Cable Fill by Gauge HTML Report', 5, '?!templates\xslt\cablefillgauge.xsl1', SYSDATE, NULL);

insert into G3E_REPORT
values (99, 'HTML Report', 'Data grid style HTML Report', 5, '?templates\xslt\GenericTable.xsl11', SYSDATE, NULL);

insert into G3E_REPORT
values (5, 'Loop Makeup Report', 'Loop Makeup HTML Report', 5, '?templates\xslt\lmu.xsl1', SYSDATE, NULL);

insert into G3E_REPORT
values (103, 'Ripple Report', 'Ripple html Report', 5, '?templates\xslt\ripple.xsl1', SYSDATE, NULL);

insert into G3E_REPORT
values (104, 'Trace Count Report', 'Trace Count HTML Report', 5, '?templates\xslt\tracecount.xsl1', SYSDATE, NULL);

insert into G3E_REPORT
values (51, 'View Pairs Report', 'View Pairs HTML Report', 5, '?templates\xslt\GenericTable.xsl11', SYSDATE, NULL);

 

SCRIPT

Creates DDL script to create the specified object.

Example:

script g3e_report;

Output:

create table G3E_REPORT
  (
  G3E_RPNO                        NUMBER(9,0)    NOT NULL,
  G3E_RPNO                        NUMBER(9,0)    NOT NULL,
  G3E_USERNAME                    VARCHAR2(80)   NOT NULL,
  G3E_USERNAME                    VARCHAR2(80)   NOT NULL,
  G3E_DESCRIPTION                 VARCHAR2(240)  NULL,
  G3E_DESCRIPTION                 VARCHAR2(240)  NULL,
  G3E_RINO                        NUMBER(9,0)    NOT NULL,
  G3E_RINO                        NUMBER(9,0)    NOT NULL,
  G3E_INTERFACEARGUMENT           RAW(2000)      NULL,
  G3E_INTERFACEARGUMENT           RAW(2000)      NULL,
  G3E_EDITDATE                    DATE           NOT NULL,
  G3E_EDITDATE                    DATE           NOT NULL,
  G3E_LOCALECOMMENT               VARCHAR2(240)  NULL,
  G3E_LOCALECOMMENT               VARCHAR2(240)  NULL
  );

 

SAVERAW

Saves the result of a query to a specified file name as ADO compatible RAW file.

Example:

saveraw c:\g3e_trace_optable.raw, select * from g3e_trace_optable;

Output:

Recordset is saved to the specified RAW file.

 

SAVEXML

Saves the result of a query to a specified file name as ADO compatible XML file.

Example:

savexml c:\g3e_trace_optable.raw, select * from g3e_trace_optable;

Output:

Recordset is saved to the specified XML file.