OraFAQ Forum: Client Tools » Suggestion for using sql developer

Home » Other » Client Tools » Suggestion for using sql developer (Oracle 11gr2,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Suggestion for using sql developer [message #601659]

Sat, 23 November 2013 17:35

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

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/ ?

Report message to a moderator

Re: Suggestion for using sql developer [message #601661 is a reply to message #601660]

Sat, 23 November 2013 19:15

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

Report message to a moderator

Re: Suggestion for using sql developer [message #601662 is a reply to message #601661]

Sat, 23 November 2013 19:54

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?

Report message to a moderator

Re: Suggestion for using sql developer [message #601666 is a reply to message #601659]

Sun, 24 November 2013 01:33

John Watson
Messages: 8964
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?

Report message to a moderator

Re: Suggestion for using sql developer [message #601695 is a reply to message #601666]

Sun, 24 November 2013 10:42

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

John Watson
Messages: 8964
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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601698 is a reply to message #601697]

Sun, 24 November 2013 11:22

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

John Watson
Messages: 8964
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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601705 is a reply to message #601700]

Sun, 24 November 2013 12:31

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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601708 is a reply to message #601659]

Sun, 24 November 2013 13:10

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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601712 is a reply to message #601708]

Sun, 24 November 2013 14:22

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

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

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Lalit kumar ,

Thanks for your interest to come forward and asking questions .

Report message to a moderator

Re: Suggestion for using sql developer [message #601718 is a reply to message #601698]

Sun, 24 November 2013 19:43

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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601724 is a reply to message #601712]

Mon, 25 November 2013 00:25

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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601727 is a reply to message #601724]

Mon, 25 November 2013 01:19

Littlefoot
Messages: 21823
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 ...).

Report message to a moderator

Re: Suggestion for using sql developer [message #601782 is a reply to message #601727]

Mon, 25 November 2013 11:18

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.

Report message to a moderator

Re: Suggestion for using sql developer [message #601783 is a reply to message #601782]

Mon, 25 November 2013 11:23

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?

Report message to a moderator

Re: Suggestion for using sql developer [message #601792 is a reply to message #601783]

Mon, 25 November 2013 16:25

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

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)?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:41:59 CST 2025