Script to update the PO Attachment from Back End
Script to update the PO Attachment from Back End Introduction: Script to update the Purchase Order Attachment from the back end. Cause of the issue: The Purchase Order Attachments are…
Read MoreSubmit PO Output for Communication Report from Back end
Submit PO Output for Communication from Back end Introduction: Script to Submit the PO Output for Communication Report from the back end. Cause of the issue: In PO data Migration…
Read MoreQuery to find the Onhand Qty Stock Details for Non-Serial Items
Script to Extract the Onhand Qty Details for Non-Serial Items Introduction: Script to Extract the Onhand Qty Details for Non-Serial Items. Cause of the issue: In PO Migration from one…
Read MoreAPI to Update the Terms and Condition in PO
API to update the terms and Condition details in PO from back end Introduction: API to update the terms and Condition details in PO from back end. Cause of the…
Read MoreHow to restrict a particular database user to login within time period
Description: We are restricting the logon time for a particular database user so the user can only access the database within defined periods. If the user attempts to logon during…
Read MoreScript to spool SQL query output to HTML
set pages 5000 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON – HEAD “<TITLE>EMPLOYEE REPORT</TITLE> – <STYLE type=’text/css’> – <!– BODY {background: #FFFFC6} –> – </STYLE>” – BODY…
Read MoreScript to resize datafile without ORA-03297 error
select ‘alter database datafile’||’ ”’||file_name||””||’ resize ‘||round(highwater+2)||’ ‘||’m’||’;’ from ( select /*+ rule */ a.tablespace_name, a.file_name, a.bytes/1024/1024 file_size_MB, (b.maximum+c.blocks-1)*d.db_block_size/1024/1024 highwater from dba_data_files a , (select file_id,max(block_id) maximum from dba_extents group…
Read MoreScript to view hidden parameter setting
Set lines 2000 col NAME for a45 col DESCRIPTION for a100 SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ‘\_%’ ESCAPE ‘\’;
Read MoreScript to find rollback segment used
set lines 1000 pages 1000 col RBS format a20 col sid format 9999 col user format a28 col status format a12 SELECT r.name “RBS”, s.sid, s.serial#, s.username “USER”, t.status, t.cr_get,…
Read MorePrevent users from log into a database within defined period
Description: It shows how to set up the database security so that users cannot log into the database outside defined time-window. Here we are using Event Triggers. Steps to be…
Read More