Subscribe to The Linking To My Other Blog Didn't Work, So This Here Is The Result        RSS Feed
-----

I Give Up

Icon Leave Comment
Earlier I decided to review my PLSQL skills because I need to transfer copious amounts of data from the database to SQL scripts. This could be done with executing a query in SQLDeveloper, then choosing all results then picking export as inserts. The problem is this task is too tedious. Create and execute query, select all data, export as inserts, then saving the file. The saving the file part probably broke the straw. Why can't the next save dialog open up on my last save point?

So I created something in PLSQL, and my eyes were first set on utilizing file handling. Well, everything went fine, from getting the data needed and transforming them to the proper insert outputs, the only thing left is saving to the file. That's where I hit my first wall. It either says I'm doing an illegal operation or file does not exist.

So I tried looking to setting up a dummy table to have the content of files, and I chanced upon the CLOB variable. I hit another wall! It's an error called numeric or character blah blah blah that I can't fix.

So by then, tears are rolling down on my eyes, I punched the monitor and then closed my eyes for a bit.*

My own mind closed the possibility of me doing it in Java. Now I'm downloading Java 7 and will probably finish this thing in no time.

Screw you, self mind!

*Probably not true. Probably.

0 Comments On This Entry

 

Trackbacks for this entry [ Trackback URL ]

There are no Trackbacks for this entry

December 2014

S M T W T F S
 123456
78910111213
14151617181920
212223 24 252627
28293031   

Tags

Recent Entries

Recent Comments

Search My Blog

0 user(s) viewing

0 Guests
0 member(s)
0 anonymous member(s)

Categories