I found very cool font face generator. It’s useful when you need custom font on all browsers. Check it!
Browsing Posts tagged Programování
There are several useful queries for Oracle DB: select TABLE_NAME from SYS.ALL_TABLES where OWNER=’schema’ – select all tables for given schema select USERNAME from SYS.ALL_USERS order by USERNAME – select all schemas select VIEW_NAME from SYS.ALL_VIEWS where OWNER=’schema’ order by VIEW_NAME – select all views for given schema select OBJECT_NAME, OWNER from SYS.ALL_OBJECTS where UPPER(OBJECT_TYPE) [...]
Sometimes output from Sqlplus is a little bit confusing. Fortunately there are ways how to improve that. column column_name format a20 – make the column column_name smaller (20 characters), only for strings and dates column column_name format 99990 – make the column column_name smaller (5 digits), for numbers set pagesize 5000 – set the bigger [...]
I needed to save output from SQL query into file. I found this solution: SQL>SPOOL /tmp/data.dat SQL>select * from table; SQL>SPOOL OFF
Potřeboval jsem nahradit řetězec obsahující speciální znak $ jiným řetězcem v souboru. Pracoval jsem na UNIXu s KSH. Nakonec jsem to vyřešil následovně: perl -p -i -e ‘s{string\$12}{string2}i’ soubor.txt
