Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
2020/09/07

[Oracle] How to reset sequence value

›
How-To Example PROCEDURE SP_RESET_SEQUENCE AS seq_exists VARCHAR2( 1 ) : = 'T' ; BEGIN SELECT CASE WH...
2020/09/06

[DataGrip] [Database] How to print DBMSUOUTPUT message into console

›
Enable DBMSUOUTPUT in the Output Panel:
2020/09/04

[Oracle] [DataGrip] How to connect to Oracle as SYSDBA

›
Problem When I try to connect to Oracle using sys, I got the following error: How-To Using  sys as sysdba as username is working fine.
2020/09/03

[Oracle] ORA-06592 - CASE not found while executing CASE statement

›
Problem When I try to execute the following function, I got  ORA-06592 - CASE not found while executing CASE statement   error:     FUNCTION...
2020/09/01

[SchemaSpy] How to customize css in SchemaSpy Document ?

›
Requirement If I would like to customize css file in SchemaSpy, how to edit and assign new css file when I re-generate schema document? ...
2020/07/08

[Oracle] Retrieving JSON in Oracle

›
Problem Assume I would like to select a CLOB column with JSON value, it looks like: { "test_no" : "9999" , "y...
2019/11/03

[Sybase] java.lang.ClassCastException: java.sql.Timestamp cannot be cast to com.sybase.jdbc4.jdbc.DateObject

›
Problem In my spring boot project, it will occur the following ClassCastException irregularly: java . lang . ClassCastException : java ....
2019/03/12

[SQL Server] IF EXISTS update else insert

›
Scenario If I would like to implement a SQL statement to fulfill the following requirement, how to do it? How-To You can utilize if e...
2019/03/10

[Database] [Sybase] arithmetic overflow error

›
Problem When I try to sum up a integer column in Sybase, I get  arithmetic overflow error , how to fix it? SELECT SUM (columnname) FRO...
2019/02/14

[Sybase] How to get the difference between two days

›
Problem I have a datetime column in Sybase table, if I would like to calculate the number of second between this column and current datetim...
2019/01/07

[Database] [Sybase] How to implement trim() in Sybase?

›
Problem If I would like to remove unnecessary space from a column value, how to do it in Sybase? Sybase does not have trim function which...
2018/12/14

[SQL Developer] How to configure SQL Developer to connect to Sybase database?

›
Problem How to configure SQL Developer to connect to Sybase database? How-To 1. Download jTDS from  https://sourceforge.net/projects/jt...
2018/12/13

[SQL Developer] How to change language to English in SQL Developer?

›
Problem I downloaded SQL Developer from  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html As I launch...
2018/12/10

[Database] [Sybase] datetime-related example

›
Here has some examples: -- get current timestamp select getdate(); -- cast datetime string to datetime select cast ( '2018-07-13...
2018/11/10

[SchemaSpy] How to generate SQL Server schema document via SchemaSpy

›
Steps 1. Download SchemaSpy jar from http://schemaspy.org/ 2. Downnload and install Graphviz from https://www.graphviz.org/ 3. Download J...
2018/09/08

[PostgreSQL] org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bytea

›
Problem When I try to execute the following select SQL statement: 1 2 3 4 5 select case when (domain_projects <> :domain_p...