Hints and tricks for Oracle and other stuff...

You can create various transformation with SQL. You have to prepare XSLT transformation and use it. 

SQL

# posted by Domen Dolar @ 11:11 PM 0 comments

Executing with ADMIN user

Create ACL and add pages to list:

# posted by Domen Dolar @ 10:14 PM 0 comments

In oracle autonomous database you have some tricks how to read HTTPS pages from database.

First is that you do not have to create wallet with public keys of pages you will call from database.  All mayor trusted issuers have database build in. You use code: utl_http.set_wallet( '' );

 If you would like to acces untrusted sites (database do not know issuers) or HTTP sites you have to use one of providers-proxies that converts trafic to trusted HTTP site.

Do not forget to register URLs in ACL

Some samples:

# posted by Domen Dolar @ 10:05 PM 0 comments

In this sample you can see how easy is to parse data in JSON structure with SQL.

Sample SQL:

# posted by Domen Dolar @ 9:50 PM 0 comments

 In this sample you can see how to create many files from one template file in windows batch script.

Templeta file:

teplate.txt

# posted by Domen Dolar @ 9:30 PM 0 comments