Archive for October, 2022
How To Get Last Record From The Table In Oracle Sql
October 30th, 2022, posted in Oracle Queries
AP_SUPPLIERS , AR_CUSTOMERS DETAILS QUERY IN ORACLE APPS R12
October 16th, 2022, posted in Oracle QueriesAP_SUPPLIERS MASTER DETAILS QUERY:- ***************************************** select a.SEGMENT1 vendor_code, b.VENDOR_ID, a.VENDOR_NAME, b.VENDOR_SITE_ID, (select organization_id from hr_operating_units where organization_id=b.ORG_ID )ou_id, (select name from hr_operating_units where organization_id=b.ORG_ID )operating_name, b.VENDOR_SITE_CODE, (b.ADDRESS_LINE1||b.ADDRESS_LINE2||b.ADDRESS_LINE3||b.CITY||b.STATE||b.ZIP) address, null GST_REGISTRATION_NO, c.PAN_NO, b.state from ap_suppliers a, ap_supplier_sites_All b, JAI_AP_TDS_VENDOR_HDRS c, JAI_CMN_VENDOR_SITES d where a.vendor_id=b.vendor_id and b.VENDOR_ID=c.vendor_id(+) and b.VENDOR_SITE_ID=c.VENDOR_SITE_ID(+) and b.VENDOR_ID=d.vendor_id(+) and b.VENDOR_SITE_ID=d.VENDOR_SITE_ID(+) AND (NVL(A.ENABLED_FLAG,'N')='Y' OR NVL(D.INACTIVE_FLAG,'N') <> 'N') and b.INACTIVE_DATE is null and a.end_date_active is null AND A.SEGMENT1 = 'PRMAAA1' order by a.VENDOR_NAME,b.VENDOR_SITE_CODE,b.ORG_ID AR_CUSTOMERS MASTER DETAILS QUERY:- ********************************************** select hp.party_number customer_number, hca.cust_account_id customer_id, hp.party_name customer_name, hca.account_number customer_account_number, hcas.org_id ou_id, (select name from hr_operating_units where organization_id = hcas.org_id) operating_unit_name, HCAS.PARTY_SITE_ID CUSTOMER_SITE_ID, HPS.PARTY_SITE_NUMBER CUSTOMER_SITE_NUMBER, ( HL.ADDRESS1 || HL.ADDRESS2 || HL.ADDRESS3 || HL.ADDRESS4 || HL.CITY || HL.POSTAL_CODE) ADDRESS, NULL GST_REGISTRATION_NO, jac.PAN_NO PAN_NO, hl.state, HP.PARTY_TYPE CUSTOMER_TYPE from hz_cust_acct_sites_all hcas, hz_cust_accounts_all hca, hz_parties hp, hz_party_sites hps, hz_locations hl, JAI_CMN_CUS_ADDRESSES jac where 1=1 --and hca.account_number = 'RDAAAG2' and hca.cust_account_id = hcas.cust_account_id and hca.party_id = hp.party_id and hcas.party_site_id = hps.party_site_id and hca.party_id = hps.party_id and hps.location_id = hl.location_id and jac.address_id(+) = hcas.CUST_ACCT_SITE_ID order by customer_name
Find And Delete Files Older Than Some Particular Time Period In Linux
October 9th, 2022, posted in SolarisSearching By File Timestamp
Unix/Linux filesystems have three types of timestamp on each file. They are as follows:
- Access time (-atime): The timestamp when the file was last accessed.
- Modification time (-mtime): The timestamp when the file was last modified.
- Change time (-ctime): The timestamp when the metadata for a file (such as permissions or ownership) was last modified.
Search and delete file older than 7 days
Lets take an example, wherein we will find and delete file older than 7 days. We will be using the option “-mtime” of the find command for this.
1. Get a list of files using find command as follows:
# find /path_to_directory -mtime +7 -type f -exec ls {}\;
2. If the filenames start with any particular pattern, filter using that as follows:
# find /path_to_directory -name 'filenamepattern*' -mtime +7 -type f -exec ls {}\;
3. After checking and confirming the output, go for removal script(It is very IMPORTANT), otherwise there will be irrecoverable data loss.
# find /path_to_directory -name 'filenamepattern*' -mtime +7 -type f -exec rm -fv {}\;
# find . -name “*.pdf” -atime +7 -exec rm {} \;
4. If this needs to be done on a remote server through cron job and log the filenames of deleted files, use the following command
# ssh user@remote_ip "find /path_to_directory -name 'filenamepattern*' -mtime +7 -type f -exec rm -fv {} \; >> /tmp/backup_deletion`date +%Y%m%d`.log 2>&1"
Conclusion
The -mtime parameter will search for files based on the modification time; -ctime searches based on the change time. The -atime, -mtime, and -ctime use time measured in days. The find command also supports options that measure in minutes. These are as follows:
- -amin (access time)
- -mmin (modification time)
- -cmin (change time)
For example, to print all the files that have an access time older than seven minutes, use the following command:
# find . -type f -amin +7 -print
-newer option
The -newer option specifies a reference file with a modification time that will be used to select files modified more recently than the reference file.
Find all the files that were modified more recently than file.txt file:
# find . -type f -newer file.txt -print
