Search results for query: *

Greetings, Does anyone know of a freeware tool to determine the table structure and relationships of an Oracle database? I can link tables through ODBC but am having trouble determing the table relationships from the table names. Can't afford to purchase some of the commercially availble...

Greetings, Basic question. I searched the forum but could not come up with what I need. How do I connect to a Oracle database from access? I tried setting up and ODBC connection but couldn't get it to work. On my desktop I have 1)Oracle and Access 2003 2)a TNSnames entry that others use...

Hi there, We have an Excel macro that analyzes excel data which is currently less than 50,000 rows. Are needs are increasing and need to analyze databases of 100,000 rows or more so we need to go to access. How can we use Access to store the data and export chunks say 25,000 to Excel and have...

Hi There, I want to create a loopback connection on my w2k machine runing 8i1.6 to practice using the DBA studio tools on the database running on the same box. I was told if I use host 127.0.0.1 I can do this. My Tsnames= # TNSNAMES.ORA Network Configuration File...

Hi There, I just installed a sony CD-R/RW CRX215A1 in my Gateway PIII 450 mhz/ Windows 2000 pro machine. The machine booted fine. The machine runs fine and I can play audio CD's from the CD-R/RW. When I try to run the CD-R/RW burner software (B's recorder GOld5.09) I get a blue screen and...

i There, I just installed a sony CD-R/RW CRX215A1 in my Gateway PIII 450 mhz/ Windows 2000 pro machine. The machine booted fine. The machine runs fine and I can play audio CD's from the CD-R/RW. When I try to run the CD-R/RW burner software (B's recorder GOld5.09) I get a blue screen and the...

hi there, I am having trouble running some CD-R/RW software (B's Recorder Gold5) and get the message: "Stop:0x000000D1 (0x000000DB, 0x00000012, 0x00000000, 0xEB4571787) Driver_IRQL_not_les_or_equal" I assume it is a IRQ problem: IRQ Assignment 14 Primary IDE Channel 14 SCSI/RAID...

Hi there, I just installed a CD-R/RW into my Gateway PIII/450 mHZ computer. Windows 2000 PRO service pack 3 Config- CD-ROM -Slave for secondary IDE CD-R/RW-Master for secondary IDE scsi adapter in one PCI slot Ethernet card in another Printer hookedup to the parallel port one floppy- Slave for...

Hi Everyone, I need to create a stored procedure that summarizes info in a table. I want to specify the schema that the table resides in. I tried this code create or replace procedure analyze_dept AS v_dept_record dept%ROWTYPE; BEGIN SELECT * INTO v_dept_record from Scott.dept; END; /...

Hi Everyone, I am trying to convert the anonymous PL/SQL block to a function that is part of a package. anonymous block SET SERVEROUTPUT ON; ACCEPT p_cust_id PROMPT 'What is the customer ID: '; ACCEPT p_start_date PROMPT 'What is the start date (MM/DD/YYYY): '; ACCEPT p_end_date PROMPT...

I have nested FOR loops to retreive two fields from a record. I then have IF..THEN..ELSEIF logic that compares one of the fields and uses the other field for a calculation. When I try to run this I keep getting errors: ORA-06550 Encountered the symbol "ITEM_TOT_RECORD" when...

I have nested CURSOR FOR loops to retreive two fields from a record. I then have IF..THEN..ELSEIF logic that compares one of the fields and uses the other for a calculation. When I try to run this I keep getting errors: ORA-06550 Encountered the symbol "ITEM_TOT_RECORD" when...

Hey all, I am a technical user who wants/needs to learn a bit of basic Access 2000 programming. My programming experience is limited to an introduction to programming course, one Java course and an Oracle SQL course. Any suggestions for books that may be useful in getting my feet wet...

Hi Everyone, I have a schedule table that uses varchar2 as datatype for the fields start_time and end_time. I want to put constraints on the end_time field so that the value must be after 9:00 AM (opening time) and before 9:00 PM (closing time). Also a similar constraint for the start_time. I...

Greetings: I am just learning SQL and have been given an assignment to create a script to prompt a user for values and then enter the values into a table. I am familiar with the variable @ and @@ for queries but cannot seem to get it work for the insert function. My script is below with the...

Hey, I am trying to export an Access 2000 table into excel. If I try to use the anylize with Excell function my fields that are >255 characters get truncated. Ditto if I try cutting and pasting into Excel. If I export table object directly a bunch of nonprintable formatting characters gets...