In 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…
Tag: Databases
phpMyAdmin Tutorial Part 2 of 2
phpMyAdmin tutorial on how to manage a MySQL database. linuxconsultant.info Part 1 of 2
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…
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…
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…
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…
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: Save your notepad file with . sql extension. c:\filename.sql Run it in the command prompt c:>sqlplus…
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…
Oracle 11g RMAN Catalog Creation
Oracle 11g RMAN Creation, Database Registration, Backup