In Oracle you can execute hierarchical queries using some cool operators–CONNECT BY PRIOR, START WITH and
the pseudocolumn SYS_CONNECT_BY_PATH, namely. However, using your fantasy you can exploit these operators
to put in a single row–with each item separated by the next through a separator, such as a comma–what you have
in multiple rows. For example if you have more than one telephone number in different rows and you want to put them
in a single comma-separated row you could use a query similar to the following:
When you create a table, by default, the number of bytes used to represent a character in a VARCHAR2 type is 1,
irrespective of the characterset of the DB. This may be fine if the characterset is such that it uses just one byte per
character. However, if the characterset of the DB is such that there might take more than one byte to represent a
character (for example for characterset = AL32UTF8) you might run into troubles, such as the error:
ORA-01401: inserted value too large for column. However you can specify, at creation time, that the size of
characters is expressed in CHARs instead of bytes. For example:
UltraEdit-32 (UE for short from now on) is a wonderful text editor. You can use it as a simple text editor or to write programs using your favorite languages. Besides other features, UE offers syntax highlighting for the most common programming languages out there. UE recognizes the type of file by looking at its extension. However, sometimes, you might want to use one syntax highlighting for an extension that is not mapped in UE. For example if you use ProC, which file extension is .pc, you may want UE to default to the C highlighting for ProC files. You can do that by editing the UE’s wordfile.txt file. UE uses this file to understand how to highlight words. To edit this file, from the UE menu go to: Advanced -> Configuration -> Editor Display -> Syntax Highlighting. From this window you can open wordfile.txt by clicking on the Open button in the Full path name word list section. In this file you’ll find all the languages that UE highlight. Each language start with /Ln, where n is a number. At the end of the row where /Ln is you can see “File Extensions = extensions”. Just append the extension you need to highlight for that language and save the file. Restart UE and open the file with the extension you just mapped. Enjoy the result! :-)