Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dtboy
  • Order by date
  1. dtboy

    Can I do this in Oracle?

    For the benefit of those who don't have the DB handy, following from the first select statement above: select * from master_tbl where job_id IN (select job_id from code_tbl); 4 Bill 1 5 George 2 1 John 3 5 LaToya 3 select * from master_tbl where job_id NOT IN (select job_id from code_tbl); 2...
  2. dtboy

    Can I do this in Oracle?

    Yes I can elaborate. NOT IN can be very dangerous. create table master_tbl ( user_id number, user_name varchar(30), job_id number ) create table code_tbl ( job_id number, job_desc varchar(20) ) insert into master_tbl values (1,'John',3); insert into master_tbl values (2,'Sarah',4); insert...
  3. dtboy

    command object does not refresh correctly

    Hhhmmm. I AM one to argue and I'd have to stay on the side of kludgy. A table is a table is table - that is the great thing about a database. Someone else can come along and change the join/link in the future as needed. If I have to write the join within the SP, that will require someone in...
  4. dtboy

    command object does not refresh correctly

    Oops...I forgot about all of the other aggregation that goes on even to get to the point where you'd have 9 million rows. Not sure it will work. I mean, I could definitely precalculate all 9 million rows and it would work, but then you deal with the physical storage requirements changing...
  5. dtboy

    command object does not refresh correctly

    BTW another thing I'm thinking of doing is changing the existing view that the report runs off of (which would have its data updated by the stored procedure) to do a cartesian product of all possible results by date. (time granularity is only per day, thank goodness) The total number of possible...
  6. dtboy

    command object does not refresh correctly

    Turkbear, synapsevampire, Thanks. exec didn't work. I'm sure I have the right syntax to call the sp because it does work the first time. I am using native oracle drivers. Turkbear, I will have to try it this way, I suppose. But like I said it's totally kludgy if they make you do something...
  7. dtboy

    command object does not refresh correctly

    No problem I mix them up sometimes too because I also develop in SQL server. EXEC is oracle syntax in SQL plus to run a sql script that is a local file but I've never used it to run a procedure residing on the database. BEGIN procedure_name END; is what I've used to call procedures inline in...
  8. dtboy

    command object does not refresh correctly

    synapsevampire, Thanks for the quick reply. That seems like SQL server syntax, I got this error msg when I tried it... Failed to retrieve data from the database. Details: ORA-00900: invalid SQL statement I think it expects you to put exactly into that box what the command would be in sqlplus...
  9. dtboy

    command object does not refresh correctly

    Hello, I'm a pretty experienced Crystal user but I've never had to use a command object. In this case, what I'm using it for is to call a stored procedure, which then pre-aggregates a very complex dataset in the database (Oracle 9i). I don't know why Crystal doesn't give you a simple option to...

Part and Inventory Search

Back
Top