Recent content by dave_p

there is a lot involved in this depending on the source table structure, and the destination data structure. im sure the data requirements of the two applications are different, and are normalized differently, data fields are different etc. if you can get .csv files of the oracle data, you...

you can certainly get a start with C. its structured, has a pretty easy syntax, and it is fairly easy to compile simple programs. you can get older copies of borland c for free(or with books), the ide is pretty intuitive. for simple things its as easy as writing your code in the editor window...

is your heart set on java? its a simple matter with VB

Sub convert() Dim pobjCell As Range Dim plCharCounter As Long Dim psCellText As String For Each pobjCell In Selection psCellText = pobjCell.Text ActiveSheet.rtb.TextRTF = psCellText pobjCell.Value = ActiveSheet.rtb.Text Next End Sub what i did in this case to make it work was to...

I have an access database with a few fields that are rtf formatted text, i need to strip out the formatting and then load the tables into an oracle database. i exported the table to a .csv, and then wrote a few modules in vba to remove crlf's and such. i then wrote this procedure to strip out...

best advice so far is: learn how to learn. and relational database knowledge will help tremendously.

the degree is in CS, the name of the program of study i was in was called 'computer systems technology' the main focus was c programming and assembler (8085 and 8086). so yes to be correct my degree is not in c programming, its CS. upon completion i was ready to be turned out into the world as...

i have a degree as a c programmer. i also learned VB and Java while in school, and took one semester of relational database. At work I use sql every day and basically i am an oracle developer because that is what we need most. sql is a data extraction language, not a programming language and is...

thats a very clunky solution, a unique constraint would be the way to go. if your rdbms doesnt support that find another one.

on our test database, whenever a stored procedure or trigger is called from a statement or script, we get a ORA-03113: EOF on communication channel error. in production everything is fine. the two databases are identicle, the only difference is that test runs on a server2003 box and production...

can anyone tell me, or point me to information on how to delete a schema and all of its objects without doing a drop user cascade? i want to keep the user and the tns entries and database links, i just want to get rid of all the tables, packages, indexes, sequences, triggers and so on. i want a...

i do not intend this in a mean spirit whatsoever, just a constructive suggestion. you can not be sloppy about spelling and be a productive programmer, you will spend all your time in a debugger looking for stray semicolons, and wondering why the method you called wont work (because of a typo)...