Sylhet Tour In Joyantapur
Sylhet Tour In Joyantapur
24
Feb
2012
Feb
2012
24
Feb
2012
Feb
2012
24
Feb
2012
Feb
2012
05
Feb
2012
Feb
2012
Oracle VIEWS
SQL: VIEWS
http://www.techonthenet.com/sql/views.php
________________________________________
A view is, in essence, a virtual table. It does not physically exist. Rather, it is created by a query joining one or more tables.
Creating a VIEW
The syntax for creating a VIEW is:
CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;
For example: Read the rest of this entry »
05
Feb
2012
Feb
2012
Feature of Oracle
Definition
http://searchoracle.techtarget.com/definition/10g
10g is Oracle’s grid computing product group including (among other things) a database management system (DBMS) and an application server. In addition to supporting grid computing features such as resource sharing and automatic load balancing, 10g products automate many database management tasks. The Real Application Cluster (RAC) component makes it possible to install a database over multiple servers. Read the rest of this entry »
09
Oct
2011
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
09
Mar
2011
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…
07
Mar
2011
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 »
12
Feb
2011
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];
