select ename, sal, comm, sal+COALESCE(comm,0) as total_compensation from emp;
Click here for the screenshot.
--Moid
Sunday, October 31, 2010
Friday, October 29, 2010
How to Install Oracle 11g R1 Software and configure database on Windows Vista?
Click here for the step-by-step (with screenshots) instructions on how to install Oracle 11g R1 database on Windows Vista.
--Moid
--Moid
How to Install Oracle 10g database on XP?
Click here for the step-by-step (with screenshots) instructions on how to Install Oracle 10g Software and configure database on Microsoft XP.
--Moid
--Moid
Thursday, September 30, 2010
Sunday, September 26, 2010
Saturday, September 25, 2010
How to display the output of the query vertically?
Create a procedure called Print_Table as sys
It uses authid_current user so you can install it ONCE per database and many people can use it (with roles and all intact):
Procedure and display instructions are here.
Reference: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1035431863958
Google Key words: "Tom Kyte Print_Table"
--Moid
It uses authid_current user so you can install it ONCE per database and many people can use it (with roles and all intact):
Procedure and display instructions are here.
Reference: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1035431863958
Google Key words: "Tom Kyte Print_Table"
--Moid
Thursday, September 23, 2010
How to subscribe to free monthly edition of Oracle Magazine? --Moid
Monday, September 20, 2010
Find the last recovery time/date of the Oracle database when "resetlogs" option was used to open the database (or when incarnation took place)?
Hi,
Have you ever been asked when was the database restored/reopened (with resetlog options)? It is a simple thing but sometimes a time consuming task especially if you are not very familiar with Oracle DBA dictionary or if you are a Jr. DBAs. Well, the answer can be found here. Hope this comes handy to someone in need.
--Moid
Keywords:
Last recovery date
Last restore date
Last recovery time
last restore time
Have you ever been asked when was the database restored/reopened (with resetlog options)? It is a simple thing but sometimes a time consuming task especially if you are not very familiar with Oracle DBA dictionary or if you are a Jr. DBAs. Well, the answer can be found here. Hope this comes handy to someone in need.
--Moid
Keywords:
Last recovery date
Last restore date
Last recovery time
last restore time
Sunday, September 19, 2010
How to Migrate Single Standalone to 2-node RAC Cluster
http://moidmuhammad.blogspot.com/2010/06/how-to-migrate-single-standalone-to-2.html
--Moid
--Moid
Friday, September 10, 2010
How to get the client's machine name and their IP Address in Oracle 10g?
Salam,
I was recently asked to spool out the client’s machine, their IP addresses and the service_name they are using to connect to RAC DB into a text file. I came up with the following queryand it worked like a charm. Although I tested it on a non-RAC db server, I have no doubt it will work on any RAC cluster.
--Moid
I was recently asked to spool out the client’s machine, their IP addresses and the service_name they are using to connect to RAC DB into a text file. I came up with the following queryand it worked like a charm. Although I tested it on a non-RAC db server, I have no doubt it will work on any RAC cluster.
--Moid
Monday, August 23, 2010
Saturday, July 31, 2010
Tuesday, July 13, 2010
My Notes on building ASM server and migrating databases to ASM on VMWare.
My notes on building 10g ASM server on a VMware and migrating non-ASM to ASM database. Click here for the step by step guide.
--Moid Muhammad
--Moid Muhammad
Tuesday, July 6, 2010
Linux script to take a daily Oracle export of a schema --Moid
I was recently asked to schedule a daily export of a schema. Although it is a simple task, I think it might help someone out there some day.
Click here for the link.
--Moid Muhammad
Click here for the link.
--Moid Muhammad
Sunday, June 27, 2010
10g Physical Standby DataGuard Installation steps --Moid
Click here for complete Step-by-Step procedure to create Physical Standby in Maximum-Performance mode.
Click here for 12 Data Guard Build by Umer Hussaini
--Moid
Click here for 12 Data Guard Build by Umer Hussaini
--Moid
Subscribe to:
Posts (Atom)