oracle.md

July 15, 2021 · View on GitHub

Bookmarks tagged [oracle]

www.codever.land/bookmarks/t/oracle

Bulk Processing with BULK COLLECT and FORALL

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 ...
  • :calendar: published on: 2012-10-01
  • tags: oracle, plsql, performance, optimization

On Cursor FOR Loops | Oracle Magazine

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

Working with Cursors | Oracle Magazine

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...
  • :calendar: published on: 2013-04-10
  • tags: oracle, plsql

How to Create Database Indexes: Databases for Developers: Performance 12min

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...

How to Create and Use Indexes in Oracle Database

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...

node-oracledb/examples at master · oracle/node-oracledb · GitHub

https://github.com/oracle/node-oracledb/tree/master/examples

select, insert, promises etc.

Oracle Node.js Developer Center

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...

How to convert milliseconds to date string in Oracle SQL

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.