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 derfloh 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: *

  1. kevineva

    can I use a select LIKE on a Long Field

    We're using "Oracle9i", right? 9.2, hopefully? Then you can follow Oracle's advice: Stop using longs. use to_lob to convert the column to a CLOB. Then you can use context to provide all the cool full text searching you could ever want, or, if you just need to treat it like a big...
  2. kevineva

    Oracle view not working

    This type of error arises in CR 7,8,9 because they are using the Oracle7 OCI programmer's library. We have noticed significant problems with CLOB handling that are due to this problem as well. CR10 allegedly addresses this problem.
  3. kevineva

    VARCHAR to DATE

    Dug, I'm inferring (ok, guessing) a bit here, but it looks like in your import script, you are probably doing something like: insert into bar(rtg_commit_start_dt) select to_date(commit_date,'mmdyyyy') from foo; when what you really want to do is: insert into bar(rtg_commit_start_dt) select...
  4. kevineva

    Oracle 10g install requirements

    Documentation links to the production release are now available on OTN... http://otn.oracle.com/documentation/database10g.html
  5. kevineva

    10g

    Not at the expense of DOING something with 9i/10g. I'd much rather talk to someone who can talk intelligently about their experience implementing a 9i DB with a transparent gateway to MSSQL, and about the recovery scenario from the major fire they had last year, rather than four hours of...
  6. kevineva

    10g

    The job of a dba is going away only if you think that the only job requirements are to make sure redo logs are sized appropriately. Right now, I'm working with some dbas to install oracle collaboration suite -- so now, the dba group will be responsible for installing, tuning, and maintaining a...
  7. kevineva

    Temporary table insert before creation problem!

    How are you 'output to screen'ing? Most languages can deal with ref cursors in some way shape or form. That sounds like the best way to meet your requirements.
  8. kevineva

    Temporary table insert before creation problem!

    In general, this type of question indicates that you're probably not using temporary tables in a way that makes sense in Oracle. If your plan is to create a table, fill it with values, do something to the rows you've generated, then drop the table, this is *not* what Oracle intends to support...
  9. kevineva

    Query taking too long - Hangs VB app

    How fast do your users read? I'm pretty good at it, but 300,000 rows is a LOT of data. (300,000 rows x 5 secs. per row = 17 days 24/7) Do your users really need to see more than a tiny, tiny subset of that information? Like one? I think that's what you should focus on. Writing 300,000 rows to...

Part and Inventory Search

Back
Top