Oracle: Exporting/Importing tables containing CLOB data

Exporting the table using SQLWorkbench

Imagine you have a table images with a character column filename and a clob column image_data

First you need to install the SQL-Workbench. Install does just mean to extract the archive in that case.

The following command exports the table into a textfile. It does also generate the loader file which can be used with sqlldr. The CLOB data is exported as files with the name image_data_0, image_data_1, ... and will be in the same directory. Those files are referenced in the textfile.

Tags:

Adjust Exif time of pictures

Sometimes after you come home from holidays you realize that you forgot to adjust the time of your digital camera. So all pictures might have a wrong date and/or time in the exif header. Fortunately it is pretty easy to fix that with linux:

jhead -ta10:11 *

=> Adds 10 hours and 11 minutes to the exif datetime of all files (that have exif headers) in the current folder

jhead -ta-10:11 *

=> Subtracts 10 hours and 11 minutes from the exif datetime of all files (that have exif headers) in the current folder

Tags:

C# WPF Databinding

Databinding in General

If it doesn't work check:

  • You can just bind to a property. Check that you are not binding on a field

Databinding for ContextMenus in General

ContextMenus in WPF are somehow special. They exist outside the visual tree of the parent control and therefore they are unable to find for example the root element by name. In the following example the binding doesn't work:

C# Disable JavaScript error in WebBrowser control

When using the WebBrowser control and loading a html page it is possible that a message appears that there is a javascript error. This is especially the case if the webpage has been saved from the web and is then displayed on a computer which is offline. Unfortunately there is no property on the browser control which can be used to suppress this kind of error. It is however possible to inject a script tag in the header of an loaded html-file which does catch all errors. Therefore no message will be displayed. You can use the following snippet:

Tags:

Oracle Collection of Useful Stuff

General pitfalls

  • Every statements should be ended with ;
  • Create Procedure statements shall be ended with a ; and a / on the next line like:
    create or replace
    PROCEDURE ExampleProc
    IS
    BEGIN
      NULL;
    END;
    /
  • Identifiers shall have a maximum of 30 characters, otherwise the code using them fails

Output text from within a script

PROMPT "text"

Execute content of another file

@script.sql

Tags:

Mount dm-crypt/LUKS encrypted filesystem and rewrite Grub Bootloader

If Linux (after an update) doesn't boot up anymore it might be necessary to boot into the installation using some distribution which can be booted from a cd/usb-drive (p. x. Ubuntu). The first step would then be to load the encrypted installation and maybe to rewrite the grub bootloader. The following commands can be used to do so:

cryptsetup luksOpen /dev/sda1 dm-0 mount /dev/mapper/dm-0 /mnt/temp
grub-install -- root-directory /dev/sda

Tags:

Repair defect video files

I have a DS1511+ which supports DLNA/UPnP and acts as a server. On the other side I have a blueray player Sony BDP-S480 as receiver. This setup enables me to watch movies from the Diskstation on the television. But sometimes it would start playing a movie but after a while it would just stop. I check some files and found out that they were defect. Here are some commands that can be used to fix them:

ElecFreaks JoyStick Game Kit

There is a Tutorial how to prepare it. In the tutorial there is a link to a library which can be used for the Nokia 5110 LCD display. However for me it did not work. I tried to run the code in the Arduino IDE (v. 1.0.1). It didn't compile.

Tags:

Linux Driver for Canon P-150

If you try to build the driver you might get the following error message:

make[1]: Entering directory `/home/patrick/Desktop/Canon P-150 Linux/sane-backends-1.0.19/doc'
Generating sane.ps...

kpathsea: Running mktexfmt latex.fmt
make[1]: *** [sane.ps] Error 1
make[1]: Leaving directory `/home/patrick/Desktop/Canon P-150 Linux/sane-backends-1.0.19/doc'
make: *** [all-recursive] Error 1

The problem is the documentation (does anyone read it?) so you can just disable building it. Open the make file and change line 40 from

Tags:

Evince PDF Document not supported

Sometimes after an update you might get the error "PDF Document not supported" in Evince. To see what exactly the problem is you should start it up using the command line (p. x. evince '/test.pdf'). In my case I got the following message:

Tags:

Pages

Subscribe to uhlme.ch RSS