Sql Code Samples

nvl (oracle) equivalent in postgres

sonia shaik | 4 years, 9 months

COALESCE(value [, ...])
The COALESCE function accepts an unlimited number of arguments. 
It return

sql postgres oracle

decode (oracle) equivale in postgres

sonia shaik | 4 years, 9 months

Simple Case:
case search-expression
    WHEN expression [, expression [ ... ]] THEN

sql postgres oracle

Adding a new auto increment column to a table in postgres

kishore_kumar | 4 years, 7 months

-- New versions of postgres
-- adding as primary key

sql postgres postgresql

Drop table in Sql

sonia shaik | 4 years, 9 months

Drop table Table_name;

sql mysql

How to dump a database in postgresql

Reshma | 4 years

sudo -i -u postgres

psql

dump postgresql sql

Move a table to other schema in Postgres

kishore_kumar | 5 years, 1 month

ALTER TABLE table_name SET SCHEMA new_schema

sql postgresql

PostgreSQL CONCAT_WS function

Reshma | 4 years, 8 months

SELECT
   concat_ws (column1,column2) AS new_column_name
FROM

sql concat_ws

how to print star using sql

sonia shaik | 4 years, 9 months

DECLARE @var int               
SELECT @var = 5 
WHILE @var >0

output: * * * * * * * * * * * * * * * * * * * * *

sql printing pattern my sql