How to start and stop PostgreSQL database in windows In this post, going to explaining how to start and stop the PostgreSQL database in windows. PostgreSQL starts and stop is different from the environment to the environment. Open Windows Services Press Windows+R, and type the services.msc and then you can find the PostgreSQL server service […]
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 […]
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 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 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 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 […]
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 […]
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 […]
Here I can show you how to access MSSQL server database from SQL developer tool. Generally as you know we can access oracle database directly without any adding or modifying in SQL Developer. But we can’t access MSSQL database directly because Oracle didn’t provide MSSQL server database drivers (JDBC jar) along with SQL developer tool. […]
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 […]
COPYRIGHTS © 2019 - 2023 Narayana Tutorial. ALL RIGHTS RESERVED terms of service | privacy policy | returns and refund policy
