Sometimes you want to find all views using a specific database table in Oracle. If you are using a small amount of views, this is not an issue, but if you have a huge Oracle database with thousands of views using hundreds of tables you need help from your database. In this case there is ..
Plsql is a nice and simple programming langunage for oracle databases, but sometimes you can’t believe what you see. In the following example you can see the Schrödinger’s cat equivalent of oracle. The result is: null is greater then 10 null is less then 10 In this case null is greater and less then any ..
If you want to rename a big amount of files and you don’t want to to it one by one, you can use the following bash script. This script will list all *.txt files and replace OLD by NEW in the filename. You just have to modify the “*.txt” and the /OLD/NEW/ part to your ..
The zero-width space (ZWSP) is a non-printing character used in computerized typesetting to indicate word boundaries to text processing systems when using scripts that do not use explicit spacing, or after characters (such as the slash) that are not followed by a visible space but after which there may nevertheless be a line break. Normally, ..
If you want to get updates on YouTube Channels into your RSS Feed-Reader, you have to do some easy steps. 1. Open the YouTube channel you want to track in your preferred browser 2. Copy the channel name from the URL into the YouTube Channel Name Converter and click “Get Channel ID” 3. Copy the ..
If you want to create a dump file of a mysql database you can use the mysqldump command which is part of the mysql installation. This great utility can perform a backups of your mysql database, producing a set of SQL statements that can be executed to reproduce the original database table data. Open your ..
If you want to drop a oracle user with the DROP USER statement to remove a database user and optionally remove the user’s objects you can execute ‘drop user @USERNAME cascade’. But if you have a problem to drop the user and you get the error “ORA-01940: cannot DROP a user that is currently logged ..
You can use Properties to configure your java application. The Java platform itself uses System Properties to maintain its own configuration. With the java.lang.System class you can access the Properties object that describes the configuration of the java environment. In System Properties you can find information about the current user, the current version of the ..
In case you have created a branch with a wrong name and pushed your branch to the remote git repository you can follow these steps to change the name of your branch. git branch -m old_branch new_branch # Rename branch locally git push origin :old_branch # Delete the old branch git push –set-upstream origin new_branch ..
Up to API Level 7 you can use android.view.Display.getOrientation() to get the rotation of the screen from its default orientation. But this method was deprecated in API level 8. But now you can use getWindowManager().getDefaultDisplay().getRotation(); The returned value is: Surface.ROTATION_0 (no rotation) Surface.ROTATION_90 Surface.ROTATION_180 Surface.ROTATION_270 If your device has a naturally portrait screen, and the ..