Query creation and Toad

"Clas" wrote in message
news:43ef7804$0$28076$4fafbaef@reader1.news.tin.it...
> Hi, I want to create a complex query... but I would like to "draw" it as
in
> Ms SQL Server Enterprise Manger.
>
> I've tried to use TOAD, I've a SQL Modeler Windows, but with this tool I
> can draw the query (link the table) and than TOAD creates the text query
>
> ... but I would like to paste a text query and to see the Tables linked
(as
> in Ent.Manager)
>
> How Can I do this???

No , you actually need a little talent and type the query. TOAD assumes you
know something about constructing queries. Sorry, perhaps this product is
too advanced for you.
Jim

"Clas" wrote in message
news:43ef7804$0$28076$4fafbaef@reader1.news.tin.it...
> Hi, I want to create a complex query... but I would like to "draw" it as
in
> Ms SQL Server Enterprise Manger.
>
> I've tried to use TOAD, I've a SQL Modeler Windows, but with this tool I
> can draw the query (link the table) and than TOAD creates the text query
>
> ... but I would like to paste a text query and to see the Tables linked
(as
> in Ent.Manager)
>
> How Can I do this???

No , you actually need a little talent and type the query. TOAD assumes you
know something about constructing queries. Sorry, perhaps this product is
too advanced for you.
Jim

"Jim Kennedy" wrote in
news:xcKdnWimSu-ME3LeRVn-uQ@comcast.com:

>
> "Clas" wrote in message
> news:43ef7804$0$28076$4fafbaef@reader1.news.tin.it...
>> Hi, I want to create a complex query... but I would like to "draw" it
>> as
> in
>> Ms SQL Server Enterprise Manger.
>>
>> I've tried to use TOAD, I've a SQL Modeler Windows, but with this
>> tool I can draw the query (link the table) and than TOAD creates the
>> text query
>>
>> ... but I would like to paste a text query and to see the Tables
>> linked
> (as
>> in Ent.Manager)
>>
>> How Can I do this???
>
> No , you actually need a little talent and type the query. TOAD
> assumes you know something about constructing queries. Sorry, perhaps
> this product is too advanced for you.

This product is SQL.

I suspect the OP desires a drag & drop GUI.

"Jim Kennedy" wrote in
news:xcKdnWimSu-ME3LeRVn-uQ@comcast.com:

>
> "Clas" wrote in message
> news:43ef7804$0$28076$4fafbaef@reader1.news.tin.it...
>> Hi, I want to create a complex query... but I would like to "draw" it
>> as
> in
>> Ms SQL Server Enterprise Manger.
>>
>> I've tried to use TOAD, I've a SQL Modeler Windows, but with this
>> tool I can draw the query (link the table) and than TOAD creates the
>> text query
>>
>> ... but I would like to paste a text query and to see the Tables
>> linked
> (as
>> in Ent.Manager)
>>
>> How Can I do this???
>
> No , you actually need a little talent and type the query. TOAD
> assumes you know something about constructing queries. Sorry, perhaps
> this product is too advanced for you.

This product is SQL.

I suspect the OP desires a drag & drop GUI.

> Hi, I want to create a complex query... but I would like to "draw" it as
in
> Ms SQL Server Enterprise Manger.
>
> I've tried to use TOAD, I've a SQL Modeler Windows, but with this tool I
> can draw the query (link the table) and than TOAD creates the text query
>
> ... but I would like to paste a text query and to see the Tables linked
(as
> in Ent.Manager)
>
> How Can I do this???

If TOAD can't do it, try our tool: Database Workbench - it supports
Oracle 8 to 10 and has a two-way visual query builder:
Check:
http://www.upscene.com/products/dbw/whatsnew.htm

There will be a new version release tomorrow (Monday) with lots
of bugfixes :-)


--
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> Hi, I want to create a complex query... but I would like to "draw" it as
in
> Ms SQL Server Enterprise Manger.
>
> I've tried to use TOAD, I've a SQL Modeler Windows, but with this tool I
> can draw the query (link the table) and than TOAD creates the text query
>
> ... but I would like to paste a text query and to see the Tables linked
(as
> in Ent.Manager)
>
> How Can I do this???

If TOAD can't do it, try our tool: Database Workbench - it supports
Oracle 8 to 10 and has a two-way visual query builder:
Check:
http://www.upscene.com/products/dbw/whatsnew.htm

There will be a new version release tomorrow (Monday) with lots
of bugfixes :-)


--
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

On 12-Feb-2006, "Martijn Tonies" wrote:

> http://www.upscene.com/products/dbw/whatsnew.htm


Witch product I must to download???

Is it possible to work with Oralce?? Isee MySQL and SQL Server only

Thanks

On 12-Feb-2006, "Martijn Tonies" wrote:

> http://www.upscene.com/products/dbw/whatsnew.htm


Witch product I must to download???

Is it possible to work with Oralce?? Isee MySQL and SQL Server only

Thanks

> > http://www.upscene.com/products/dbw/whatsnew.htm
>
>
> Witch product I must to download???

"Database Workbench"

www.upscene.com/downloads.htm

> Is it possible to work with Oralce?? Isee MySQL and SQL Server only

It works with Oracle 8 to 10.


--
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com