Using Oracle backend for the first time...???'s

[LMCRYER]

OK, here's my question. I ve been using Crystal for a long time and I'm hooked on SQL - stored procedures, views, doing queries, etc.

I've just started doing some stuff for a new company and they use a package called Logician - which is an Oracle backend.

There is nobody else in the office that knows anything about Oracle, and I need to be able to do more than what I can do now.

I know that in SQL you can do direct queries and create your own stuff on the back end -- (SQL Manager, etc) but WHAT IS THE ORACLE EQUIVALENT?

Tried doing some stuff in MS Query and Access - both run real, real slow (I want to do this on the backend so its faster and I can really work in there and SEE stuff...

How do I do this? What do I use? Any and all advice is very much appreciated!

LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[lyanch]

Crystal has a white paper on this. I would start there.

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_oracle_stored_procedures.pdf

Lisa

 

[Guest_imported]

Dear LMCryer,

Try this
select * from Management where proj_mgmt_skills is not NULL

Regards,
Rohit

 

[Guest_imported]

Dear LMCryer,

Try this
select * from Management where proj_mgmt_skills is not NULL

Regards,
Rohit

 

[Naith]

...so funny you had to read it twice...

Lisa(1),

Oracle is a a superb database to work with, but it helps if you have a friendly tool which allows you to peruse the data and construct sql in a quick, simplistic manner.

Try and get hold of a freeware download from

http://www.toadsoft.com/

called TOAD. (Tool for Oracle Application Developers). Conceptually, it works pretty much like any other SQL Manager you're used to.

I appreciate you're a little at sea because you haven't used Oracle before, but to be honest, I'm not sure what you really want to get here. A guide to Oracle SPs, a SQL aid, performance guide?

If you have specific queries, post 'em up, and we can sort you out.

Naith

 

[LMCRYER]

Well - right now I just want to be able to run some nice queries and look at my back end better without having to use MS Query - brining it in the front is making it SLOW - theres a LOT of data back there!

For now, one thing at a time, first thing is getting a good tool to use...(I also hate MS Query becuase of the limits relating to the join types, etc and cant make it do subqueries ...)

I will look at TOAD this morning and see what I can find.

I guess my basic question was - why isnt there some kind of &quot;Oracle Manager&quot; like the &quot;SQL Manager&quot; that Im used to - or something like it? Nobody in the office seems to think theres anything comparable and I know better than that.

I mean, come on. Oracle wouldnt be a good tool if it DIDNT have some sort of way of doing queries right off your back end, correct?

Thanks for the info and please keep sending any ideas my way.

LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[Naith]

The truth is Oracle has absolutely loads of sql tools which allow you to dive into your data. Oracle's own SQLPlus, which you should already have installed on your Oracle client allows you to pitch your sql right at the database.

The reason I pointed you at TOAD is because (aside from the fact that it's free,) it does everything SQL Manager does and more. Obviously it assumes you know some SQL, but I assume you already know about that from your little post signatures. Once you've got SQL down, it'll allow you to do everything from simple queries to nearly full-on database management.

I'm an Oracle DBA and it hasn't given me any reason to complain. Yet.

Good luck,

Naith

 

[lyanch]

Ah .. tools... I like Naith also like Toad (even ToadFree)...

I also like Golden32 from Benthic (works only on Oracle as far as I can tell). They however don't have an unlimited &quot;free&quot; version. You can download a trial @

http://www.benthicsoftware.com/downloads.html

Oracles SQLPlus and Management console are not immediately intuative switching from SQL's tools. Its all there... just not in the manner your used to seeing it.

All of them require a little more pure SQL knowledge that SQL servers tools.

Lisa