In
General, DBA's open pluggable database or PDB either in Read Write Mode or
Read-only, what if the database behaves in read-only, and read-write mode based on
the connected user. One such feature is introduced in Oracle 23c. As we know
there...
Oracle Database has great functionality that converts any number to its word format, suppose number "2 "you want to write it as "two", you can do it using Oracle database. you may not need it for single double, triple, or quadruple numbers...
As we have discussed features and release details of Oracle 23c, in the previous article,
now we are going to install and make our hands dirty with Oracle database 23c on a virtual machine, Oracle has provided 23c in the form of a Virtual...
In this article, we will discuss the installation of the Oracle virtual box. Use the below link to download the Oracle virtual box https://www.oracle.com/virtualization/technologies/vm/downloads/virtualbox-downloads.htmlOnce the...
The hottest topic of the week is the release of Oracle database version 23c, developer release. This version 23c is ready for Database Administrators and developers to test new features and functionalities.DBAs and Developers can plan future...
Understanding
the execution of any query in the Oracle database needs an understanding of
different components of the Oracle database such as SGA, Processes, datafiles, memory, etc.Here, we will discuss the execution of a simple
select...
There are
a total 5 default system-defined roles in snowflake, those are
ACCOUNTADMIN
SYSADMIN
SECURITYADMIN
USERADMIN
PUBLIC
Below is
a graphical hierarchy of these roles in snowflakeACCOUNTADMIN is a top-level role
in snowflake architecture,...
As a PostgreSQL database administrator, you may come across situations
where you want to check the size of the full database, here is a quick solution
for the same
Here is my PostgreSQL cluster details, there is one database called
technodb,...
In snowflake, we use the "show databases"
command to see details about default and created databases, this command shows a
lot of details about databases, what if we just need the names of the database
not whole details about them, after digging out I found this
"databases" is table present in INFORMATION_SCHEMA schema, so we can
query the details...
In almost all databases features, we have a spool file option, we will discuss the same spool option in snowflakeAssume, you need to execute the script which is a little long and the output can not be captured in a single screenshot, so we can make use of spooling the output in the log file. once you are ready to execute the script, browse to...