Bookmarks tagged [oracle]
https://blogs.oracle.com/oraclemagazine/bulk-processing-with-bulk-collect-and-forall
In this article, I will cover the two most important of these features: BULK COLLECT and FORALL.
- BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed ...
- 📆 published on: 2012-10-01
- tags: oracle, plsql, performance, optimization
https://blogs.oracle.com/oraclemagazine/on-cursor-for-loops
It’s important to know when not to use cursor FOR loops. Set of recommendations about cursor FOR loops.
- Never use a cursor FOR loop if the loop body executes non-query data manipulation language (DM...
- tags: oracle, plsql
https://blogs.oracle.com/oraclemagazine/working-with-cursors
This article focuses on the most-common ways programmers execute SELECT statements in PL/SQL, namely
- Using the SELECT-INTO statement
- Fetching from an explicit cursor
- Using a cursor FOR loop
- Us...
- 📆 published on: 2013-04-10
- tags: oracle, plsql
https://www.youtube.com/watch?v=7wLFr7ZnKPU&feature=emb_logo
Indexes are one of the most common performance tools available. But how do you create one? And how does it help the database find your data faster?
Watch this video to learn how to create an index a...
https://blogs.oracle.com/sql/how-to-create-and-use-indexes-in-oracle-database
Indexes. They're one of the most powerful and misunderstood aspects of SQL performance. In this post we'll look at the purpose of an index, how to create and choose choose your index type. Then finish...
https://github.com/oracle/node-oracledb/tree/master/examples
select, insert, promises etc.
http://www.oracle.com/technetwork/database/database-technologies/scripting-languages/node_js/index.h...
The node-oracledb driver connects to Oracle Database for fast and functional applications. It is an open source project with Apache 2.0 license. It is maintained by Oracle and is under active developm...
- tags: oracledb, node.js, oracle
source code
http://www.asjava.com/oracle/how-to-convert-milliseconds-to-date-string-in-oracle-sql/
select to_char(to_date('1970-01-01 00','yyyy-mm-dd hh24') +
(1126483200000)/1000/60/60/24 , 'YYYY-MM-DD HH12:MI:SS am') datestr from dual
where 1126483200000 is the time in milliseconds.