Category: Database

The server time zone value unknown is unrecognized or represents more than one time zone

The server time zone value ‘unknown’ is unrecognized or represents more than one time zone SQL Exception while inserting data into table: The server time zone value ‘unknown’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more […]

The new driver class is com.mysql.cj.jdbc.Driver deprecated

Loading class `com.mysql.jdbc.Driver’. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.   com.mysql.jdbc.Driver, the MySQL driver deprecated, you can use new MySQL driver i.e com.mysql.cj.jdbc.Driver   com.mysql.cj.jdbc.Driver is the new drive class you can use old […]

How to alter Cassandra Keyspace

How to alter Cassandra Keyspace In this article, I am going to show How to alter Cassandra Keyspace. ALTER KEYSPACE can be used to alter properties such as the number of replicas and the durable_writes of a KeySpace Syntax ALTER KEYSPACE <identifier> WITH <properties> ALTER KEYSPACE “KeySpace Name” WITH replication = {‘class’: ‘Strategy name’, ‘replication_factor’ […]

How to create Cassandra Keyspace

How to create Cassandra Keyspace In this article, I am going to show How to create Cassandra Keyspace. A keyspace in Cassandra is a namespace that defines data replication on nodes. A cluster contains one keyspace per node. Syntax CREATE KEYSPACE <identifier> WITH <properties> CREATE KEYSPACE “KeySpace Name” WITH replication = {‘class’: ‘Strategy name’, ‘replication_factor’ : […]

Apache Cassandra Database Installation in Windows

Apache Cassandra Database Installation in Windows In this article, I am going to show how to install Apache Cassandra Database in Windows. Apache Cassandra is a highly scalable, high-performance distributed database designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. It is a type […]

Oracle query to find alphanumeric data in column

Sample Data SELECT ‘3874’ col FROM DUAL UNION ALL SELECT ’74’ col FROM DUAL UNION ALL SELECT ‘123’ col FROM DUAL UNION ALL SELECT ’22FRE’ col FROM DUAL UNION ALL SELECT ‘ABCD’ col FROM DUAL UNION ALL SELECT ‘AB33FRE’ col FROM DUAL Query Syntax SELECT COLUMN_NAME FROM TABLE_NAME WHERE REGEXP_LIKE(COLUMN_NAME,'[[:alpha:]]’) AND REGEXP_INSTR(COLUMN_NAME,'[0-9]’)>0; Output COLUMN_NAME 22FRE […]

Start or Stop Oracle XE in Linux

Login to Linux Server as a Root user $sudo su – Root <Start Oracle XE Service> $service oracle-xe start <Stop Oracle XE service> $service oracle-xe stop Ramesh Kunamaneni (RK)Greetings!! This is Ramesh Kunamaneni (RK), I have a decade experience in IT and worked for various MNCs. I am happy to share my knowledge in this […]

How to get the Tablespace details in Oracle

oracle

This article helps you to get more information about Tablespace in Oracle along with a few commands which helps in your day to day activity. How to get the list of available Tablespaces SQL> select tablespace_name, sum(bytes)/power(1024,2), sum(maxbytes)/power(1024,2), AUTOEXTENSIBLE from dba_data_files group by tablespace_name, AUTOEXTENSIBLE; This list down all the tablespaces that are available in […]

How to Disable and Enable triggers in oracle

oracle

In this post, we are discussing on how to enable, disable and drop triggers in oracle.   Enable ONE Trigger in a table Syntax ALTER TRIGGER <trigger-name> ENABLE; Example ALTER TRIGGER NarayanaTutorial_Trigger ENABLE;   Enable ALL Triggers in a table Syntax ALTER TABLE <table-name> ENABLE ALL TRIGGERS; Example ALTER TABLE NarayanaTutorial_TABLE ENABLE ALL TRIGGERS;     Disable […]