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 gkittelson 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: dooge
  • Order by date
  1. dooge

    SQL works standalone but not wrapped around begin/end

    Actually it didn't solve the problem entirely. The query looks more like: UPDATE monthly_totals mt SET checking_total=nvl( (SELECT sum(check_amount) FROM checks c WHERE c.customer_id=mt.customer_id and c.month=mt.month) ,0), previous_balance=nvl(...
  2. dooge

    SQL works standalone but not wrapped around begin/end

    Yes, I simplified the query to my problem. It's quite a bit more complex than what is shown above. I did end up doing what carp did above. If the nvl on the function is invalid, then why did it work at sqlplus without the begin/end wrapped around it?
  3. dooge

    SQL works standalone but not wrapped around begin/end

    I run the following in sqlplus and get an error. ------------------------------------- BEGIN UPDATE account SET activity_total = nvl((SELECT 5 FROM dual),0); END ------------------------------------- However when I run the following in sqlplus...
  4. dooge

    sql source used to create tables

    In oracle's dbastudio, when you select a table it shows the SQL text used to create the table. Where is this stored in the database (if it is)?

Part and Inventory Search

Back
Top