Friday, 29 June 2018

How to run a SQL query/statement in a task?

›
You are able to run a SQL query/statement with "echo" command by  shell module for the ansible task. # an example task for sql ...

benefit of "gather_facts: no" setting

›
If you do not need any facts for your variables, you can run your playbook more fast via gather_facts setting. For this, just add followi...
Friday, 18 May 2018

"database "example" is being accessed by other users" solution

›
Action postgres=# drop database example ; Error ERROR:  database " example " is being accessed by other users DETAIL:  There ...
Sunday, 6 May 2018

How to backup database in XE?

›
It is very simple to backup your database in Oracle XE with already prepared .bat file quickly. Steps; Press Windows Key -> Type ...
Friday, 27 April 2018

e.g. truncate table cascade

›
Preparation of Test Data test=#  create table employees (id integer, name varchar, department_id integer); test=#  create table departm...
Thursday, 26 April 2018

e.g. fetching JSON data

›
Preparation of Test Data test=#  create table  T_JSON_DATA  (id INTEGER, body JSON); test=# insert into T_JSON_DATA values (1, '{ ...
Wednesday, 25 April 2018

ORA-02292 solution

›
Preparation -- Insert test data into DEPARTMENT and EMPLOYEES tables. SQL> INSERT INTO DEPARTMENTS VALUES ( 280 ,'New Department...
Thursday, 19 April 2018

e.g. count and distinct aggregate functions

›
examples; count (1) - count(*) - count(column_name) - count( distinct (column_name)) e.g. count aggregate function SQL> SELECT     ...
Wednesday, 11 April 2018

ORA-02449 solution

›
Preparation SQL> CREATE TABLESPACE EXAMPLE_TS DATAFILE   'C:\ORACLEXE_XE\APP\ORACLE\ORADATA\XE\example_01.dbf' SIZE 512K REUSE...

ORA-01549 solution

›
Preparation SQL> CREATE TABLESPACE EXAMPLE_TS DATAFILE   'C:\ORACLE_XE\APP\ORACLE\ORADATA\XE\example_01.dbf' SIZE 512K REUSE ...
Monday, 9 April 2018

e.g. pivot clause

›
Preparation  * Define column names for pivot table SQL> SELECT LISTAGG (           '''' || JOB_ID || '''...
Friday, 6 April 2018

How to use SPOOL command in Oracle?

›
WINDOWS e.g. SQL>  sqlplus / as sysdba; SQL> SET LINESIZE 200; SET PAGESIZE 100; -- define a output file for writing SPOOL ...
Tuesday, 3 April 2018

What are pencil hardness grading scales?

›
2H -> H -> F -> HB -> B -> 2B H means Hard (hard-tipped) B means Bold  (soft-tipped) F means Fine Info: from left to r...
Friday, 30 March 2018

What is implicit commit?

›
After every DDL operation, implicit commit occurs such as while defining a new table. e.g. CREATE TABLE HR.EXAMPLE(ABC char(1)); Also w...

blob vs bfile data types

›
BLOB (binary large objects) stores unstructured binary large objects. It is often used for graphic images, video clips, and sounds. The BLO...

How to do CTAS in Oracle?

›
CTAS stands for Create Table As Select e.g. SQL> CREATE TABLE HR.EMPLOYEES_NEW AS     SELECT * FROM HR.EMPLOYEES; -> By defau...

NULLS LAST keyword usage

›
-> HR.EMPLOYEES will be test table. SQL>  DESC HR.EMPLOYEES; e.g. To populate all data SQL>  SELECT * FROM HR.EMPLOYEES; T...

ORA-01495 solution

›
Action SQL> ANALYZE TABLE HR.EMPLOYEES LIST CHAINED ROWS INTO CHAINED_ROWS ; Error ORA-01495 : specified chain row table not found ...
Friday, 23 March 2018

ORA-02270 solution

›
Preparation SQL> create table A (id number, soid number); SQL> create table B (id number); Action SQL>  alter table A add...
Friday, 16 March 2018

ORA-00959 solution

›
Action SQL>  CREATE TABLE HR.EXAMPLE(ABC char(1)); Error ORA-00959: tablespace '_$deleted$40$0' does not exist Reason Def...