Home » SQL & PL/SQL » SQL & PL/SQL » what tools can write select statement better?
what tools can write select statement better? [message #260775] Mon, 20 August 2007 22:11 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member


what professional tools can write select statement better?

Please introduce me one. Thanks
Re: what tools can write select statement better? [message #260776 is a reply to message #260775] Mon, 20 August 2007 22:15 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>what professional tools can write select statement better?
Better than what & based upon which metric(s)?

Re: what tools can write select statement better? [message #260808 is a reply to message #260775] Tue, 21 August 2007 00:34 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
A professional developer.
Don't rely on tools to create proper queries. Generated queries tend to be unreadable and full of unnecessary joins.
Re: what tools can write select statement better? [message #260902 is a reply to message #260808] Tue, 21 August 2007 04:19 Go to previous message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

Better to use SQLPLUS but if you want a tool then you can try with the SQL Developer. It's a tool provided by oracle itself.

Cheers
Sanka
Previous Topic: update query
Next Topic: Retriving OS User Name using Job ID
Goto Forum:
  


Current Time: Sat Dec 03 08:08:02 CST 2016

Total time taken to generate the page: 0.25543 seconds