09
Oct
2011

How to Uninstall Oracle in XP & Linux

Windows
Oracle uninstall is a Dangerous Process. If you mistake any process then a lot of problem arise. I am searching a lot of and test it in oracle 10g. It works properly.

1.Uninstall all Oracle components using the Oracle Universal Installer (OUI).
2.Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products.
3.Delete any references to Oracle services left behind in the following part of the registry:
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*
4.It should be pretty obvious which ones relate to Oracle.
5.Reboot your machine.
6.Delete the “C:\Oracle” directory, or whatever directory is your ORACLE_BASE.
7. Delete the “C:\Program Files\Oracle” directory.
8.Empty the contents of your “c:\temp” directory.
9.Empty your recycle bin.

Source : http://www.oracle-base.com/
Link: http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php

Tags: , ,
Posted in Oracle 10gComment:No Comments|12,694 views

read more
09
Mar
2011

Case Sencative Search in oracle using like

The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another, the LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second. LIKE calculates strings using characters as defined by the input character set…

Read the rest of this entry »

Tags: ,
Posted in Oracle 10gComment:3 Comments|339 views

read more
07
Mar
2011

How to create a trigger for automatic Table ID

How to Create a Trigger for create automatic generated ID….

Use Tools Oracle 10g and Toad 9

Step 1#

–##### Added By khairul. Date :06-Mar-2011
–##################### Start Get PS_LEASE_ASSET_ID(PS_LEASE_ASSET_ID)########################################

FUNCTION GET_NEW_LEASE_ASSET_ID (a IN NUMBER)
RETURN VARCHAR2
IS
tmp_id PS_LEASE_ASSET.PS_LEASE_ASSET_ID%TYPE;
tmpBID VARCHAR2 (5);
BEGIN
SELECT C.COUNTRY_ID ||SUBSTR(C.CMP_BRANCH_ID,7,3) BID INTO tmpBID FROM CM_CMP_BRANCH C WHERE C.IS_OPERATING=’Y';

SELECT NVL (MAX (PS_LEASE_ASSET_ID), TO_CHAR (SYSDATE, ‘yymmdd’)|| tmpBID || ‘0000000′)
INTO tmp_id
FROM PS_LEASE_ASSET;

IF SUBSTR (tmp_id, 1, 6) = TO_CHAR (SYSDATE, ‘yymmdd’)
THEN
RETURN TO_CHAR (tmp_id + 1, ‘000000000000000000′);
ELSE
RETURN TO_CHAR (SYSDATE, ‘yymmdd’) || tmpBID || ‘0000001′;
END IF;
END;
–#########################End Get PS_LEASE_ASSET_ID#####################—–
Read the rest of this entry »

Tags: , ,
Posted in Oracle 10gComment:28 Comments|989 views

read more
12
Feb
2011

Oracle Function

The syntax for a function is:

CREATE [OR REPLACE] FUNCTION function_name
[ (parameter [,parameter]) ]
RETURN return_datatype
IS | AS
[declaration_section]
BEGIN
executable_section
[EXCEPTION
exception_section]
END [function_name];

Tags: ,
Posted in Oracle 10gComment:2 Comments|330 views

read more
11
Jan
2011

ICC World Cup Theme Song

Win Win Bangladesh win…….

ICC World Cup Theme Song in Bangla

Get this widget | Track details | eSnips Social DNA

Tags:
Posted in OthersComment:1 Comment|263 views

read more
09
Oct
2010

My Higher Education

Higher Education is very important any time in a life .The North American certificate is always valuable. But it is very expensive to study in North America. If you have an admission in USA you have must a good GRE score or TOFEL. But now I am a service man (last 1 year as a programmer). I have not sufficient money for admission in USA. For this I choose Europe or Australia. For going to higher education of those country you need must IELTS. After that you have search suitable university or department. If you manage any scholarship, it is good for you. Because the life style in Europe or Australia is very expensive. Over all you need a good IELTS score .

Now a day I am trying for IELTS. I have study in a little bit in internet. Because I am very busy with my office work (9 AM to 8 PM).There is a lot of article in internet. I have study a little bit. I publish that metrials what is very use full for my visitor.
Best of luck.
I have read an article on Climate Change. That’s related some keywords are given below.
Chaos = Disorder
Prompted = encouraged
Toll = ring
Benign = kind
Mogul = industrialist
Clarification = explaining
Exempt = excuse
Bribe = corrupt
Probe = search
Chaos = confusion
Nepotism = partiality

Tags: , , ,
Posted in StudyComment:11 Comments|552 views

read more
12
Aug
2010

Mr. Bean

I Like Mr. Bean Animated Series. And my dream once if i will meet Mr. Rowan Atkinson …..

Tags:
Posted in OthersComment:3 Comments|713 views

read more
16
Mar
2010

Fifa WorldCup 2010 Free WordPress Theme

Amazing Free WordPress Theme Motivated By Fifa WorldCup 2010 By ARCom & Released By ZCed.com.

Read the rest of this entry »

Tags: , , ,
Posted in WordPressComment:37 Comments|1,379 views

read more
08
Mar
2010

Winners for the 82nd Academy Awards

List of winners at the 82nd annual Academy Awards:

• Motion Picture: “The Hurt Locker.”

• Actor: Jeff Bridges, “Crazy Heart.”

• Actress: Sandra Bullock, “The Blind Side.”

• Supporting Actor: Christoph Waltz, “Inglourious Basterds.”
Read the rest of this entry »

Tags: , , ,
Posted in OthersComment:150 Comments|13,684 views

read more
02
Feb
2010

10 Things Husbands Should Never Do


1. Offer to “babysit” your own kids. When your 16-year-old neighbor does it, it’s called babysitting. When a parent does it, it’s called child care, and it lasts for at least 18 years. Get it?
Read the rest of this entry »

Tags:
Posted in OthersComment:No Comments|471 views

read more
Page 1 of 41234»