10 Dec 08 Generate XML – DBMS_XMLGEN
On my way to my solution store just found this nice to use, old and easy feature.
Possibilities endless, usage typically very easy.
I used the following to generate XML from sqlplus:
select dbms_xmlgen.getxml('select * from user') from dual;
Output:
< ROWSET >
< ROW >
< TNAME >Employee< / TNAME >
< TABTYPE > TABLE < / TABTYPE >
< / ROW >
< / ROWSET >
Tags: DBMS_XMLGEN, HOWTO, Programming, Software, Software Development, sql, tips, utils
12 Nov 08 Doing the Locale – Danmark
The following illustrates how to get the Number format working with a danish locale.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | import java.text.NumberFormat; import java.util.Currency; import java.util.Locale; public class TestLocale { public static void main(String args[]){ // Create a Locale for Danmark Locale DANMARK = new Locale("da","DK"); // get the currency instance for this locale. Currency krone = Currency.getInstance(DANMARK); // Get a Number format for the locale. NumberFormat krFormat = NumberFormat.getCurrencyInstance(DANMARK); // A symbol for the currency String symbol = krFormat.getCurrency().getSymbol(); // A double amount double amount = 10000.25; // print it out after formatting. System.out.println(krFormat.format(amount)); } } |
Tags: HOWTO, internationalization, Java, locale, Programming, Software, Software Development, tips, utils
31 Oct 08 How to read a file from the JAR?
Someone just asked me this question today. And I thought might as well put it down for info.
1 2 3 4 | public TestReadFileFromJar() throws FileNotFoundException, IOException { InputStream is = getClass().getResource("txtData/states.properties"); read(is); } |
In the case above txtData is placed in the jar on the root. Remmember to add the path with the /
Tags: HOWTO, jar, Java, Programming, Software, Software Development, tips, utils
My Web Profile
