Hello Reader In this article , we will cover SecureCRT Buttons for Default. ############Setting up Format (format): To convert invalid timestamp value and to check current date.
alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS';
######### Instance Information (inst_info): This SQL outputs the information of instance that is up and running like… Read More
TERADATA DBA TASKS Hello Readers, This page will give you a composite summary of how Teradata DBAs use their time. Let’s first have a look at the high-level summary that lists the main activity categories of the DBAs. As we scroll down further, we shall… Read More
This article focuses on Oracle 18C new feature: Schema Only Account. This allows schemas can be created without a password from Oracle Database 18C. BACKGROUND: Schema is a collection of objects, while DB user is an account to connect to instance. Till Oracle 12C, Oracle… Read More
There is no excerpt because this is a protected post.
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER. In this article we will learn how to schedule RMAN backup jobs through DBMS_SCHEDULER. Before reading this article Please check previous article on DBMS_SCHEDULER. Oracle: Scheduler Jobs in Oracle Database Step 1 : Create the Script That Invokes RMAN Create… Read More
ORACLE ANALYTICAL FUNCTIONS – 1 In this article, we will see how Analytical functions works in Oracle. Analytical Function : Analytical function is used to compute the aggregate values and perform aggregate operations it returns more than value in each group In sql we have… Read More
Introduction to Alibaba Cloud we are conducting demo on below topics on Jan 19th (8:45 AM PST / 10:15 PM IST). Please go through articles before session and share your feedback in comments section.
Introduction to DevOps. we are conducting demo on below topics on Jan 5th and 6th (7:30 AM PST /9:00 PM IST). Please go through articles before session and share your feedback in comments section. AGENDA Session – 1(On 5th Jan 7:30 AM PST /9:00 PM… Read More
MySQL Master-Slave Replication on different AWS instances. In this article i want show how to configure master-slave replication in two different machines. What is Replication ? Replication is the continuous copying of data changes from one database (MASTER) to another database (SLAVE ). The two… Read More
Migrating to AWS. Migrating to AWS sessions – Dec 8th and Dec 9th -10:15 p.m to 11:45 pm IST ( 90 mins on both the days). Migrating to AWS Session -1 Sat, Dec 8, 2018 8:45 AM – 10:45 AM PST Please join my meeting… Read More