Oracle has no databases but schemas and users (that are essentially the same thing).
The schema/user in Oracle can be considered as an equivalent to a “database” concept in MySQL, PostgreSQL or MS SQL.
In this note i will show how to list all Oracle “databases” (equivalent to SHOW DATABASES command in MySQL), get the current schema name and how to switch to a different schemas using the command-line interface of SQL*Plus. (more…)
Some scripts or commands executed in Windows PowerShell or CMD may ask interactive questions that have to be responded with “Yes” or “No” answers.
To know how to answer these interactive questions automatically is very handy for different automations.
In this note i will show how to respond “Yes” or “No” to prompts in Windows PowerShell & CMD automatically. (more…)
For better readability it is convenient to split long commands over multiple lines.
In Windows PowerShell a multi-line command can be created from a long command by splitting it using the backquote character.
In this note i will show an example of how to split a long command over multiple lines in PowerShell. (more…)
The Get-History command in PowerShell lists only the commands entered during the current session, unlike the history command in Linux or MacOS, that returns the full commands history across all sessions.
To get the history of all the previously executed commands in PowerShell it is required to locate the file where these commands are stored.
In this note I’ll show how to locate the history file and get the history of all the previously executed commands in PowerShell. (more…)
Tags in Git are used to label specific commits (to mark releases, for example).
In this note i will show how to create a Git tag and push it remote repository using the git tag and git push commands.
I will also show how to find out the most recent tag name and how many commits ago it has been created. (more…)
Tags in Git are used to label specific commits (to mark releases, for example).
Once created locally, Git tags can be pushed to a remote repository.
In this note i will show how to delete local Git tags using a git tag --delete command and how to remove Git tags from a remote repository. (more…)
Tags in Git are used to label specific commits (to mark releases, for example).
Each tag points directly to a specific commit in the Git history.
In this note i will show how to checkout a tag in Git and how to create a new branch from it. (more…)
If you use a self-signed SSL certificate or a certificate that has been issued by unknown CA (certificate authority), Java client will raise an exception:
SunCertPathBuilderException: unable to find valid certification path to requested target
To resolve this issue the self-signed certificate or the CA certificate should be imported into Java keystore using a keytool command.
In this note i will show how to import a certificate into Java keystore using the keytool command in a non-interactive way.
I will also show an example of how to import a CA certificate into Java keystore cacerts. (more…)
A kubectl exec command serves for executing commands in Docker containers running inside Kubernetes Pods.
With this command it is also possible to get an interactive shell to a Docker container running inside a Pod.
In this post i will show how to login to a Pod and execute an interactive shell session using the kubectl exec command. (more…)
Tags in a Git repository can be listed using the git tag command.
Before listing all the tags it is required to ensure that the latest tag list from the remote repository has been fetched.
On the other hand, even without pulling or fetching, it is possible to get a list of tags on the remote Git repository.
In this note i will show how to list all the tags in a Git repository. (more…)