Bino
Home
Essays
Notes
Desk
ML
Now
Feed
About
# pl-sql
Count(*) is unsafe
19 Jul 2022
In PLSQL method with count(*) is unsafe.
Read more
Set Define OFF
18 Jul 2022
The `SET DEFINE` command changes the prefix character used to mark substitution variables.
Read more
TYPE Attribute
2 Mar 2022
The %TYPE attribute lets use the datatype of a field, record, nested table, database column, or variable in your own declarations, rather than hardcoding the type names.
Read more
PL/SQL - Implicit Cursors
31 Jan 2022
Cursor Oracle creates a memory area, known as the context area for processing an SQL statements, which contain all the informations needed for procesing the SQL statements.
Read more
Oracle Database XE Installation on Windows
5 Jul 2021
For testing and learning Oracle Database we can start with Oracle Database Express Edition (XE)...
Read more
««
«
1
2
3
»
»»