2 Resources for

sql*plus 10g

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Learn about SQL*Plus 10g's new features: DBALearn 10g new feature of SQL PLus10g New featuresLena,I'm not sure whether you are asking a question or not but here goes...If you need this for your job as DBA or developer then best bet is to get onto a course (if you/your employer is willing and able to afford...; Tags: Learn; Discussion threads 2006-05-02
Learn about SQL*Plus 10g's new features: Get a rundown of the new features in the Oracle SQL*Plus product. For instance, one useful feature is the DBMS_OUTPUT enhancement, which helps you debug functions used in SELECT statements. The Oracle SQL*Plus product has introduced some new features that have long been missing from this utility ...; Tags: Oracle Corp., SQL, Databases, Scott Stephens, Programming languages, Oracle SQL*Plus product, Oracle Flashback Drop feature, SQL*Plus 10g, Oracle Tips Newsletter, Default Option, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-07-28

Additional Resources

Oracle Database 10g: Top Features for DBAs - Part 1: SQL and PL/SQL Features: Transparent Data Encryption and XQuery support are the two major new SQL-related features in Oracle Database 10g Release 2, but the list doesn't end there. The paper presents SQL and PL/SQL features of Oracle Database 10g such as enhanced COMMIT, error-logging clause, WRAP package, conditional compilation, and unlimited DBMS Output.; Tags: Oracle Corp., PL/SQL, SQL, Oracle Database, Oracle Database 10g, Programming Languages, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management; White papers
The Self-Managing Database: Guided Application & SQL Tuning With Oracle Database 10g Release 2: In Oracle Database 10g, the SQL tuning process has been automated by introducing a new manageability feature called the Automatic SQL Tuning. It is designed to work equally well for OLTP and Data Warehouse type applications. This paper introduces a new persistent tuning object called the SQL Tuning Set STS,...; Tags: Oracle Corp., SQL, Oracle Database, Oracle Database 10g, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2006-06-01
How to Import SQL Server 2000 data to Oracle 10g: I'm trying to import data from a SQL Server 2000 Data to Oracle. I have Oracle 10g and TOAD installed, but not SQL Server 2000, as I only have the SQL Server backup and .mdf file and log file. How can I read/view the contents of the backup or .mdf...; Tags: Databases, Enterprise software, Application servers, terry.bobo@..., Microsoft SQL Server, Microsoft SQL Server 2000, Oracle Corp., Oracle Application Server 10g; Discussion threads 2007-08-12

Build a PL/SQL Web Service: This article focuses strictly on PL/SQL database web services. Oracle Database 10g web services, by definition, expose functionality in the database, they allow developer to take advantage of their development investment in PL/SQL and SQL while consuming external web services from within the database. In this article, reader will be...; Tags: Oracle Corp., Web Service, PL/SQL, Web Services, Programming Languages, Databases, Enterprise Software, Software, Software Development, Software/Web Development, Data Management; White papers
Running Oracle 11i, 10g and developer 10g on same PC: Hi,I have installed oracle 11i on my desktop, which is working great.I also installed oracle 10g, which is ok, except, when I try to log into the 10g EM, it gives an error code, ( I think it is 12560, please Iam soory, I should be more precise, I am...; Tags: Databases, PC, Lorgorsor@..., Oracle Corp., Oracle11i; Discussion threads 2007-10-22
Oracle JDeveloper for Database Developers and DBAs: Oracle JDeveloper 10g is an Integrated Development Environment providing end-to-end support for building, testing, and deploying J2EE applications, Web services, and PL/SQL. JDeveloper 10g is written entirely in Java, and, as such, is a multi-platform development environment. Currently, JDeveloper is tested and supported on Windows, Linux, Mac OS/X, Solaris, and...; Tags: Developer, Database, Oracle Corp., Oracle JDeveloper 10g, Oracle JDeveloper, Java Development Tools, Enterprise Software, Development Tools, Software Development, Software/Web Development, Software; White papers 2005-01-01
SQL Apply Best Practices: Oracle Data Guard 10g Release 2: With Oracle Data Guard SQL Apply in Oracle Database 10g, Oracle is addressing the requirements of the business community for an online disaster-recovery solution that also provides a means to offload reporting and decision support operations from the primary database. A logical standby database contains the same logical information as...; Tags: Oracle Corp., SQL, Best Practice, Standby Database, Databases, Programming Languages, Data Mining, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware; White papers 2006-06-01
Technical Comparison of Oracle Database 10g Vs. SQL Server 2005: Focus on Performance: This paper summarizes the main technical differences between Oracle Database 10g Release 2, the latest version of Oracle Database, and SQL Server 2005, the new release of Microsoft's SQL Server product, focusing on the major techniques commonly used to ensure good performance and scalability in modern, enterprise-class, relational database systems:...; Tags: Oracle Corp., Performance, Microsoft SQL Server, Microsoft SQL Server 2005, Oracle Database, Oracle Database 10g, Databases, Enterprise Software, Software, Data Management; White papers 2005-10-01
SQL Tools Make Fast Work: The purpose of any interactive SQL tool is to let the user enter SQL statements and get results back. The term SQL statements includes PL/SQL blocks and now, in Oracle Database 10g Release 2, XML queries. SQL*Plus has long been the tool of choice for executing ad hoc SQL statements,...; Tags: Oracle Corp., SQL, Tool, SQL*Plus, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2006-01-01
Use DBMS_RANDOM to generate text and date values: Example Requires Oracle 10gImproved functionality and streamlined useage in 10g version. A few more calisthenics required to get dates and strings out of 9i DBMS_RANDOM package because DBMS_RANDOM.RANDOM function only returns an 8 digit integer.SQL> -- Initialize random number generator with at least a 5 digit numberSQL> BEGIN ...; Tags: Programming languages, Databases, SQL, DBMS_RANDOM.RANDOM; Discussion threads 2006-05-10
Technical Comparison of Oracle Database 10g Versus SQL Server 2005: Focus on Information Integration: This paper examines the information integration features of Oracle Database 10g, and compares them with the features of SQL Server 2005. It specifically looks at replication and message queuing. SQL Server 2005 provides incremental improvements to their replication, distributed operations, and heterogeneous access. It also introduces an entirely new message...; Tags: Oracle Corp., Microsoft SQL Server, Information Integration, Microsoft SQL Server 2005, Oracle Database, Oracle Database 10g, Enterprise Software, Databases, Software, Data Management; White papers 2005-11-01
Logical Standby Unleashed: This paper provides an in-depth review of Data Guard SQL Apply Logical standby database utilizing significant new features in Oracle Database 10g. This paper presents a strategy where SQL Apply is a significant element of a Business Continuity strategy. This session will share best practices and user experience deploying SQL...; Tags: Oracle Corp., SQL, Databases, Programming Languages, Service Level Management, Strategy, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, It Operations, It service Management, Management; White papers 2005-09-01
SQL Apply Rolling Upgrade Best Practices: Oracle Database 10g Release 2: Oracle Maximum Availability Architecture MAA is the Oracle best practices blueprint for implementing Oracle high-availability technologies. The goal of this paper is to provide best practices for using SQL Apply Rolling Upgrades to execute database upgrades with minimal downtime. Starting with Oracle Database 10g Release 1 (10.1.0.3 and onward), Data...; Tags: Oracle Corp., SQL, Best Practice, Oracle Database, Oracle Database 10g, Oracle Maximum Availability Architecture, Databases, Enterprise Software, Software, Data Management; White papers 2007-02-01
Sort Performance Improvements in Oracle Database 10g Release 2: Oracle Database 10g Release 2 introduces a new, more efficient sort algorithm that improves the performance of database sorts significantly. Because sorting is an internal database operation invoked by SQL operations, every application will transparently take advantage of the new sort algorithm when migrated to Oracle Database 10g Release 2.; Tags: Oracle Corp., Performance, Oracle Database, Oracle Database 10g, Oracle Database 10g Release 2, Databases, Engineering, Enterprise Software, Storage, Software, Data Management, Hardware; White papers 2005-06-01
Virtualize Your Oracle Database With Web Services: Oracle Database 10g can function in two Web services modes: as a Web services consumer external Web services are invoked from within the database or Web services provider (clients invoke database operations through the internet/intranet, thereby "Virtualizing" those operations). Oracle Database 10g supports both modes - in consumer mode generating...; Tags: Web, Oracle Corp., Web Service, Oracle Database, Oracle Database 10g, Web Services, Channel Management, Databases, Storage, Enterprise Software, Software, Marketing, Data Management, Hardware; White papers 2005-11-01
Make the most of Oracle Database 10g with these insider solutions: This sample chapter, taken from Oracle Database 10g Insider Solutions, examines some of the new features of Oracle Database 10g. Many of the new features in Oracle Database 10g add new functionality, while others remove minor limitations that used to exist before or change the way a...; Tags: Chapter, Oracle Corp., Oracle Database, Oracle Database 10g, Databases, Enterprise Software, Software, Data Management; Book chapters 2006-03-02
D-reflection (exe): D-reflection v3.0 is a tool to convert MS SQL 2005 database schema to Oracle 9i/10g or/and to convert Oracle 9i/10g database schema to MS SQL 2005. The tool has build-in rules to convert data schemas. In case user wants to setup their own conversion rules it can be done in...; Tags: Schema, Tool, Storage, Databases, Hardware, Enterprise Software, Software, Data Management; Software downloads 2008-01-21
Commanding ASM: Oracle Database 10g Release 1 introduced Automatic Storage Management ASM, a new framework for managing Oracle database files. ASM provided a foundation for highly efficient storage management with kernelized asynchronous I/O, direct I/O, redundancy, striping, and an easy way to manage storage. ASM includes volume management functionality similar to that...; Tags: Oracle Corp., Oracle Database, Oracle Database 10g, Automatic Storage Management, Databases, Enterprise Software, Software, Data Management; White papers 2006-03-01

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (1 results)

Technical articles (1 results)

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now