Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag oracle Rss

   Items 1 to 20 of 36    Older >>
 

The One 'Security' Feature in Oracle You Probably Shouldn't Use

Oracle offers a number of security-related settings, but one could definitely create more harm than good. David Fitzjarrell looks at which parameter that is, and why.  Read more...
By Additional Articles 2016/03/24 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 4,517 reads

Unique Records In Oracle

Defining unique records in an Oracle table is necessary for employee data, and manufacturing part numbers and user names, to name a couple of examples. David Fitzjarrell looks at the various ways uniqueness can be defined, and which method may not be acceptable to third-party applications.  Read more...
By Additional Articles 2016/02/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 81 reads

Oracle Error When Importing An Interval Partitioned Table

Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. In this post, David Fitzjarrell suggests a work-around until Oracle patches the bug.  Read more...
By Additional Articles 2015/12/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,050 reads

Extended Statistics and Oracle 12c

David Fitzjarrell looks at how and why to use a feature called Automatic Column Group Detection to recognize column dependencies and create extended statistics on recognized groups in Oracle 12.1.0.2.  Read more...
By Additional Articles 2015/11/11 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 2,803 reads

The Oracle PL/SQL Results Cache

Oracle offers a results cache in the database (from 11.2 onwards) and in PL/SQL (again, from 11.2 onwards) which can greatly reduce execution time of repeated statements when insert/update/delete activity is not heavy. The mechanism in PL/SQL, however, may not work as expected with global temporary tables. Using a slightly modified example, Jonathan Lewis looks at what you might see when using this option.  Read more...
By Additional Articles 2015/10/22 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,471 reads

Automatic UNDO in Oracle

Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.  Read more...
By Additional Articles 2015/10/06 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,011 reads

Deciding on a Primary Key in Oracle

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.  Read more...
By Additional Articles 2015/08/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,977 reads

Comparing Oracle and SQL Server Code - Part 1

In this tip, Daniel Calbimonte compares the SQL Server (T-SQL) and Oracle (PL-SQL) extensions of the SQL language. The tip will compare both T-SQL and PL-SQL languages with respect to retrieving data, creating databases, tables, variables, etc.  Read more...
By Additional Articles 2015/06/22 | Source: MSSQLTips.com | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 4,115 reads

Webinar: Oracle Exadata & In-Memory Real-World Performance

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.   Read more...
By Press Release 2015/01/23 | Source: Redgate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 8,133 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,577 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Redgate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,640 reads

SSIS and Oracle All Your Non-options

Why do some things have to be so hard? I have been asking myself that question for the better part of...  Read more...
By Wesley Brown 2012/11/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,490 reads

Temporary Tables in Oracle and SQL Server

Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.  Read more...
By Press Release 2012/10/08 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 5,343 reads

Temporary Tables in Oracle and SQL Server

Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.  Read more...
By Press Release 2012/10/08 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 5,343 reads

Run an Oracle package from SQL Server Integration Services

If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).  Read more...
By Additional Articles 2012/09/18 | Source: MSSQLTips.com | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 2,063 reads

An Overview of Memory Architecture - Oracle for the SQL Server Guy

A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.  Read more...
By jagan_pillai 2012/02/13 | Source: SQLServerCentral.com | Category: oracle
Rating: |  Discuss |   Briefcase | 2,623 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,577 reads
   Items 1 to 20 of 36    Older >>
 
Tags
sql server (5)    
blogs (3)    
powershell (3)    
database weekly (2)    
editorial (2)    
integration services (ssis) (2)    
pl/sql (2)    
webinar (2)    
automatic column group detection (1)    
automatic undo (1)    
bi (1)    
business intelligence (1)    
events (1)    
extended statistics (1)    
free training (1)    
instances (1)    
interval partitioned table (1)    
linked server (1)    
management (1)    
memory management (1)    
migration (1)    
monitoring (1)    
mysql (1)    
primary key (1)    
regular expressions (1)    
security (1)    
sql agent (1)    
sql server 2008 (1)    
statistics (1)    
temporary tables (1)    
t-sql (1)    
unique records (1)