Search results for query: *

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...

You can also check these simple things: 1. I assume your computer is 100% powered off - NOT on sleep. Mine will come out of sleep mode when I'm not around; I assume my mouse is twitchy enough that it gets moved around (thanks to my upstairs neighbors who walk like elephants). 2. Check BIOS...

The Win98 startup disk will not allow you to format using NTFS. Although I'm not versed in Partition Magic, rule of thumb is you may as well try it before putting anything that you might need on the system. Otherwise, I don't think you'll have to reactivate XP installing from an OEM disk...

Create a Win98 boot floppy disk on another machine. If the hard drive is formatted as FAT32, I think that by booting up with the Win98 floppy disk, you'll be able to see the hard drive (I assume it's the 'C:' drive). If there's not that many files, and they are less than the 1.4MB of a floppy...

Make sure there are drivers - check with the vendors before you put the $$$ out. I agree, it doesn't make sense to buy Win 98; if the vendors don't have drivers for your peripherals, at least check to see when they plan on having them done. My Intel PC Camera doesn't have XP drivers, and it's...

Thanks for the help. I don't think I had a good example, but I think I have found the solution.