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 ..

Read more

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, ..

Read more

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 ..

Read more

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 ..

Read more

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 ..

Read more

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 ..

Read more