Posted by jpluimers on 2016/09/27
I recently learned that you can do cross database queries in Oracle using database links.
You need to prefix your objects with the right schema/owner (for instance dbo.) and suffix with an @ sign followed by the database link name.
This query finds all configured database links:
select * from all_db_links;
–jeroen
via: Ask Tom “database link”.
Posted in Database Development, Development, OracleDB | Leave a Comment »
Posted by jpluimers on 2016/09/22
For my own reference as RegEx is a write-only language:
Search for pipes means just back-slash escaping them:
grep "\|S\|" products.txt > s-rated-products.txt
Search for optional charactes (in this case searching for both the singular and plural form of a word) can be done by grouping the optional part in parentheses:
grep -i "Movie(s)?" products.txt > movie-products.txt
Search for either OR:
grep -E "foo|bar" products.txt > foo-or-bar-products.txt
egrep "foo|bar" products.txt > foo-or-bar-products.txt
Note that the Borland grep does not support the OR syntax, but egrep does.
–jeroen
via:
Posted in Development, RegEx, Software Development | Leave a Comment »
Posted by jpluimers on 2016/09/21
These NirSoft tools helped me finding out about some crashes that never made it to the event log:
At first I thought my own software development caused them, but In the end they were caused by buggy video drivers.
–jeroen
Posted in Development, Power User, Software Development, Windows | Leave a Comment »
Posted by jpluimers on 2016/09/21
It’s been in the System.Array class forever, but remarkably few people do know that it can throw you a NotSupportedException (for instance when calling Add, Insert, Remove, etc).
It does because it implements IList, but not all methods implemented from IList are valid.
And it also indicates that, as the IList Properties allows for IsFixedSize to return false.
A similar case is there for IsReadOnly: then you cannot even modify the values.
Ever since I started teaching .NET/C# classes almost 15 years ago, I warned:
beware when you use IList as not everybody implements all methods.
–jeroen
via:
Posted in .NET, .NET 1.x, .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, .NET 4.5, C#, C# 1.0, C# 2.0, C# 3.0, C# 4.0, C# 5.0, C# 6 (Roslyn), Development, Software Development | Leave a Comment »