This post I am trying to explain many things about date in oracle like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in years,oracle date difference in days, oracle date difference in months Oracle has provided date and timestamp types for storing the date and time information in the […]
How to change date format in oracle database
We often need to change the date format while checking. Here are some ways which you can use to change the date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current […]
Script to check locks in oracle database
Script to check locks in oracle database ( Single Instance) SELECT inst_id,DECODE(request,0,’Holder: ‘,’Waiter: ‘)||sid sess, id1, id2, lmode, request, type FROM V$LOCK WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM V$LOCK WHERE request>0) ORDER BY id1, request ; In case of RAC ,below query is used check locks in oracle database SELECT inst_id,DECODE(request,0,’Holder: […]
How to find EBS R12 components Version
We are often asked How to find EBS R12 components Version. This is includes all R12.0/R12.1 and R12.2. I will try to explain how to find out that with various EBS R12 version with command and reports. Apache Version/how to check oracle application server version in r12 $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java […]
Query to Find oracle EBS failed login attempts
Before moving directly into query for oracle EBS failed login attempts and oracle ebs user login history, lets find out how to enable signon audit in EBS to collect this data and other important stuff Introduction to EBS Signon Auditing Oracle EBS has lot of auditing features to check the information of user login to […]
alter table modify column in oracle database
W e can change the column datatype in table using alter table modify column in oracle ALTER TABLE table_name MODIFY column_name <action>; Action can be many things like(a) change the data type(b) Shorten or widen the data type(c) Change the default value(d) Change to allow null or not nulls(e) Column Visibility(d) Virtual Column ModificationLet’s start […]
