Hello Aaron,

Thank you for trying Guggi Oracle.

It seems that one of the dlls is not installed properly on the
computer running Guggi Oracle.

The software uses Oracle Objects for Ole (OO4O) for implementing some
of the features such as background SQL.

Please let me know which version of Oracle you are using.

Do you have following files in the ORACLE_HOME/bin folder:

oip10.dll or oip9.ddl
oip10.tlb  or oip9.tlb
oraansi.dll

How difficult will it be to install Oracle Objects for Ole on your
machine?  It comes on Oracle Client CD.  Just install Oracle Objects
for Ole (OO4O).  Otherwise, I will provide the files and a set of
instructions to install these files.

Also, can you compile this test procedure and see if you are able to
compile it ....

CREATE OR REPLACE PROCEDURE prc_test
IS
BEGIN
   null;
END;

Also, is anyone else in your group also facing the same problem?

Regards

Shakti

--- In guggiusers@yahoogroups.com, Aaron Stallfus <astallfus@l...>
wrote:
>
> Good day,
>
> I am an associate of Dan, who emailed you last week. I am
experiencing a
> difficulty with Guggi that I would appreciate some assistance with.
When I
> attempt to run an UPDATE query in the SQL Editor I receive errors
and the
> update does not happen.
>
> I am trying to run the following query.
>
> update table1
> set val4 = 'x4'
> where val1 = 'x1' and val2 = 'x2' and val3 = 'x3'
>
> I highlight the query and click on the black arrow pointing left
(Run sql
> Statement). The Background SQL window appears with my query in it.
When I
> click the black arrow pointing left I receive an error message
stating that
> the "ActiveX component can't create object." When I click on
anything else I
> receive "Object variable or With block variable not set." This
includes the
> four icons to the right of the black arrow pointing left and the
red X icon
> in the upper right hand corner. When I attempt to run an INSERT
query the
> same sequence of events occur.
>
> Thank you in advance for your help,
> Aaron
>

Hi Dan,

I am glad that the changes worked.  The patch to make
the SQL execute with a semi-colon at the end also has
been developed.  Version 1.5.3 of Guggi Oracle will be
released by the end of this week or early next week.

Please let me know what problems were encountered when
you tried to connect suing Oracle's OleDB.

The run as script functionality is there to execute
DDL and DML statements and not SELECT statements.
This is similar to the functionality in SQL*Plus where
you execute a file containing SQL statements (DML/DDL)
using the "@" symbol.

If any error is encountered then the SQL statement and
the error is captured and displayed to the user.
Semicolon is used to identify the end of the statement
in a script containing multiple statements.

In 1.5.3 you would be able to execute your SELECT
statements ending in a semi-colon.

Can you please provide an example of the last
statement in your email?  I am not sure which UP and
DOWN arrows are being referred to (keyboard or in the
toolbar).  If you make a change to a field in a given
record and want to commit the change, then click the
"tick mark" icon after making the change.  In other
words, the change(s) are followed by a single click of
"tick mark" to commit(accept) the changes.  Tab key
need not be used to commit changes.

Please let us know if there are any other enhancement
requests that you may have.

Regards,

Shakti

--- Dan Corso <dccorso@...> wrote:

> Thanks for your quick response on this Shakti.  I
> hadn't had time to test the changes until today, but
> your recommendations and patch seem to have worked.
> For some reason, I didn't think of using the
> Microsoft
> oleDB driver for loading the TNS profile- I couldn't
> get the Oracle one to work, so I just set up the
> ODBC
> connections.
>
> When I run the query now, I can only run it as a
> statement though, I can't run it as a script.  I
> still
> get the expected output(which works for me- just a
> change in my approach), but the "run as script"
> function just does nothing-unless I add the
> semicolon-
> then it errors :-)
>
> Also, many people in my group use the schema browser
> to make changes to several rows at a time for a
> single
> field.  Is there an enhancement in the works to
> allow
> a change to a row and just use the up/down arrow to
> modify the next field rather than hit either enter
> and
> arrow or tab and arrow?
>
> --- "Shakti <skgoel@...>"
> <shakti_k_goel@...> wrote:
>
> > Hello Dan,
> >
> > Thank you for your interest in Guggi Oracle.
> >
> > We would recommend using Oracle OleDb by Oracle
> > option
> > to execute queries.  OleDb driver supports most of
> > the
> > functionality of Oracle whereas ODBC driver can be
> > sometimes limiting.
> >
> > If you have Oracle client installed then Oledb is
> > automatically installed with it, and you would not
> > need to take any additional steps.
> >
> > The issue that you have encountered below is as
> > follows:
> >
> > The tool does not recognize "." as an end-of-word
> > character.  Therefore, it treats the entire string
> >
> > &START_DD.&START_MM.2005:00:00:00'
> >
> > as one parameter.
> >
> > In order for the script to work, please make the
> > following changes
> >
> > '&START_DD . &START_MM . 2005:00:00:00'
> >
> > In other words, insert a space before and after
> the
> > period (".")character.  The tool will then
> recognize
> > start_dd as a single parameter and same for other
> > three parameters.
> >
> > We have tested this using OleDb driver.
> >
> > SELECT *
> >   FROM emp
> > WHERE  hiredate BETWEEN TO_DATE ('&START_DD .
> > &START_MM .1981:00:00:00',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> >                                       )
> >                           AND TO_DATE
> > ('&END_DD . &END_MM .1981:23:59:59',
> >                                        'DD
> > .MM.YYYY:HH24:MI:SS'
> >                                       )
> >
> >
> > We will add an option in the tool to recognize "."
> > as
> > a character.  This option will be placed in the
> > Application Options form.  You can then turn
> on-this
> > option.
> >
> > Also, the OleDb  and ODBC drivers do not recognize
> > ";"
> > as a valid character at the end of SQL statement.
> > We
> > are making enhancements to the product to address
> > this
> > issue as well.
> >
> > Hope the response addresses the immediate issue.
> > Please let us know if you have any more questions.
> >
> > Regards,
> >
> > Shakti
> > Sales - Impact Solutions
> > http://www.impact-sol.com
> > Developers of Guggi Oracle - Tool for DBAs and
> > Developers
> >
> >
> > --- Dan <dccorso@...> wrote:
> >
> > > Hi,
> > >
> > > I'm evaluating this product to replace TOAD in
> our
> > > workplace.  We
> > > are budget cutting :-)
> > >
> > > We'll need 10 licenses, but while I'm testing
> > > scripts that run in
> > > TOAD, I get some funky errors in this.  I was
> > > wondering if some
> > > light could be shed on them, and what I need to
> do
> > > to get the
> > > scripts to execute properly?
> > >
> > > Here's what I'm sending:
> > > SELECT val1, val2, COUNT(1)
> > >   FROM table1
> > >  WHERE (   val3 in ('x1','x2','x3')
> > >        )
> > >    AND val4 BETWEEN TO_DATE
> > > ('&START_DD.&START_MM.2005:00:00:00',
> > >
> > > 'DD.MM.YYYY:HH24:MI:SS'
> > >                                       )
> > >                           AND TO_DATE
> > > ('&END_DD.&END_MM.2005:23:59:59',
> > >
> > > 'DD.MM.YYYY:HH24:MI:SS'
> > >                                       )
> > >
> > >  group by val1, val2;
> > >
> > > Here's the error that's coming out when I run it
> > as
> > > a script:
> > >
> > > [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
> > > PLS-00103: Encountered the symbol "" when
> > expecting
> > > one of the
> > > following:
> > >    begin declare exit for goto if loop mod null
> > > pragma raise
> > >    return select update while <an identifier>
> > >    <a double-quoted delimited-identifier> <a
> bind
> > > variable> <<
> > >    close current delete fetch lock insert open
> > > rollback
> > >    savepoint set sql execute commit forall
> > >    <a single-quoted SQL string>
> > > The symbol "" was ignored.
> > > ORA-06550: line 12, column 50:
> > > PLS-00103: Encountered the sy
> > >
> > > Now, I know if I were to replace the
> > > &START_DD.&START_MM and
> > > &END_DD.&END_MM with solid values, it will run
> > fine,
> > > but I run these
> > > regularly and prefer the prompts.  Guggi also
> > seems
> > > to not know that
> > > I only want to populate those values, as it
> > expects
> > > me to include
> > > the entire TO_DATE if I just try and execute the
> > > statement.
> > >
> > > Any help would be appreciated.  It's a very
> > > reasonably priced tool
> > > and seems comparable in function to TOAD
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in
> one
=== message truncated ===

Thanks for your quick response on this Shakti.  I
hadn't had time to test the changes until today, but
your recommendations and patch seem to have worked.
For some reason, I didn't think of using the Microsoft
oleDB driver for loading the TNS profile- I couldn't
get the Oracle one to work, so I just set up the ODBC
connections.

When I run the query now, I can only run it as a
statement though, I can't run it as a script.  I still
get the expected output(which works for me- just a
change in my approach), but the "run as script"
function just does nothing-unless I add the semicolon-
then it errors :-)

Also, many people in my group use the schema browser
to make changes to several rows at a time for a single
field.  Is there an enhancement in the works to allow
a change to a row and just use the up/down arrow to
modify the next field rather than hit either enter and
arrow or tab and arrow?

--- "Shakti <skgoel@...>"
<shakti_k_goel@...> wrote:

> Hello Dan,
>
> Thank you for your interest in Guggi Oracle.
>
> We would recommend using Oracle OleDb by Oracle
> option
> to execute queries.  OleDb driver supports most of
> the
> functionality of Oracle whereas ODBC driver can be
> sometimes limiting.
>
> If you have Oracle client installed then Oledb is
> automatically installed with it, and you would not
> need to take any additional steps.
>
> The issue that you have encountered below is as
> follows:
>
> The tool does not recognize "." as an end-of-word
> character.  Therefore, it treats the entire string
>
> &START_DD.&START_MM.2005:00:00:00'
>
> as one parameter.
>
> In order for the script to work, please make the
> following changes
>
> '&START_DD . &START_MM . 2005:00:00:00'
>
> In other words, insert a space before and after the
> period (".")character.  The tool will then recognize
> start_dd as a single parameter and same for other
> three parameters.
>
> We have tested this using OleDb driver.
>
> SELECT *
>   FROM emp
> WHERE  hiredate BETWEEN TO_DATE ('&START_DD .
> &START_MM .1981:00:00:00',
>
> 'DD.MM.YYYY:HH24:MI:SS'
>                                       )
>                           AND TO_DATE
> ('&END_DD . &END_MM .1981:23:59:59',
>                                        'DD
> .MM.YYYY:HH24:MI:SS'
>                                       )
>
>
> We will add an option in the tool to recognize "."
> as
> a character.  This option will be placed in the
> Application Options form.  You can then turn on-this
> option.
>
> Also, the OleDb  and ODBC drivers do not recognize
> ";"
> as a valid character at the end of SQL statement.
> We
> are making enhancements to the product to address
> this
> issue as well.
>
> Hope the response addresses the immediate issue.
> Please let us know if you have any more questions.
>
> Regards,
>
> Shakti
> Sales - Impact Solutions
> http://www.impact-sol.com
> Developers of Guggi Oracle - Tool for DBAs and
> Developers
>
>
> --- Dan <dccorso@...> wrote:
>
> > Hi,
> >
> > I'm evaluating this product to replace TOAD in our
> > workplace.  We
> > are budget cutting :-)
> >
> > We'll need 10 licenses, but while I'm testing
> > scripts that run in
> > TOAD, I get some funky errors in this.  I was
> > wondering if some
> > light could be shed on them, and what I need to do
> > to get the
> > scripts to execute properly?
> >
> > Here's what I'm sending:
> > SELECT val1, val2, COUNT(1)
> >   FROM table1
> >  WHERE (   val3 in ('x1','x2','x3')
> >        )
> >    AND val4 BETWEEN TO_DATE
> > ('&START_DD.&START_MM.2005:00:00:00',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> >                                       )
> >                           AND TO_DATE
> > ('&END_DD.&END_MM.2005:23:59:59',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> >                                       )
> >
> >  group by val1, val2;
> >
> > Here's the error that's coming out when I run it
> as
> > a script:
> >
> > [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
> > PLS-00103: Encountered the symbol "" when
> expecting
> > one of the
> > following:
> >    begin declare exit for goto if loop mod null
> > pragma raise
> >    return select update while <an identifier>
> >    <a double-quoted delimited-identifier> <a bind
> > variable> <<
> >    close current delete fetch lock insert open
> > rollback
> >    savepoint set sql execute commit forall
> >    <a single-quoted SQL string>
> > The symbol "" was ignored.
> > ORA-06550: line 12, column 50:
> > PLS-00103: Encountered the sy
> >
> > Now, I know if I were to replace the
> > &START_DD.&START_MM and
> > &END_DD.&END_MM with solid values, it will run
> fine,
> > but I run these
> > regularly and prefer the prompts.  Guggi also
> seems
> > to not know that
> > I only want to populate those values, as it
> expects
> > me to include
> > the entire TO_DATE if I just try and execute the
> > statement.
> >
> > Any help would be appreciated.  It's a very
> > reasonably priced tool
> > and seems comparable in function to TOAD
> >
> >
> >
> >
> >
>
>




__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

Dan,

I have placed a patch version of Guggi on the internet site.  Please
download the zip file Guggiexe.zip from

http://www.impact-sol.com/download/Guggiexe.zip

Please unzip the file and save Guggi.exe in the folder where Guggi
for Oracle is installed.  The patch version will read 1.5.3 as
version number.

This version of Guggi will resolve the issue with period (".").
Several other cahracters such as " ", ";" ")" , "(" , tab, space, new
line etc. are used to identify word terminators.  Please let us know
if you would like other word terminators to be added.


In addition, a modified Reverse Engineer tool has been added that
will allow you to reverse engineer a lot of different type of
objects.  Also, you can reverse engineer a select list of objects of
a given type.  The tool will reverse advanced objects for Oracle
version 9.2 and higher.

The debugger has also been enhanced to report more error messages,
Run till exception feature has been added.  The user can now
also "abort execution" while the debugger is still running.

Thanks

Shakti
http://www.impact-sol.com
Developers of Guggi Oracle - Tool for DBAs and Developers


--- In guggiusers@yahoogroups.com, "Shakti <skgoel@a...>"
<shakti_k_goel@y...> wrote:
>
> Hello Dan,
>
> Thank you for your interest in Guggi Oracle.
>
> We would recommend using Oracle OleDb by Oracle option
> to execute queries.  OleDb driver supports most of the
> functionality of Oracle whereas ODBC driver can be
> sometimes limiting.
>
> If you have Oracle client installed then Oledb is
> automatically installed with it, and you would not
> need to take any additional steps.
>
> The issue that you have encountered below is as
> follows:
>
> The tool does not recognize "." as an end-of-word
> character.  Therefore, it treats the entire string
>
> &START_DD.&START_MM.2005:00:00:00'
>
> as one parameter.
>
> In order for the script to work, please make the
> following changes
>
> '&START_DD . &START_MM . 2005:00:00:00'
>
> In other words, insert a space before and after the
> period (".")character.  The tool will then recognize
> start_dd as a single parameter and same for other
> three parameters.
>
> We have tested this using OleDb driver.
>
> SELECT *
>   FROM emp
> WHERE  hiredate BETWEEN TO_DATE ('&START_DD .
> &START_MM .1981:00:00:00',
>
> 'DD.MM.YYYY:HH24:MI:SS'
>                                       )
>                           AND TO_DATE
> ('&END_DD . &END_MM .1981:23:59:59',
>                                        'DD
> .MM.YYYY:HH24:MI:SS'
>                                       )
>
>
> We will add an option in the tool to recognize "." as
> a character.  This option will be placed in the
> Application Options form.  You can then turn on-this
> option.
>
> Also, the OleDb  and ODBC drivers do not recognize ";"
> as a valid character at the end of SQL statement.  We
> are making enhancements to the product to address this
> issue as well.
>
> Hope the response addresses the immediate issue.
> Please let us know if you have any more questions.
>
> Regards,
>
> Shakti
> Sales - Impact Solutions
> http://www.impact-sol.com
> Developers of Guggi Oracle - Tool for DBAs and
> Developers
>
>
> --- Dan <dccorso@y...> wrote:
>
> > Hi,
> >
> > I'm evaluating this product to replace TOAD in our
> > workplace.  We
> > are budget cutting :-)
> >
> > We'll need 10 licenses, but while I'm testing
> > scripts that run in
> > TOAD, I get some funky errors in this.  I was
> > wondering if some
> > light could be shed on them, and what I need to do
> > to get the
> > scripts to execute properly?
> >
> > Here's what I'm sending:
> > SELECT val1, val2, COUNT(1)
> >   FROM table1
> >  WHERE (   val3 in ('x1','x2','x3')
> >        )
> >    AND val4 BETWEEN TO_DATE
> > ('&START_DD.&START_MM.2005:00:00:00',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> >                                       )
> >                           AND TO_DATE
> > ('&END_DD.&END_MM.2005:23:59:59',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> >                                       )
> >
> >  group by val1, val2;
> >
> > Here's the error that's coming out when I run it as
> > a script:
> >
> > [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
> > PLS-00103: Encountered the symbol "" when expecting
> > one of the
> > following:
> >    begin declare exit for goto if loop mod null
> > pragma raise
> >    return select update while <an identifier>
> >    <a double-quoted delimited-identifier> <a bind
> > variable> <<
> >    close current delete fetch lock insert open
> > rollback
> >    savepoint set sql execute commit forall
> >    <a single-quoted SQL string>
> > The symbol "" was ignored.
> > ORA-06550: line 12, column 50:
> > PLS-00103: Encountered the sy
> >
> > Now, I know if I were to replace the
> > &START_DD.&START_MM and
> > &END_DD.&END_MM with solid values, it will run fine,
> > but I run these
> > regularly and prefer the prompts.  Guggi also seems
> > to not know that
> > I only want to populate those values, as it expects
> > me to include
> > the entire TO_DATE if I just try and execute the
> > statement.
> >
> > Any help would be appreciated.  It's a very
> > reasonably priced tool
> > and seems comparable in function to TOAD
> >
> >
> >
> >
> >
>

Hello Dan,

Thank you for your interest in Guggi Oracle.

We would recommend using Oracle OleDb by Oracle option
to execute queries.  OleDb driver supports most of the
functionality of Oracle whereas ODBC driver can be
sometimes limiting.

If you have Oracle client installed then Oledb is
automatically installed with it, and you would not
need to take any additional steps.

The issue that you have encountered below is as
follows:

The tool does not recognize "." as an end-of-word
character.  Therefore, it treats the entire string

&START_DD.&START_MM.2005:00:00:00'

as one parameter.

In order for the script to work, please make the
following changes

'&START_DD . &START_MM . 2005:00:00:00'

In other words, insert a space before and after the
period (".")character.  The tool will then recognize
start_dd as a single parameter and same for other
three parameters.

We have tested this using OleDb driver.

SELECT *
   FROM emp
WHERE  hiredate BETWEEN TO_DATE ('&START_DD .
&START_MM .1981:00:00:00',

'DD.MM.YYYY:HH24:MI:SS'
                                       )
                           AND TO_DATE
('&END_DD . &END_MM .1981:23:59:59',
                                        'DD
.MM.YYYY:HH24:MI:SS'
                                       )


We will add an option in the tool to recognize "." as
a character.  This option will be placed in the
Application Options form.  You can then turn on-this
option.

Also, the OleDb  and ODBC drivers do not recognize ";"
as a valid character at the end of SQL statement.  We
are making enhancements to the product to address this
issue as well.

Hope the response addresses the immediate issue.
Please let us know if you have any more questions.

Regards,

Shakti
Sales - Impact Solutions
http://www.impact-sol.com
Developers of Guggi Oracle - Tool for DBAs and
Developers


--- Dan <dccorso@...> wrote:

> Hi,
>
> I'm evaluating this product to replace TOAD in our
> workplace.  We
> are budget cutting :-)
>
> We'll need 10 licenses, but while I'm testing
> scripts that run in
> TOAD, I get some funky errors in this.  I was
> wondering if some
> light could be shed on them, and what I need to do
> to get the
> scripts to execute properly?
>
> Here's what I'm sending:
> SELECT val1, val2, COUNT(1)
>   FROM table1
>  WHERE (   val3 in ('x1','x2','x3')
>        )
>    AND val4 BETWEEN TO_DATE
> ('&START_DD.&START_MM.2005:00:00:00',
>
> 'DD.MM.YYYY:HH24:MI:SS'
>                                       )
>                           AND TO_DATE
> ('&END_DD.&END_MM.2005:23:59:59',
>
> 'DD.MM.YYYY:HH24:MI:SS'
>                                       )
>
>  group by val1, val2;
>
> Here's the error that's coming out when I run it as
> a script:
>
> [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
> PLS-00103: Encountered the symbol "" when expecting
> one of the
> following:
>    begin declare exit for goto if loop mod null
> pragma raise
>    return select update while <an identifier>
>    <a double-quoted delimited-identifier> <a bind
> variable> <<
>    close current delete fetch lock insert open
> rollback
>    savepoint set sql execute commit forall
>    <a single-quoted SQL string>
> The symbol "" was ignored.
> ORA-06550: line 12, column 50:
> PLS-00103: Encountered the sy
>
> Now, I know if I were to replace the
> &START_DD.&START_MM and
> &END_DD.&END_MM with solid values, it will run fine,
> but I run these
> regularly and prefer the prompts.  Guggi also seems
> to not know that
> I only want to populate those values, as it expects
> me to include
> the entire TO_DATE if I just try and execute the
> statement.
>
> Any help would be appreciated.  It's a very
> reasonably priced tool
> and seems comparable in function to TOAD
>
>
>
>
>

Hi,

I'm evaluating this product to replace TOAD in our workplace.  We
are budget cutting :-)

We'll need 10 licenses, but while I'm testing scripts that run in
TOAD, I get some funky errors in this.  I was wondering if some
light could be shed on them, and what I need to do to get the
scripts to execute properly?

Here's what I'm sending:
SELECT val1, val2, COUNT(1)
   FROM table1
  WHERE (   val3 in ('x1','x2','x3')
        )
    AND val4 BETWEEN TO_DATE ('&START_DD.&START_MM.2005:00:00:00',
                                        'DD.MM.YYYY:HH24:MI:SS'
                                       )
                           AND TO_DATE
('&END_DD.&END_MM.2005:23:59:59',
                                        'DD.MM.YYYY:HH24:MI:SS'
                                       )

	 group by val1, val2;

Here's the error that's coming out when I run it as a script:

[Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "" when expecting one of the
following:
    begin declare exit for goto if loop mod null pragma raise
    return select update while <an identifier>
    <a double-quoted delimited-identifier> <a bind variable> <<
    close current delete fetch lock insert open rollback
    savepoint set sql execute commit forall
    <a single-quoted SQL string>
The symbol "" was ignored.
ORA-06550: line 12, column 50:
PLS-00103: Encountered the sy

Now, I know if I were to replace the &START_DD.&START_MM and
&END_DD.&END_MM with solid values, it will run fine, but I run these
regularly and prefer the prompts.  Guggi also seems to not know that
I only want to populate those values, as it expects me to include
the entire TO_DATE if I just try and execute the statement.

Any help would be appreciated.  It's a very reasonably priced tool
and seems comparable in function to TOAD

Thanks Ashish.  I will add this feature request to the enhancement list

Shakti

--- In guggiusers@yahoogroups.com, Ashish Ranjan <ashishwave@y...> wrote:
>
> May be the Schema Browser of guggi should also be able
> to read   and show the schema by reading from an XML
> file (containing the XML format export of Oracle
> schema DDLs) and , if required, may be made as a
> separate tool.
>  the xml file format example can be seen from the TOYS
> exported file itself (.snp)
>
> bye :-)
> Ashish
>
> Note: forwarded message attached.
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> Hi shakti,
>  this is a new month, and as always i will give you
> one new url link to one nicest oracle tool.
>  http://www.impacttoys.com/download.htm
>
> Here you will find a tool called TOYS, this is one of
> the most important tool after TOAD  in my opinion.
> Here you can capture the whole oracle schema to one
> XML file and then later do not need oracle database
> server for navigating that schema ,be offline (means
> without any oracle) and you can simply open that schma
> XML file and navigate visually through database
> objects and their definition etc.
>
>  this url, i give in hope of following things:
>  1) guggi will become guggi suite (like TOAD has not
> become TOAD suite of products) containing one stop
> solution for almost all the oracle related major
> activities. In that suite, this will be a big FEATURE
> addition.
>  2) if (1) is too far optimistic goal, then atleast
> "some" ideas of it, may be fruitful some day in guggi.
>
> bye :-)
> Ashish
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>

Hello Guggi Oracle Users,

Guggi Oracle version 1.5.0 with a PL/SQL debugger has been released.
This version has been posted on the website

http://www.impact-sol.com.


Thanks

Shakti
================================================================

New/ Changes in Version 1.5.0 - Released Oct 15, 2005

1.  Added PL/SQL Debugger.  This was a long-pending tool to be added
to Guggi Oracle.  This provides a significant enhancement to PL/SQL
abilities along with code compilation, profiler and trace.

Debugger Supports: Step into, Step over, Step out, add breakpoint,
delete breakpoint, get value, set value, variable watch list, stack
trace.

Run till excecption will be added in the next release.  Support for
Object Types will also be added in the next release.

How to use the debugger:

	 a.  Launch the debugger from Tools menu option
	 b.  Type in a PL/SQL anonymous block.  Anonymous block is
needed for all PL/SQL code - package, procedure, function
	 c.  Click on first button - start debugger
	 d.  Click on continue or step into or step over or step out
	 e.  Enter the watch variables in the lower left grid and
values will be displayed in the grid.
	 f.  Once the debugging is done, the first and last button
will become enabled and other buttons will be disabled.


2.  Added latch Monitor -  a DBA tool.  View latch holders and latch
waiters.
3.  Improved the DDL for tables - added indexes and constraint scripts
4.  Consolidated free space tablespace and object space into Storage
Manager.  View space taken by objects in a given schema.  View space
taken by objects in a given tablespace.
5.  Added several editing features to the SQL and PL/SQL editor
6.  Improved the sizing of the controls on several windows as waits-
latch-lock, upload blob, view image, SQL stats etc.
7.  Added User Guide.
8.  Much more ...

May be the Schema Browser of guggi should also be able
to read   and show the schema by reading from an XML
file (containing the XML format export of Oracle
schema DDLs) and , if required, may be made as a
separate tool.
  the xml file format example can be seen from the TOYS
exported file itself (.snp)

bye :-)
Ashish

Note: forwarded message attached.




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Hi shakti,
  this is a new month, and as always i will give you
one new url link to one nicest oracle tool.
  http://www.impacttoys.com/download.htm

Here you will find a tool called TOYS, this is one of
the most important tool after TOAD  in my opinion.
Here you can capture the whole oracle schema to one
XML file and then later do not need oracle database
server for navigating that schema ,be offline (means
without any oracle) and you can simply open that schma
XML file and navigate visually through database
objects and their definition etc.

  this url, i give in hope of following things:
  1) guggi will become guggi suite (like TOAD has not
become TOAD suite of products) containing one stop
solution for almost all the oracle related major
activities. In that suite, this will be a big FEATURE
addition.
  2) if (1) is too far optimistic goal, then atleast
"some" ideas of it, may be fruitful some day in guggi.

bye :-)
Ashish



__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

i had tested that and now the bugs are fixed. Now i
think it will be quite hard for me (for bug finding)
to catch up with your bug fixing speed. :-)

bye :-)
Ashish




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

> Thanks for pointing out the web sites.  I will look
> at them but I  think they support non-Windows
applications only.
It's not like that. you can visit sourceforge and
search for .NET or MFC . you will be surprised how
many prestigious projects of windows world are
actually hosted out there, like Sharp-Develop etc.
  But in case of freshmeat, many projects out there are
like yours - free and shareware and on windows, like:
   http://freshmeat.net/projects/windriver/
   http://freshmeat.net/projects/codebase/

bye :-)
Ashish

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Hi Ashish,

Nice to hear back from you.

Bug1 was addressed in version 1.4.7 and is on the website for
download.  This bug had to do with data appeared to be truncated when
selected in the grid.  If the grid rowheight is too narrow then the
data gets wrapped.  If the rowheight is large enough then it does not
get wrapped.

Regarding Bug2, it seems that you are using Oracle 8i and one of the
columns in the System View is absent from 8i but is present in 9i.

This issue has been fixed.

Regarding Bug3,  the issue is fixed.  There is no need to run the
query multiple times.  Please note, that export as CSV is much faster
than XLS.

Please follow these steps to apply the patch:

1.  Goto http://www.impact-sol.com/download/Guggiexe.zip
2.  Unzip the file and save it in the folder where Guggi-Oracle is
installed.

Thanks for pointing out the web sites.  I will look at them but I
think they support non-Windows applications only.

Thanks

Shakti


--- In guggiusers@yahoogroups.com, Ashish Ranjan <ashishwave@y...>
wrote:
> Dear shakti,
> I am back with my inputs. i just fiddled with  the
> recent one on your site and i saw u have implemented
> the "show tips at startup".Now it looks like a truly
> pro app.
>   also the "favourite" sql is implemented in the same
> way, as originally thought of.
>
> I am sending some bugs inputs as deliverables on my
> part.
>  (Bug1 , i had sent Bug1 earlier)
> Bug2:
> Inside the schema browser, In each table, when i goto
> "Index"  tab on the right pane, then it gives error:
> ORA-00904: invalid column name. AND then when i click
> on the white area attached with the "Index" tab, then
> i get the error "Invalid Row value". This is
> happenning with me for each table.
>     i am attaching the screenshots.
>
> Bug 3:
>   If i run a query , and then export it as say, Excel
> (by clicking the fourth button), then if i again want
> to export it as CSV also then it does not work, i need
> to run the same query again and then export it as CSV.
>
>    Ie, exporting two/three times in different formats
> for the same query does not work, you need to run and
> then export once and so on.
>   This (re-running) becomes prohibitive in case of
> very long computation intensive queries
>
> Suggestion 1:
>   On the guggi yahoo group main page, you have the
> description. Add the link to your main site
> http://www.impact-sol.com over there.
>
> Suggestion 2:
>   i saw that u have submitted guggi to downloadc.com
> etc, you may also put the download at sourceforge.net
> and add the description at freshmeat.net too, that
> will give you better visibility.
>
> bye :-)
> Ashish
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com

i remember some time ago u had asked for any favourite
queries of mine, actually these are of two types
  1) Database specific, which depends upon my own
database schema. This is of no use to any other guy,
as it is for my own purpose..
  2) Oracle data dictionary related queries. For this i
should point u to
   http://www.wangz.net/easyscript.php
It contains hundreds of readymade and categorized
scripts in a very descriptive and searchable way, with
the option of my own additions too.
bye :-)
Ashish






__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Dear shakti,
I am back with my inputs. i just fiddled with  the
recent one on your site and i saw u have implemented
the "show tips at startup".Now it looks like a truly
pro app.
   also the "favourite" sql is implemented in the same
way, as originally thought of.

I am sending some bugs inputs as deliverables on my
part.
  (Bug1 , i had sent Bug1 earlier)
Bug2:
Inside the schema browser, In each table, when i goto
"Index"  tab on the right pane, then it gives error:
ORA-00904: invalid column name. AND then when i click
on the white area attached with the "Index" tab, then
i get the error "Invalid Row value". This is
happenning with me for each table.
     i am attaching the screenshots.

Bug 3:
   If i run a query , and then export it as say, Excel
(by clicking the fourth button), then if i again want
to export it as CSV also then it does not work, i need
to run the same query again and then export it as CSV.

    Ie, exporting two/three times in different formats
for the same query does not work, you need to run and
then export once and so on.
   This (re-running) becomes prohibitive in case of
very long computation intensive queries

Suggestion 1:
   On the guggi yahoo group main page, you have the
description. Add the link to your main site
http://www.impact-sol.com over there.

Suggestion 2:
   i saw that u have submitted guggi to downloadc.com
etc, you may also put the download at sourceforge.net
and add the description at freshmeat.net too, that
will give you better visibility.

bye :-)
Ashish



__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Hi,
i am going out of the town for 20 days , hence after
that i will be back with some positive feedback (if
you leave any scope for further enhancement :-) ) .  i
will be definitely be liking to contribute in whatever
even small way, i can.

  My all the points 1,2,3 below  deal with the
"Favourite SQL/PLsql" feature implementation itself.
1.   by the way, i thought that i should say that if
you give favourite SQL/PLSQL feature, then may be,
even if it added/configured through GUI,  even then it
should be stored in a separate .ini file or something
like that
so that if i upgrade guggi with a new version or i go
to some other PC with guggi, then i should not need to
re-enter all those commands in the GUI for configuring
the "Favourite SQL"; i should only copy (or add the
commands of one .ini file to another .ini file)  that
.ini (or whatever file) to that computer, and behold
all my 100s of favourite SQL commands are available

2. say,  my "favourite SQL"  has two properties to be
entered in the .ini (say),
2.1. name by which it will appear in the menu
2.2. the actual sql/plsql which will be typed in the
SQL Editor window by clicking this favourite SQL
   BUT, if i do not give the name (as specified in
2.1), then the name in the menu will  be taken as the
sql of 2.2 itself.

3. (MOST IMPORTANT) it may also happen that you will
not like/find it convenient to insert the "Favourite
SQLs" in a menu of guggi, then another alternate
proposal is that:
    like in TOAD , when you are in SQL window, then if
you press F8 key, then it will show the history of all
the SQL commands in a grid, you select one of them by
enter key and it will come to the SQL window.  The
same thing you may implement for "Favourite SQL"
rather than going for customised menu addition for
guggi. I think that it is better and convenient too
for future addition for features like SQL history and
Favourite SQLs both available in there in separate
tabs.

  I hope i was clear.

bye :-)
Ashish


--- shakti_k_goel <shakti_k_goel@...> wrote:

> Hi Ashish,
>
> Thanks for your useful suggestions.
>
> I am currently looking into the issue where the data
> in the grid gets
> truncated to first 6 characters.  The issue here is
> that the data
> displayed on the selected cell shows only the first
> 6 characters but
> the actual data remains intact ... meaning that only
> the display is
> truncated but not the actual data in the grid.
>
> You can export data to excel, csv by clicking on the
> 4th button on
> the SQL Editor toolbar (displayed below the main
> toolbar).
>
> Right-hand click functionality is being developed at
> this time.
>
> Thanks for pointing to SQLEDT32.  Also, if you have
> other DBA scripts
> that you would like to see in the application and do
> not mind sharing
> them, please send them to me.  I will incorporate
> them.
>
> All other suggestions in your email plus the
> functionality to save
> favorite SQL will be added in the next release which
> will be within
> the next two weeks or so.
>
> Regarding the ERD:  The current ERD feature shows
> all the tables
> related to a selected table.  Once the diagram is
> displayed, you can
> double click on any of the tables and its
> relationship with other
> tables in the schema will be shown.  This way you
> can see the
> relationship piece by piece.  I am in the process of
> developing an
> ERD functionality  that will show the entire ERD on
> the same screen.
>
>
> Regards,
>
> Shakti
>
>
>
>
>
>
> --- In guggiusers@yahoogroups.com, Ashish Ranjan
> <ashishwave@y...>
> wrote:
> > Hi,
> >
> >  Thanks for incorporating it. It was better than
> my
> > expectation. Good work. You changelog also is very
> > impressive.Now its my turn to give the expectd
> > deliverable-the feedbacks.
> >
> > One bug:
> >   One of my field in a table tac_pol_detl is of
> > VARCHAR2(20) type. Now when i goto SQL-Windows and
> > give select * from select * from tac_pol_detl and
> then
> > press F9, then the record set is retieved in the
> grid.
> > Now ehn i goto that field TXT_POLICY_NUMBER, then
> the
> > 20 characters of the CURRENTLY ACTIVE( wher the
> cursor
> > is) become 6 , when i goto other row/field , then
> > becomes normal 20 characters again. I am sending
> you
> > the screenshot.
> >
> >
> >
> > Some suggestions:
> >     1. Retrieving next set of 25 records, should
> be
> > somewhere have some option that i can change this
> 25
> > to say, 200 or so (may be you may think of adding
> one
> > small textbox beside the "Retrieve next set of
> > records" )
> >     2. MOST IMPORTANT, actually when we are
> traversing
> > on the grid (of SQL-Window output) of the
> recordset
> > ALWAYS by using keyboard, then for fetching next
> set
> > of rows, clicking that button with mouse always
> > becomes inconvenient, can you make it associated
> with
> > some keyboard shortcut. Actually you may
> generalise it
> > to make one Keyboard shortcut mapper for all the
> menu
> > items say.
> >
> >     3. after this has fetched all records, then in
> the
> > status bar's "Records Retrieved:999" (say), should
> say
> > "Records Retrieved:999 (ALL)". This will help when
> you
> > are continuously "retrieving next set of records"
> > again and gain, the  when you have reached at the
> end
> > of the able, you should know that all the rows
> have
> > been retrieved.
> >     4. The password saving in registry is very
> helpful
> > for me. But it should be optional, becaue of some
> > secuity freaks (we and others may have some
> regular
> > security audits going on, then this will not pass
> the
> > audit). Ie, by default it may be on. But if i tick
> > some option somewhere , then it should clean all
> the
> > stored passwords in the registry and then from
> then
> > onwards, do not store  password in the registry.
> >     5. (This is not so important., just a random
> > thought) Tip of the fature at the time of the
> start of
> > the software.
> >     6. I have over 50 interrelated tables (say),
> then
> > in that case as the generated ER diagram does not
> fit
> > into one page and also has no scroll bar , hence i
> can
> > not scroll to see the entire diagram.
> >
> > Some query:
> >   1. Is this very important ERD tool somewhere in
> the
> > menu?
> >   2. (VERY IMPORTANT) like in toad when you right
> > click on grid, and then you can export the grid
> > recordset to an XLS file,CSV file etc. Can i do it
> > from somewhere?
> >          Or, even in Schema Browser , can i select
> > multipl tables and export their data to some
> Excel,
> > CSV files?
> >
> > Some url: i am again just sharing with you ,one
> more
> > nice helpful free sql related utlity url:
> >     goto
> >
>
http://hem.fyristorg.com/publish/oracle.html#SQLEDT32
> >     and download SQLEdit32, it is avery nice and
> free
> > editor. you just try it for once. goto File->New.
> and
> > then after that a lot of menus will appear for
> ready
> > template insertion for almost any job. This small
> > nifty tool is very helpful, when you forgotten
> > something small in the whole tomb of syntax.
> >
> > Thumbs up again!
> > bye :-)
> > Ashish Ranjan
> > ashishwave@y...
> > --- "Shakti <skgoel@a...>"
> > <shakti_k_goel@y...> wrote:
> >
> > > Hi Ashish,
> > >
> > > I have just posted version 1.4.7 which has one
> of
> > > your
> > > requested features - no limit on number of
> records
> > > being retrieved when executing queries.  I will
> add
> > > the Favorites feature in the next release.
> > >
> > > Please let me know how your experience has been
> so
> > > far
> > > and what other changes / features you would like
> to
> > > see.
> > >
> > > Thanks
> > >
> > > Shakti
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
>
>
>
>





______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/

Hi Ashish,

Thanks for your useful suggestions.

I am currently looking into the issue where the data in the grid gets
truncated to first 6 characters.  The issue here is that the data
displayed on the selected cell shows only the first 6 characters but
the actual data remains intact ... meaning that only the display is
truncated but not the actual data in the grid.

You can export data to excel, csv by clicking on the 4th button on
the SQL Editor toolbar (displayed below the main toolbar).

Right-hand click functionality is being developed at this time.

Thanks for pointing to SQLEDT32.  Also, if you have other DBA scripts
that you would like to see in the application and do not mind sharing
them, please send them to me.  I will incorporate them.

All other suggestions in your email plus the functionality to save
favorite SQL will be added in the next release which will be within
the next two weeks or so.

Regarding the ERD:  The current ERD feature shows all the tables
related to a selected table.  Once the diagram is displayed, you can
double click on any of the tables and its relationship with other
tables in the schema will be shown.  This way you can see the
relationship piece by piece.  I am in the process of developing an
ERD functionality  that will show the entire ERD on the same screen.


Regards,

Shakti






--- In guggiusers@yahoogroups.com, Ashish Ranjan <ashishwave@y...>
wrote:
> Hi,
>
>  Thanks for incorporating it. It was better than my
> expectation. Good work. You changelog also is very
> impressive.Now its my turn to give the expectd
> deliverable-the feedbacks.
>
> One bug:
>   One of my field in a table tac_pol_detl is of
> VARCHAR2(20) type. Now when i goto SQL-Windows and
> give select * from select * from tac_pol_detl and then
> press F9, then the record set is retieved in the grid.
> Now ehn i goto that field TXT_POLICY_NUMBER, then the
> 20 characters of the CURRENTLY ACTIVE( wher the cursor
> is) become 6 , when i goto other row/field , then
> becomes normal 20 characters again. I am sending you
> the screenshot.
>
>
>
> Some suggestions:
>     1. Retrieving next set of 25 records, should be
> somewhere have some option that i can change this 25
> to say, 200 or so (may be you may think of adding one
> small textbox beside the "Retrieve next set of
> records" )
>     2. MOST IMPORTANT, actually when we are traversing
> on the grid (of SQL-Window output) of the recordset
> ALWAYS by using keyboard, then for fetching next set
> of rows, clicking that button with mouse always
> becomes inconvenient, can you make it associated with
> some keyboard shortcut. Actually you may generalise it
> to make one Keyboard shortcut mapper for all the menu
> items say.
>
>     3. after this has fetched all records, then in the
> status bar's "Records Retrieved:999" (say), should say
> "Records Retrieved:999 (ALL)". This will help when you
> are continuously "retrieving next set of records"
> again and gain, the  when you have reached at the end
> of the able, you should know that all the rows have
> been retrieved.
>     4. The password saving in registry is very helpful
> for me. But it should be optional, becaue of some
> secuity freaks (we and others may have some regular
> security audits going on, then this will not pass the
> audit). Ie, by default it may be on. But if i tick
> some option somewhere , then it should clean all the
> stored passwords in the registry and then from then
> onwards, do not store  password in the registry.
>     5. (This is not so important., just a random
> thought) Tip of the fature at the time of the start of
> the software.
>     6. I have over 50 interrelated tables (say), then
> in that case as the generated ER diagram does not fit
> into one page and also has no scroll bar , hence i can
> not scroll to see the entire diagram.
>
> Some query:
>   1. Is this very important ERD tool somewhere in the
> menu?
>   2. (VERY IMPORTANT) like in toad when you right
> click on grid, and then you can export the grid
> recordset to an XLS file,CSV file etc. Can i do it
> from somewhere?
>          Or, even in Schema Browser , can i select
> multipl tables and export their data to some Excel,
> CSV files?
>
> Some url: i am again just sharing with you ,one more
> nice helpful free sql related utlity url:
>     goto
> http://hem.fyristorg.com/publish/oracle.html#SQLEDT32
>     and download SQLEdit32, it is avery nice and free
> editor. you just try it for once. goto File->New. and
> then after that a lot of menus will appear for ready
> template insertion for almost any job. This small
> nifty tool is very helpful, when you forgotten
> something small in the whole tomb of syntax.
>
> Thumbs up again!
> bye :-)
> Ashish Ranjan
> ashishwave@y...
> --- "Shakti <skgoel@a...>"
> <shakti_k_goel@y...> wrote:
>
> > Hi Ashish,
> >
> > I have just posted version 1.4.7 which has one of
> > your
> > requested features - no limit on number of records
> > being retrieved when executing queries.  I will add
> > the Favorites feature in the next release.
> >
> > Please let me know how your experience has been so
> > far
> > and what other changes / features you would like to
> > see.
> >
> > Thanks
> >
> > Shakti
> >
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com

Hi,

  Thanks for incorporating it. It was better than my
expectation. Good work. You changelog also is very
impressive.Now its my turn to give the expectd
deliverable-the feedbacks.

One bug:
   One of my field in a table tac_pol_detl is of
VARCHAR2(20) type. Now when i goto SQL-Windows and
give select * from select * from tac_pol_detl and then
press F9, then the record set is retieved in the grid.
Now ehn i goto that field TXT_POLICY_NUMBER, then the
20 characters of the CURRENTLY ACTIVE( wher the cursor
is) become 6 , when i goto other row/field , then
becomes normal 20 characters again. I am sending you
the screenshot.



Some suggestions:
     1. Retrieving next set of 25 records, should be
somewhere have some option that i can change this 25
to say, 200 or so (may be you may think of adding one
small textbox beside the "Retrieve next set of
records" )
     2. MOST IMPORTANT, actually when we are traversing
on the grid (of SQL-Window output) of the recordset
ALWAYS by using keyboard, then for fetching next set
of rows, clicking that button with mouse always
becomes inconvenient, can you make it associated with
some keyboard shortcut. Actually you may generalise it
to make one Keyboard shortcut mapper for all the menu
items say.

     3. after this has fetched all records, then in the
status bar's "Records Retrieved:999" (say), should say
"Records Retrieved:999 (ALL)". This will help when you
are continuously "retrieving next set of records"
again and gain, the  when you have reached at the end
of the able, you should know that all the rows have
been retrieved.
     4. The password saving in registry is very helpful
for me. But it should be optional, becaue of some
secuity freaks (we and others may have some regular
security audits going on, then this will not pass the
audit). Ie, by default it may be on. But if i tick
some option somewhere , then it should clean all the
stored passwords in the registry and then from then
onwards, do not store  password in the registry.
     5. (This is not so important., just a random
thought) Tip of the fature at the time of the start of
the software.
     6. I have over 50 interrelated tables (say), then
in that case as the generated ER diagram does not fit
into one page and also has no scroll bar , hence i can
not scroll to see the entire diagram.

Some query:
   1. Is this very important ERD tool somewhere in the
menu?
   2. (VERY IMPORTANT) like in toad when you right
click on grid, and then you can export the grid
recordset to an XLS file,CSV file etc. Can i do it
from somewhere?
          Or, even in Schema Browser , can i select
multipl tables and export their data to some Excel,
CSV files?

Some url: i am again just sharing with you ,one more
nice helpful free sql related utlity url:
     goto
http://hem.fyristorg.com/publish/oracle.html#SQLEDT32
     and download SQLEdit32, it is avery nice and free
editor. you just try it for once. goto File->New. and
then after that a lot of menus will appear for ready
template insertion for almost any job. This small
nifty tool is very helpful, when you forgotten
something small in the whole tomb of syntax.

Thumbs up again!
bye :-)
Ashish Ranjan
ashishwave@...
--- "Shakti <skgoel@...>"
<shakti_k_goel@...> wrote:

> Hi Ashish,
>
> I have just posted version 1.4.7 which has one of
> your
> requested features - no limit on number of records
> being retrieved when executing queries.  I will add
> the Favorites feature in the next release.
>
> Please let me know how your experience has been so
> far
> and what other changes / features you would like to
> see.
>
> Thanks
>
> Shakti
>

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Hi All,

Version 1.4.7 of Guggi Oracle has been released.  The additions /
changes to the product are as follows:

1.  Added Quick ERD tool.  The tool can be accessed from the Schema
Browser by clicking on the sixth icon.
     The tool shows the relationship the selected table has with other
tables in the same schema.  Relationship with tables in other schemas
is not shown.  If the table has a foreign key (FK) which is also a
part of the primary key (PK) then the Quick ERD tool will show the
column as FK but not both.

2.  Enhanced Synax highlighting.

3.  Updated SQL Editor -
  	 a. records can be retrieved in increments of 25.  You no
longer need to set a predefined limit of the number of records that
can be retrieved.
         b. all records can be retrieved from the database
         c. record retrieval can be cancelled
         d. copy explain plan to the clipboard
         e. maintain a buffer of SQL statements in the SQL Editor.
Besides storing SQL statements in the SQL history, the statements are
saved in the SQL buffer.  These statements can be retrievevd from the
buffer.
Also, enhanced the Guggi SQL*Editor with above features.  Improved
the Explain Plan.

4.  Enhanced PL/SQL editor to improve syntax highlighting while
editing.

5.  Passwords are saved in the registry.  You can logon to the
database by double-clicking on the right side user/database list in
Login Window.

6.  Added histogram to table details

7.  Added External table and Queue Table tabs.

8.  Added job type details

9.  View object details by pressing ctrl-Q in PL/SQL editor window.

10. Fixed some bugs.

This functionality is built into Guggi Oracle via Sessions manager.

Click on Tools --> Sessions Manager.  The top grid shows all the
sessions.  Click on a session and its details will be displayed in
the lower grid.  You can also see number of active / inactive
sessions etc.

Sessions manager can be accessed from the toolbar also.

--- In guggiusers@yahoogroups.com, Ashish Ranjan <ashishwave@y...>
wrote:
> TOAD(www.quest.com) -> "DBA" menu->"Kill/Trace
> Session" is also very very good feature for seeing the
> queries which are executing for very long on say very
> very large tables.
> Bas itna sa khwab hai :-)
> bye :-)
> Ashish
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com

H Ashish,

Thanks for looking at the productand the suggestions.  I am glad you
found the application useful.

The number of records that you wish to retrieve can be modified by
goint to Tools --> Set Records.  In the new version that is currently
being QA'd has the feature in SQL editor where you do not need to
specify the number of records up front.  There are two buttons ...
one retrieves 25 next records on every click and the other one
retrieves all the records.  You can cancel the retrieval of records.
The new version should answer suggestions 1a and 1b.  I will post the
new version sometime this week with an expiry date of end of
September.

However, please note that every record retrieved from the database is
cached in the desktop memory.  This may quickly take up all the
memory if the retrieval is not cancelled.

BTW, there is a Guggi SQL*Editor which is a scaled down version of
SQL*Editor built into Guggi-Oracle.  The guggi SQL*Editor runs
outside the main Guggi application.



Regarding Feature 2, I am planning to add a menu item called
FAVORITES.  This would contain frequently used SQL statements,
frequently accessed objects etc.

Thanks for suggestion 3.  I will update the FAQ section with license
information.

A user guide is being prepared (not a very exciting task but
nevertheless is being worked on).  I will post a list of commands
that can be used in SQL*Editor.  One feature of SQL*Editor is that
you can put the cursor on an object, Press Ctrl-Q and the object
details will be displayed in a separate window.

Please send me your useful suggestions and bug reports as you come up
with them!

Thanks

Shakti

--- In guggiusers@yahoogroups.com, Ashish Ranjan <ashishwave@y...>
wrote:
> Dear shakti,
>   Thumbs up for such a nice product.
>
> As you had asked for my suggestion. I am giving you
> these minimal suggestions, which i found very
> compelling :
>
> your app retrieves, only 100 or any fixed N records
> max of a table, and http://impact-sol.com/faqs.html
> also mentions this , as to how to modify this.
>
>  FEATURE1) ASYNCHRONOUS FETCHING OF VALUES FROM TABLES
> (like sqltools from www.sqltools.net). VERY VERY IMP
> (rather the most primary/basic)  FEATURE FOR VERY
> LARGE DATABASE USERS:
> i am using SQLTools (from sqltools.net), which is FREE
> and open source (in VC++), and i have many tables in
> live scenario, which have more than 1 to 10 crore
> rows. For which i was very happily using the Free and
> very good SqlTools.
>  feature 1a)When you give query say, select * from
> table1, on these kind of very large tables , it will
> very fastly return say, first 50 or 100 records in a
> grid and then as you scroll down(by pressing down
> arrow) all those records will be continuously
> automatically be fetched and added to the grid ( Not
> that it will stop after those fixed N records) till i
> keep scrolling.
>   feature 1b) Now,(in this feature 1a example itself)
> if i pull down the scoll bar of the grid to the end of
> the grid, then it will continuously keep adding the
> records to the grid shown, till i cancel this adding.
> The rows added till now in the grid will be available
> for me.
>
>   This feature 1a) is also there in TOAD, but feature
> 1b) is not in TOAD, but is in sqlTools. But, various
> types of tables browser, their schema definition etc,
> tablespace information etc., are NOT in SqlTools, but
> are in TOAD(which is not free). Hence i was searching
> for such an tool, which will have these kind of TOAD
> like facilities, and i found guggi and it almost
> atisfies my needs, only apart from the above feature
> 1(a) and 1(b), whch are missing in guggi. though it
> seems very small , But if it is there, then the users
> like us who are trying to use it for VLDB (very large
> Database) environments will be very happy.
>
>   FEATURE2) USERS SHOULD BE ABLE TO ADD THEIR OWN
> MENU-ITEMS (as shortcuts for sql commands or sql
> script files contents) IN A NEW MENU "CUSTOM"
>   ALSO, if there is one facility is that say, if i
> users can edit one .ini (or through the GUI itself),
> there will be several pairs of values,
>     name1, sqlcommand1
>  name2, sqlcommand2
>  name3, sqlscriptfile3PathName
>     name4, sqlscriptfile4PathName
> So that in a new "Custom" menu, these names will be
> shown as subitems of the menu and clicking on them
> those sqlcommand or sqlscript file content will be put
> in the sql window, then this kind of shortcut will be
> very helpful for the users.
>
>  In last (small rcommendations, not features),
>     3a) please mention this free, pay, license
> expiration at month end,$40 stuff in the user guide
> and your website very clearly. It may help us while
> evaluating vis-a-vis other products in future.
>  3b) please include one small html help file for
> "quick" SQL/PLSQL command "syntax reference", say like
> select/insert/update/delete/drop/creating/altering-
table,contraint,users,
> tablespaces,role, plsql loop,cursor etc.
>
>
>
> bye :-)
> Ashish Ranjan
> ashishwave@y...
>
> --- shakti_k_goel <shakti_k_goel@y...> wrote:
>
> > Ashish,
> >
> > The product can be used for free for some days.  The
> > license expires
> > at the end of the month.  The product can be
> > downloaded again.
> > Remove the previous version and install the new
> > version.  The product
> > is currently available for $40 per license if you do
> > not wish to  re-
> > install every month ... it is extremely inexpensive
> > as compared to
> > other competing products and features therein.
> >
> > Please let me know if you have any other questions
> > regarding
> > features, functionality etc., and let us know if you
> > find any issues
> > or have suggestions.
> >
> > Thanks
> >
> > Guggi Oracle Development Team
> >
> > --- In guggiusers@yahoogroups.com, Ashish Ranjan
> > <ashishwave@y...>
> > wrote:
> > > I have found guggi today. Actually before starting
> > > using it, i want to ascertain that whether it is
> > free
> > > or not for commercial (actually inside my own
> > > organisation, not selling it )use. But could not
> > found
> > > any info on the site. Can anybody please tell. As
> > i am
> > > searching only for a free DBA tool.
> > >
> > > bye :-)
> > > Ashish
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around
> > > http://mail.yahoo.com
> >
> >
> >
> >
>
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs

TOAD(www.quest.com) -> "DBA" menu->"Kill/Trace
Session" is also very very good feature for seeing the
queries which are executing for very long on say very
very large tables.
Bas itna sa khwab hai :-)
bye :-)
Ashish


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Dear shakti,
   Thumbs up for such a nice product.

As you had asked for my suggestion. I am giving you
these minimal suggestions, which i found very
compelling :

your app retrieves, only 100 or any fixed N records
max of a table, and http://impact-sol.com/faqs.html
also mentions this , as to how to modify this.

  FEATURE1) ASYNCHRONOUS FETCHING OF VALUES FROM TABLES
(like sqltools from www.sqltools.net). VERY VERY IMP
(rather the most primary/basic)  FEATURE FOR VERY
LARGE DATABASE USERS:
i am using SQLTools (from sqltools.net), which is FREE
and open source (in VC++), and i have many tables in
live scenario, which have more than 1 to 10 crore
rows. For which i was very happily using the Free and
very good SqlTools.
  feature 1a)When you give query say, select * from
table1, on these kind of very large tables , it will
very fastly return say, first 50 or 100 records in a
grid and then as you scroll down(by pressing down
arrow) all those records will be continuously
automatically be fetched and added to the grid ( Not
that it will stop after those fixed N records) till i
keep scrolling.
   feature 1b) Now,(in this feature 1a example itself)
if i pull down the scoll bar of the grid to the end of
the grid, then it will continuously keep adding the
records to the grid shown, till i cancel this adding.
The rows added till now in the grid will be available
for me.

   This feature 1a) is also there in TOAD, but feature
1b) is not in TOAD, but is in sqlTools. But, various
types of tables browser, their schema definition etc,
tablespace information etc., are NOT in SqlTools, but
are in TOAD(which is not free). Hence i was searching
for such an tool, which will have these kind of TOAD
like facilities, and i found guggi and it almost
atisfies my needs, only apart from the above feature
1(a) and 1(b), whch are missing in guggi. though it
seems very small , But if it is there, then the users
like us who are trying to use it for VLDB (very large
Database) environments will be very happy.

   FEATURE2) USERS SHOULD BE ABLE TO ADD THEIR OWN
MENU-ITEMS (as shortcuts for sql commands or sql
script files contents) IN A NEW MENU "CUSTOM"
   ALSO, if there is one facility is that say, if i
users can edit one .ini (or through the GUI itself),
there will be several pairs of values,
     name1, sqlcommand1
	 name2, sqlcommand2
	 name3, sqlscriptfile3PathName
     name4, sqlscriptfile4PathName
So that in a new "Custom" menu, these names will be
shown as subitems of the menu and clicking on them
those sqlcommand or sqlscript file content will be put
in the sql window, then this kind of shortcut will be
very helpful for the users.

  In last (small rcommendations, not features),
     3a) please mention this free, pay, license
expiration at month end,$40 stuff in the user guide
and your website very clearly. It may help us while
evaluating vis-a-vis other products in future.
	 3b) please include one small html help file for
"quick" SQL/PLSQL command "syntax reference", say like
select/insert/update/delete/drop/creating/altering-table,contraint,users,
tablespaces,role, plsql loop,cursor etc.



bye :-)
Ashish Ranjan
ashishwave@...

--- shakti_k_goel <shakti_k_goel@...> wrote:

> Ashish,
>
> The product can be used for free for some days.  The
> license expires
> at the end of the month.  The product can be
> downloaded again.
> Remove the previous version and install the new
> version.  The product
> is currently available for $40 per license if you do
> not wish to  re-
> install every month ... it is extremely inexpensive
> as compared to
> other competing products and features therein.
>
> Please let me know if you have any other questions
> regarding
> features, functionality etc., and let us know if you
> find any issues
> or have suggestions.
>
> Thanks
>
> Guggi Oracle Development Team
>
> --- In guggiusers@yahoogroups.com, Ashish Ranjan
> <ashishwave@y...>
> wrote:
> > I have found guggi today. Actually before starting
> > using it, i want to ascertain that whether it is
> free
> > or not for commercial (actually inside my own
> > organisation, not selling it )use. But could not
> found
> > any info on the site. Can anybody please tell. As
> i am
> > searching only for a free DBA tool.
> >
> > bye :-)
> > Ashish
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
>
>
>
>




____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs

Ashish,

The product can be used for free for some days.  The license expires
at the end of the month.  The product can be downloaded again.
Remove the previous version and install the new version.  The product
is currently available for $40 per license if you do not wish to  re-
install every month ... it is extremely inexpensive as compared to
other competing products and features therein.

Please let me know if you have any other questions regarding
features, functionality etc., and let us know if you find any issues
or have suggestions.

Thanks

Guggi Oracle Development Team

--- In guggiusers@yahoogroups.com, Ashish Ranjan <ashishwave@y...>
wrote:
> I have found guggi today. Actually before starting
> using it, i want to ascertain that whether it is free
> or not for commercial (actually inside my own
> organisation, not selling it )use. But could not found
> any info on the site. Can anybody please tell. As i am
> searching only for a free DBA tool.
>
> bye :-)
> Ashish
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com

I have found guggi today. Actually before starting
using it, i want to ascertain that whether it is free
or not for commercial (actually inside my own
organisation, not selling it )use. But could not found
any info on the site. Can anybody please tell. As i am
searching only for a free DBA tool.

bye :-)
Ashish

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com