Archive for the ‘Oracle’ Category

Older Entries

Introduction to Rollup Clause

In: MS SQL|Oracle

26 Feb 2010

In this article we will go over basic understanding of Rollup clause in Oracle and SQL Server. ROLLUP clause is used to do aggregate operation on multiple levels in hierarchy. Let us understand how it works by using an example. Consider a table with the following structure and data: MSSQL CREATE TABLE tblPopulation ( Country VARCHAR(100), [...]

Copy Table and Data Between 2 Database

In: Oracle

15 Jan 2010

Recently I need to do some task base on the Production data and I don’t want any accident happen to my production database so I decided to copy the production tables I need over to the UAT database and do the ETL. I got 2 option to achieve this: Create dblink to another database and [...]

Protected: Crystal Report Unable to Display Chinese Character

In: Oracle

7 Jan 2010

There is no excerpt because this is a protected post.

  • Enter your password to view comments.
  • Tags:

SELECT Rows with MAX(Column value), DISTINCT by Another Column

In: MS SQL|MySQL|Oracle

16 Dec 2009

Recently I am planning to do a maintenance job on a log table and I am suppose to write a sql script that keep the latest records and delete all the legacy records. My first try is select col1, max(created_date) from <table_name> group by col1; Using the above sql, I am able to list out [...]

ORA-00942 Table or View Does Not Exist Oracle Error

In: Oracle

30 Nov 2009

Recently one of the webapps in UAT environment have trouble running one of the dayend job schedule. I try to go over the application log and notice Cause: java.sql.SQLException: ORA-00942: table or view does not exist Then I try to run the sql statement that the webapp trying to execute before hitting this error and [...]

Query All Tables

In: Oracle

23 Nov 2009

Recently I have to do some maintenance job on my client site and  I am force to do my work on console terminal. I am used to do my wrok on tools like Toad and SqlDeveloper where I can use the fency GUI and the AI of those tools. Now I have to dig up [...]

Select Count Using Grouping

In: Oracle

18 Nov 2009

Recently coming across a question regarding select count using grouping. Below is two sample tables TABLEA ID CHIP ———– ———- 1 Lays 1 Ruffles 1 Ruffles 1 Ruffles 1 Doritos 1 Doritos 2 Lays 2 Lays 2 Doritos 3 Ruffles TABLEB ID NAME ———– ———- 1 Jim 2 Bob 3 MISSY 4 Tom The query [...]


Older Entries

About this blog

This is a place I create just for fun and to write down some experience and notes for myself. So feel free to enjoy and drop any comments you have. I had been employed as Programmer, System Analysts, System Administrator, DBA and Project Manager. I will share some of my case study here as well. Enjoy!

Categories

Archives

  • Shawn Brito: Amazing... Thanks for the really cool tip.. We just shaved off 6 seconds off the SSL page :) Dude [...]
  • kc: great.. it solved my issue ... thnks a lot... :) [...]
  • mike: thank you so much. it helped solve my error. :) [...]
  • Wyatt Richardson: I'm pretty much impressed with the stability of Windows 7. It is better than windows Vista which hog [...]
  • Ellie Hughes: Playstation is the best gaming console that i have owned. Me and my brother are addicted in playing [...]

 

Calendar

September 2010
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
27282930  

SEO

Copyright © 2007 - Vpire Blog - is proudly powered by WordPress | Log in