1.7K
Followers
113
Posts
andrespadini.com.br
A opção FORCE LOGGING pode ser definida no nível do banco de dados ou tablespace. Esse parâmetro força com que todas as alterações gravem no redo log…
msaruj.hashnode.dev
There are four types of SQL statements. They are - DML(Data Manipulation Language) Statement. DDL(Data Definition Language) Statement. DCL(Data Control Language) Statement. TCL(Transaction Control Language) Statement. 1. DML(5 Types) Sel…
lmoreaux.hashnode.dev
Popup LOV item type One of my favorite item type in APEX is the popup LOV, users love it because of the ability to search even across multiple columns since version 19.2. It supports single and multiple value selection and can be displayed …
0xweathered.hashnode.dev
nah, using sample schema is way easier actually, lets go to HR lets say i want to make a stripped down table identical to the EMPLOYEES table, paritioned, by DEPARTMENT_ID column. so if i am using the HR.EMPLOYEES table, SELECT COUNT(DIST…
continuing from sql | how NOT to avoid multiple identical subqueries in the SELECT clause these won't work if your db is older than 12c. if it is lower, i guess the how NOT to is the how to, not an expert don't quote me on that. and no i d…
