Fórum - Oracle

Identity Columns in Oracle Database 12c Release 1 (12.1)

https://oracle-base.com/articles/12c/identity-columns-in-oracle-12cr1

Determining if Two Date Ranges Overlap:

https://www.soliantconsulting.com/blog/determining-if-two-date-ranges-overlap

Oracle felső-N analízis az Oracle 12c verziótól kezdve:

Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1)

https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1

OracleCommand, paraméterek sorrendjével kapcsolatos probléma:

http://www.codeproject.com/Articles/208176/Gotcha-sharp-Using-Named-Parameters-with-Oracl

A lényeg az, hogy ha az OracleCommand BindByName paraméterét true-ra állítjuk, akkor név szerint helyettesíti be a bind paramétereket.

BindByName

This property specifies the binding method in the collection.

Declaration

// C#
public bool BindByName {get; set;}

Property Value

Returns true if the parameters are bound by name; returns false if the parameters are bound by position.

Remarks

Default = false.

http://docs.oracle.com/html/E15167_01/OracleCommandClass.htm#DAFCJDDG

Oracle table shrink space commands:

http://www.dba-oracle.com/t_alter_table_shrink_space_command.htm

Érdekes Oracle cikkek:

http://www.databasejournal.com/article.php/2237601/Jim-Czuprynski.htm

Identifying Host Names and IP Addresses:

http://www.oracle-base.com/articles/misc/identifying-host-names-and-addresses.php

UTL_INADDR package:

http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/u_inaddr.htm

Hasznos bejegyzés:

http://dba-tonyliu.blogspot.hu/2012/06/ora-00607-internal-error-occurred-while.html

Efficient Function Calls From SQL:

http://www.oracle-base.com/articles/misc/efficient-function-calls-from-sql.php

Connecting to Oracle from SQL Server:

http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/

Tech on the Net, Oracle PL/SQL:

http://www.techonthenet.com/oracle/index.php

Flashback New Features and Enhancements in Oracle Database 10g:

http://www.oracle-base.com/articles/10g/flashback-10g.php