Recent content by teado

I briefly looked at the Oracle Reference Guide, as this interests me as well. Try looking at using the SEQUENCE functionality in the control file. I've not had to write a control file with this, so I don't have any examples. But it looks like you'll have to add a column to the tables you are...

Toward the beginning of the SQL script: set termout off

Not sure if this would work, please correct me if it won't: (same control file) ... INTO TABLE (table) WHEN (23:25) = 'AB' ( ... ) INTO TABLE (table) WHEN (23:25) = 'BC' ( ... ) and so on. We use something similar to create multiple rows from one line.

A very quick stab for what I interpreted that you were looking for. HTH, or at least points in the right direction... -- Get 02/null recs where an 03 rec doesn't exist select * from table a where rec_type = '02' and lot_nbr is null and not exists (select 'x' from table b...

technet.oracle.com also has all of the other Oracle error messages down to Oracle 8 (maybe even 7.3). It's definitely worth registering (free), if you haven't already.

I am sure there's a much prettier way of doing it, but I just tried: select to_char(to_date(to_char(180*60),'SSSSS'),'HH24:MI') from dual; = 03:00

Thanks for the responses. My boss did say his experience was at a previous job, which would have been several years earlier. I suspect he might have had a logic bug and not realized it. - Jeff

Greetings all, I was discussing with my boss the reasons why I chose to use SQL%rowcount within a PL/SQL program. He mentioned that at one point, using the SQL%rowcount, found, and notfound functions were not consistent, nor 100% reliable. I looked around online (as well as here), but have...

I'd ask the instructor first for some guidelines as there's so many ways this project could be accomplished. One thing I think we'd all agree on is focusing more on database design, rather than what the GUI and reports would look like.

Ruling out the simple causes: The Lexmark is not a USB printer, right?

I assume you are learning Oracle on your own, however, I think if you are learning Oracle through a higher ed institution, there's a license available that doesn't require you to uninstall or purchase the software after 30 days. You just can't use it for a production environment (it's for...

Actually, the MS webpage even indicates that up to 10 monitors will work with the Home version - 2nd Paragraph, under "More Space to see your work". :) (if I ever need more than 2 monitors, though, I need to find another line of work :) )

You do not need Pro for multiple monitors - Home will support it.

Small note - I had a few years of PC/slight UNIX experience, and took DBA classes at my university that were 'Oracle approved', and I found that going in as a DBA without having prior Oracle DBA experience is extremely difficult. I would suggest considering an Oracle developer job, and see if...

The way it sounds is that your PC doesn't know which network connection to use (example, if you have a modem pre-installed and a network connection). Look around AIM (and it's not as bad as what people say - although AIM isn't my first choice, most my friends use it)...anyway, look around in...