Tag: Databases

Installing Oracle Database 10g Express Edition and Changing the Default HTTP Port

Oracle logoIn this article I will write about installing the Oracle Database 10g XE on Windows and changing the default port number for HTTP and optionally for FTP. The installer does not provide any customization option and you end up with the DB server instantly up and running reserving the port 1521 (a default for Oracle database servers), including an embedded HTTP listener set to a default port of 8080 which might conflict with some existing Java application servers or servlet containers such as Tomcat, JBoss Application Server and Glassfish which use the same port by default. Although it’s easy to start and stop the Oracle database with the shortcuts pre-installed in the Start menu, its http listener remains “on” at all times with no shortcut to be turned on and off easily.

In my case I already have Tomcat and Glassfish which are set to use the 8080 port as well, so I will show you how to modify the port number of Oracle 10g XE as I go along.

About APEX or what I would normally call Oracle 10g XE

Oracle Database 10g Express Edition (Oracle Database XE also goes by an abbreviated code name APEX) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for:

  • Developers working on PHP, Java, .NET, XML, and Open Source applications
  • DBAs who need a free, starter database for training and deployment
  • Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
  • Educational institutions and students who need a free database for their curriculum.

With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations.

Continue reading “Installing Oracle Database 10g Express Edition and Changing the Default HTTP Port”

Oracle 10g Database Administrator II: Backup/Recovery and Network Administration

Product Description
Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This text drills down key tools and techniques for Oracle database backup, recovery and network administration and provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-043). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions. This text is the perfect compliment to the Oracle 10g: Database Administrator: Implementation and Administration (DBA1) text and the 1Z0-042. . . . More >>

Oracle 10g Database Administrator II: Backup/Recovery and Network Administration

Mastering Oracle PL/SQL: Practical Solutions

  • ISBN13: 9781590592175
  • Condition: USED – VERY GOOD
  • Notes:

Product Description
This isn’t a tutorial on how to code PL/SQL. It’s designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and won’t break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques. This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. The practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects. Mastering Oracle PL/SQL: Practical Solutions is targeted primarily toward the DBA or developer charged with the implementatio. . . More >>

Mastering Oracle PL/SQL: Practical Solutions

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & . NET

Product Description
Create and Use Stored Procedures for Optimal Database PerformanceDevelop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & . NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server’s native Transact-SQL and . NET CLR languages. You’ll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers. Essential Skills for Database ProfessionalsGroup and execute T-SQL statements using batches, scripts, and transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures Develop and manage stored procedures using C# and Visual Basic . NETIm. . . More >>

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & . NET

Book Giveaway & Chapter Download: Mastering Oracle Scheduler in Oracle 11g Databases

Oracle Scheduler does a lot of out of the box things, and if the demands are not too high, Oracle Scheduler can cover most of the situations. When your application has to run many thousands of jobs in an hour and log them over a long period, a little more attention is needed. In cases where the demands are high, we need to take care of a few more things to keep the system happy. What we need to do depends on how the Scheduler is used and what kind of load it is supposed to handle.

In this chapter, we will take a closer look at how we can control this beast. We will take a look at the privileges for job creation, job execution, and Scheduler management. We will also examine how to control logging retention and find a way to prevent jobs from running when the database starts.

Job Creation

Like most object types in the database, as seen at the beginning of Chapter 1, Oracle enables us to create Scheduler objects. The privileges create job and create external job are very important. They should normally be used when building an application system . Also, there is a create any job privilege, which can be useful when you need to create a job in a different schema. Normally, this privilege should not be granted to anyone. It will allow the grantee to run an arbitrary code on any schema, which is not particularly desirable. Instead, just log on to the correct schema and perform the tasks using the correct privileges.

Continue reading “Book Giveaway & Chapter Download: Mastering Oracle Scheduler in Oracle 11g Databases”

What is the command-line code to load a SQL script in notepad to Oracle 10g express?

Question:

I made a script using notepad but what is the command line code to load it into Oracle express 10g? In MySQL it is just source C: or where ever I have it located.

Answer:

Follow these steps:

  1. Save your notepad file with . sql extension. c:\filename.sql
  2. Run it in the command prompt
    c:>sqlplus “username/password” @”c:\filename.sql”
  3. Now you should  get the result of your script. That’s it.
Powered by Y! Answers

SQL SERVER / T-SQL Tutorial: Left Outer Join – Right Outer Join – Full Join – Combining Join


T-SQL Tutorial

OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

Product Description
Here’s the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today’s Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the “Best Study Guide” selection in CertCities Readers’ Choice Awards for two consecutive years, this book provides: Clear and concise information on advanced data… More >>

OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

How do I get started in writing/programming in T-SQL?

I am completely confused on what T-SQL really is and how it is different from SQL and its variants.

How do you guys program something using T-SQL language?
I mean where do you actually ‘encode’ those T-SQL codes?
In cobol I use notepad as the programming environment.

Do I need to download something like that of a C++ compiler?

Powered by Y! Answers

Rotating Oracle Database’s Alert Log with ADRCI

Rotating Oracle Database’s Alert Log with ADRCI
Many Oracle database administrators would not only like to report on (ORA-) errors but also manage the alert log itself–saving and/or trimming the alert log, aka alert log rotation. Oracle’s new ADR with command interface can easily be used to help rotate Oracle’s alert log.

Read more on Database Journal

Oracle PL/SQL Best Practices

  • ISBN13: 9780596514105
  • Condition: NEW
  • Notes: Brand New from Publisher. No Remainder Mark.

Product Description
In this compact book, Steven Feuerstein, widely recognized as one of the world’s leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in… More >>

Oracle PL/SQL Best Practices

T-SQL: How do I find the greatest values in a column?

How can write a SELECT statement that finds the n greatest values in a column? From what i’ve read, the TOP statement only returns the first n rows, it doesn’t take any regard to the values. For example, if a have a column with ages, i want to be able to find the 5 oldest people.

Oracle Database 11g PL/SQL Programming

Product Description
Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective … More >>

Oracle Database 11g PL/SQL Programming

SQL SELECT INTO Statement

The SQL SELECT INTO statement can be used to create backup copies of tables.

The SQL SELECT INTO Statement

The SELECT INTO statement selects data from one table, creates a new table with the exact structure and size and inserts automatically the selected data into the new table.

SQL SELECT INTO Syntax

We can select all columns into the new table:

SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_tablename

Or we can select only the columns we want into the new table:

SELECT column_name(s)
INTO new_table_name [IN externaldatabase]
FROM old_tablename

Continue reading “SQL SELECT INTO Statement”

How to create an auto-incrementing column in MS SQL Server 2000

Unlike Microsoft SQL Server 2005 and 2008, MS SQL Server 2000 does not have a ROW_NUMBER() function which applies only to the results of a SELECT query as it doesn’t store any permanent value in the DB.

The way it works is in keeping with the principles of relational databases. There is no implict ordering of records in an RDBMS. Only by using ORDER BY, a particular ordering (and not sorting) can be enforced only when doing a SELECT.

Since Microsoft SQL Server 2000 doesn’t have ROW_NUMBER(), the need for creating a primary key column of format int with the auto-increment functionality can be achieved using the keyword IDENTITY(1,1). IDENTITY means “a unique IDENTITY for the record so long as this table exists”.

Usage example:

CREATE TABLE jobs
(
job_id smallint IDENTITY(1,1)PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL DEFAULT
min_lvl tinyint NOT NULL CHECK (min_lvl >= 10),
max_lvl tinyint NOT NULL CHECK (max_lvl <= 250) ) 

Microsoft’s T-SQL reference under SQL Server 2000 documentation at MSDN explains the IDENTITY property in detail at http://msdn.microsoft.com/en-us/library/aa933196(SQL.80).aspx