MySQL 2 years ago Count words and phrases in a column MySQL/SQL In this post: MySQL Count words in a column per row MySQL Count total number of words in a column Explanation SQL standard version and
Oracle 2 years ago Oracle count null and not null values in column In this article we will post two ways of counting null and not null values per table(s) by union or single query with Oracle
MySQL 2 years ago MySQL Equivalent of Oracle's SQL loader In this post: MySQL SQL loader equivalent - LOAD DATA INFILE MySQL SQL load csv file MySQL load by tools - HeidiSQL More info and
MySQL 2 years ago SQL union and where clause Sometimes there is a need of filtering result of a union of several tables. This is fairly easy task that could vary between different RDBMS
SQL 2 years ago Group by and string concatenation in Oracle and MySQL It's a common operation in DB to have a need of grouping and concatenating several columns in the output result of the query. For example
SQL 2 years ago Nice article about 10 SQL optimisations: MySQL, Oracle, SQL Server, DB2, PostgreSQL Recently I found a very nice article explaining in great detail how you can optimize SQL and Databases. It's including the biggest DB engines: Oracle
Oracle 3 years ago Oracle refresh statistics on owner/table Check is it needed update of statistics If you want to check for a single table are statistic refreshed you can also use SQL developer:
SQL 3 years ago Oracle, MySQL - select max and return multiple values A common problems in SQL are to find the data for the row with some max value in a column per some group identifier. Another
SQL 3 years ago Oracle indexes - create, rebuild, select, drop Select all indexes by status Check indexes by status by two queries from metadata of Oracle. Depending on your needs and rights you can use
SQL 3 years ago SQL concatenate examples Concatenation basics concatenation functions: Oracle - concat MySQL - concat MSSQL - concat PostgreeSQL - concat, concat_ws(avoiding null) concatenation symbol is Oracle -
