Re: SQL Help Urgent!!!!!!!!!

Hello sultan   You can create a view for the cc table and use with the bb table to display the output .   create view cc_view as select id, sum(amount) amt from cc group by id   select a.id,a.amount ,b.amount from bb a,cc_view b where a.id=b.id;   Hope this solution work's for u.   I will als

Re: SQL Help Urgent!!!!!!!!!

> sultan wrote: > > Hi gurus > > I have two tables like this > > > SQL> select * from bb; > > ID AMOUNT DT > -- -- -- > 1 1000 10-MAY-02 > > > > > SQL> select * from cc; > > ID AMOUNT > --

RE: SQL Help Urgent!!!!!!!!!

Select a.id,a.amount,ccinlineview.bamt from bb a,(Select id,sum(b.amount) bamt from cc b group by id) ccinlineview where a.id = ccinlineview.id ID AMOUNT BAMT -- -- -- 1 1000 1000 1 row selected.   -Original Message-From: sul

Create user_exit under unix

Dear Gurus, I use : - Oracle Server 8.1.6.0 - Oracle Pro*FORTRAN 1.8.52.0.0 - Oracle Developer 6i release 2 Under SUN Solaris 2.8. Could you please tell how to create USER EXIT on Oracle Developer 6i using those tools above? I'll very apreciate for every reply. regards, Ahmadsyah A.N. -- Plea

SQL Help Urgent!!!!!!!

Hi gurus   I have two tables like this     SQL> select * from bb;       ID AMOUNT     DT-- -- -- 1   1000  10-MAY-02         SQL> select * from cc;       ID AMOUNT-- ---

SQL Help Urgent!!!!!!!!!

Hi gurus   I have two tables like this     SQL> select * from bb;       ID AMOUNT     DT-- -- -- 1   1000  10-MAY-02         SQL> select * from cc;       ID AMOUNT-- --- 1

ways to allow developers to see all packge bodies without EXECUTE ANY PROCEDURE?

Good day listers, We have some developers that would like to see all the package bodies in our data warehouse. This is a reasonable request. The developers use Toad, which used the ALL_SOURCE view. I pulled the code for all_source and discovered that the execute_any priv exclusion is hardcoded

RE: Oracle Diagnostic and Tuning Packs

And I normally don't disagree with you Jared but in this case I must. I evaluated both quite extensively just a month or so ago. They both give you the same type of control really, just in a slightly different format. OEM's was actually easier to use with no prior instruction. Both are push butt

RE IMPORT Urgent

In digest mode so sorry if I'm late :) > These tables on the production database are protected so I can export them > only as sys user.I am attaching the log from the import.What is the problem. > Am i missing anything I believe the tables will still be owned by the original user. We probably sh

Re: Oracle Diagnostic and Tuning Packs

I will have to respectfully disagree with that, at least in part. There is a big difference between change management in OEM tools and Quest tools, Quest's tools being much better. The OEM tools are push button, just like MicroSlush garbage. Meaing: The OEM tools do no give you near the contr

Re: Oracle Diagnostic and Tuning Packs

Hello Peter We did a comparison between quest tools and OEM. The bottom line was that all these tools gives you about the same functionality and there is no BIG difference between them. Our manager got a better deal from Oracle so we bought these packs. We hope to start implementing them this q