Home » Other » Client Tools » Suggestion for using sql developer (Oracle 11gr2,Linux)
Suggestion for using sql developer [message #601659] Sat, 23 November 2013 17:35 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Can we (DBA) request application developers to use sql developer or Toad tool to just run select queries in database ?

Request your advice on this.

Regards,
Jack

[Updated on: Sat, 23 November 2013 17:35]

Report message to a moderator

Re: Suggestion for using sql developer [message #601660 is a reply to message #601659] Sat, 23 November 2013 18:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what difference which client is used to issue SQL?


why not use http://squirrel-sql.sourceforge.net/ ?
Re: Suggestion for using sql developer [message #601661 is a reply to message #601660] Sat, 23 November 2013 19:15 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Blackswan,

I am not asking to suggest for Oracle client tool .Could you reread my question once again ?

Thanks
Re: Suggestion for using sql developer [message #601662 is a reply to message #601661] Sat, 23 November 2013 19:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can we (DBA) request application developers to use sql developer or Toad tool to just run select queries in database ?

I give up.
Can you?
Re: Suggestion for using sql developer [message #601666 is a reply to message #601659] Sun, 24 November 2013 01:33 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Jack, your question is ambiguous. I can see two meanings:

1. The developers run SELECT queries. Can we ask them to use SQL Developer or TOAD for this, and not to use (for example)SQL*Plus?

2. The developers use SQL Developer or TOAD. Can we ask them to run only SELECT queries, and not (for example) UPDATES?

Either way, of course you can ask them. Or do you mean force them?

Re: Suggestion for using sql developer [message #601695 is a reply to message #601666] Sun, 24 November 2013 10:42 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
John,

I will rephrase my question.

I don't know whether application developers can use sql developer/toad or any other client to run queries.As of now they are just diagnosing the error faced in application end and they often ask us (DBA) to run select queries to extract transaction details from database for hourly based. So my question here is can we( DBA)ask them to start using client tool to run queries ?

I hope my question is clear now.

Thanks

[Updated on: Sun, 24 November 2013 10:44]

Report message to a moderator

Re: Suggestion for using sql developer [message #601697 is a reply to message #601695] Sun, 24 November 2013 11:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I don't know if you can ask them. I suppose it depends on whether you speak the same language.
Re: Suggestion for using sql developer [message #601698 is a reply to message #601697] Sun, 24 November 2013 11:22 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
I suppose it depends on whether you speak the same language.

We speak the same language but what to do if they refuse to use sql developer and ask us to provide the data from database that too for select query.

[Updated on: Sun, 24 November 2013 11:22]

Report message to a moderator

Re: Suggestion for using sql developer [message #601700 is a reply to message #601698] Sun, 24 November 2013 11:27 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
This question looks suspiciously like trolling: am I meant to get angry at such stupidity?
I shall not lock the topic in case someone else thinks it is a serious question. But I shall cease to subscribe to it.
Goodbye.

Re: Suggestion for using sql developer [message #601705 is a reply to message #601700] Sun, 24 November 2013 12:31 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
John,

There is nothing to get angry for small small things.If you dont know or would not like to answer any questions just skip the thread.simple.
Re: Suggestion for using sql developer [message #601708 is a reply to message #601659] Sun, 24 November 2013 13:10 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Jack14 wrote on Sun, 24 November 2013 05:05


Can we (DBA) request application developers to use sql developer or Toad tool to just run select queries in database ?



Jack,

Few details are required here :
1. What exactly is the issue that the application developers are facing?
2. Why is it that a 3rd party tool specific issue is brought to a DBA's attention?
3. Does the select statement make any difference in terms of output or the performance with respect to the tools you have mentioned?

Depending on your answers we could move forward with a solution.
Re: Suggestion for using sql developer [message #601712 is a reply to message #601708] Sun, 24 November 2013 14:22 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Lalit,

Quote:
1. What exactly is the issue that the application developers are facing?

Application developers are not facing any issue at the moment.

Quote:
Why is it that a 3rd party tool specific issue is brought to a DBA's attention?

Application team wants to know transaction details for every hour from database so we provide them output by running select statement from database.
We use sql developer to have a clear output format and easy to login to database as and when required.So we use sql developer to extract the data from database.

Quote:
Does the select statement make any difference in terms of output or the performance with respect to the tools you have mentioned?

No

Thanks

[Updated on: Sun, 24 November 2013 14:23]

Report message to a moderator

Re: Suggestion for using sql developer [message #601714 is a reply to message #601712] Sun, 24 November 2013 14:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Problem & solution is external to Oracle & topic not appropriate for this forum

[Updated on: Sun, 24 November 2013 14:30]

Report message to a moderator

Re: Suggestion for using sql developer [message #601717 is a reply to message #601714] Sun, 24 November 2013 15:24 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Lalit kumar ,

Thanks for your interest to come forward and asking questions .
Re: Suggestion for using sql developer [message #601718 is a reply to message #601698] Sun, 24 November 2013 19:43 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Jack14 wrote on Sun, 24 November 2013 11:22
Quote:
I suppose it depends on whether you speak the same language.

We speak the same language but what to do if they refuse to use sql developer and ask us to provide the data from database that too for select query.



Then this is entirely a a management issue internal to your organization.
Re: Suggestion for using sql developer [message #601724 is a reply to message #601712] Mon, 25 November 2013 00:25 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Jack14 wrote on Mon, 25 November 2013 01:52
Application team wants to know transaction details for every hour from database so we provide them output by running select statement from database.
We use sql developer to have a clear output format and easy to login to database as and when required.So we use sql developer to extract the data from database.


If it is a regular process to provide data in regular intervals, then just automate the process. Create a script and schedule the job to spool the data in your required format and send it to the application team. There are lot of options available.
Re: Suggestion for using sql developer [message #601727 is a reply to message #601724] Mon, 25 November 2013 01:19 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just being curious: what tool do your "application developers" use to develop applications? I'm quite sure that I wouldn't be able to write a decent form, report or whatever without SQL*Plus (or TOAD or SQL Developer or ...).
Re: Suggestion for using sql developer [message #601782 is a reply to message #601727] Mon, 25 November 2013 11:18 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you all for your interest in my thread.

Lalit,
Quote:
If it is a regular process to provide data in regular intervals, then just automate the process. Create a script and schedule the job to spool the data in your required format and send it to the application team. There are lot of options available.

I am not talking about only regular process.I want them to use sql developer tool for all select queries being used in database.

As per EdStevens suggestions, i will have to check with management team.

Thanks for everyone you took intereset in clarifying questions and suggesting.
Re: Suggestion for using sql developer [message #601783 is a reply to message #601782] Mon, 25 November 2013 11:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I want them to use sql developer tool for all select queries being used in database.

what difference does it make which client is used to issue SQL?
Re: Suggestion for using sql developer [message #601792 is a reply to message #601783] Mon, 25 November 2013 16:25 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Blackswan,

< what difference does it make which client is used to issue SQL? >

My concern is not about using which client is used to issue SQL .My concern is currently developers are not using sql developers to run
any select query and they often ask us to rprovide the data by running select queries.In this case , can we ask them to start using sql developer
to run select query by themselves since select query will have no harm to database.

I hope my question is clear now.

Thanks

[Updated on: Mon, 25 November 2013 16:26]

Report message to a moderator

Re: Suggestion for using sql developer [message #601793 is a reply to message #601792] Mon, 25 November 2013 16:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>to run select query by themselves since select query will have no harm to database.
except when Cartesian Product floods the DB & disk subsystem.

Who is "they"?
Are "they" duh-velopers who can't issue their own SQL statements?
Then what exactly are "they" developing using what tool(s)?
Previous Topic: SQL developer hangs on Win XP if not admin
Next Topic: How to compare the two different explain plan in PL/SQL Developer
Goto Forum:
  


Current Time: Thu Mar 28 11:10:41 CDT 2024