Archive

How to export a Access Table to Oracle

Hi,

I have a big table in Access containing some records. I need to export them to Oracle database running on the same machine.

The table has only 3 fields. Transaction ID, Customer, Salesman.

How do I send them to Oracle? Do I need to create a table there or something like that? I do not know Oracle. 

Is there any simple way to do so? I played around Office 2007, export option but the closest I could get was to export to a text file. My friend said that you can also use this text file as an input in Oracle. But...

Read more
Blake N/A Written on 05/12/2011 in Question

Interfacing a robot arm with C++ in linux.

Hi,

I recently built a Robotic Arm to move objects by human Control. The model was fine and effective. So my new partner who is an Image Processing expert wants to work as a team to expand it.

The problem is, he is on Linux. I don’t know much of Linux. So is there any way I can interface the controller with a PC running Linux, using C++?

The current design uses a small keypad, having 12 keys to control the arm(8) to move (4) to up/down/hold/leave . Each of them generating a 8 bit signal....

Read more
JJClerk N/A Written on 05/12/2011 in Question

Help Normalizing a Big Table to 3 Sub Tables

Hi,

I am assigned for normalizing an established database written in MySQL. The database consists of only 1 table, with about 18 columns. All of them having information about the members(personal detail), their address, and job detail. I exported the database to Oracle with some effort, but I do not know how to divide this big table to 3 smaller ones. Here is the main table:
 
ID VARCHAR2(500),
NAME VARCHAR2(500),
ADDR VARCHAR2(500),
AREA_CODE VARCHAR2(500),
TEL VARCHAR2(100),
AINS VARCHAR2(100),
YEARPASS VARCHAR2(100),
CENTRE VARCHAR2(500),
DOP VARCHAR2(100),
DUES VARCHAR2(100),
DIPNO VARCHAR2(100),
CODE VARCHAR2(100),
DEPT VARCHAR2(100),
DOB VARCHAR2(100),
GENDER VARCHAR2(100),
EMAIL VARCHAR2(100),
RELIGION VARCHAR2(100),
FAX VARCHAR2(100),
FOREIGN VARCHAR2(100),
MEM_ID NUMBER
 
I have designed the children tables as follows. They will also use lookup tables, for...

Read more
Hansey N/A Written on 05/12/2011 in Question

How to increase default table space size of a custom Oracle?

Hi,

I have a user created in Oracle by the name "joseph". The initial table space was named as "tspjoseph" which used a data file named "josephtsp.dbf". Unfortunately, I set the size to 1GB which is not full filling the requirement. My whole software is up and the database is also filled with important data. Is there any way I can increase it, without affecting the current data?

Read more
Joseph King N/A Written on 05/12/2011 in Question

How to combine two or more photos?

I want to combine a couple of  images, like placing them together and still undetectable. I want it to be realistic and at the same time easy to do. Can anyone help me?

Read more
Aquinaldo N/A Written on 05/12/2011 in Question

Sticky Virus In My Computer

Hi,

I am using Windows Vista and two viruses were detected by Norton security scan that I have on my system. My computer has been infected with Trojan.ByteVerify and Downloader virus and some other tracking cookies. However, I have not bought the Antivirus software, yet I managed to keep it updated. I called Norton to find how can I get rid of the viruses. They suggested me that I would not be able to remove the viruses even if buy the software since my system got infected before buying the software.
 
So I checked on internet for...

Read more
esftech N/A Written on 05/12/2011 in Question

How to connect one laptop with two projectors

Hello,

I was wondering if anyone has the same problem with me. I have two projectors with two projector screens and I want to connect it to one Laptop and using PowerPoint to do a presentation for my boss. The projector is NEC VT480 and the laptop is Dell E4300.
 
I've tried googling for PowerPoint setup with two projectors but no solution yet. I've tried searching for the correct setting to sync both projectors to one laptop (since they're the same brand and type) but not working as well. I've looked in the user manual on how to do that but...

Read more
mstephen1978 N/A Written on 05/11/2011 in Question

Freeware Video Converter with good quality

I have been searching a Free Video Converter for so long, and unluckily I haven't found yet the perfect software that has no watermark and good features on it.

Here's my journey in searching for the kind of software that I'm looking for:

  • I've spotted a software which has watermark too, but the thing is it is only for a 10 days free trial. And what I'm looking for is that a full free version on it.
  • I've tried Xilisoft, but it loses a quality from the original video, such as the delaying for the dialog.
  • I found this freeware with a very...

    Read more
alexa N/A Written on 05/11/2011 in Question

My USB ports are not working, how can I repair them?

Hello,

I am having some troubles with the USB ports on my Desktop PC. Some days ago, while I used to using a flash drive on that ports, it was not working properly. After restarting the operating system, it began to work. I faced this problem for several times and I used to solve this problem by restarting the pc. But this time I have got a serious problem that these ports are not working anymore and this problem is not being solved by restarting the PC. I tried every possible solution to my PC. But I got failure.

To solve...

Read more
john_michel N/A Written on 05/11/2011 in Question

Oracle User Scott not accessing

Hi,

I am using Oracle to learn SQL. Just introductory. I downloaded the Oracle setup file from Oracle's homepage named - "oracleXE 10g". The software installed successfully, but I don't seem to find the user Scott, which was used in the class lecture. I missed the lecture so could not figure out if there was anything said which was not covered in the papers. I asked a partner who said it was a default user. Then why can't I access it? Do I need a configuration or something to be set up at the beginning? Or am I using the...

Read more
Will Turner N/A Written on 05/11/2011 in Question