Databases

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

by

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.

Read more

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

by

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 … Read more

Mastering Oracle PL/SQL: Practical Solutions

by

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 … Read more

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

by

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 … Read more

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

by

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.

Read more

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

by

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: Save your notepad file with . sql extension. c:\filename.sql Run it in the command prompt c:>sqlplus … Read more

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

by

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 … Read more

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

by

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 … Read more

Rotating Oracle Database’s Alert Log with ADRCI

by

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 … Read more

Oracle PL/SQL Best Practices

by

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. … Read more

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

by

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 … Read more

Oracle Database 11g PL/SQL Programming

by

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, … Read more

SQL SELECT INTO Statement

by
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

Read more

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

by

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 … Read more