Tag: Databases

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

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… 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… Continue reading 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… Continue reading 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… Continue reading 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… 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: Save your notepad file with . sql extension. c:\filename.sql Run it in the command prompt c:>sqlplus… Continue reading What is the command-line code to load a SQL script in notepad to Oracle 10g express?

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… Continue reading 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… Continue reading How do I get started in writing/programming in T-SQL?

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… Continue reading Rotating Oracle Database’s Alert Log with ADRCI

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.… Continue reading 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… Continue reading T-SQL: How do I find the greatest values in a column?

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,… Continue reading 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… 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… Continue reading How to create an auto-incrementing column in MS SQL Server 2000