Searching for a word in files across all subfolder in linux

Issue the Below command in the Linux terminal where /u01/test is the path to be searched.

$ grep -rnwi ‘/u01/test’ -e ‘CUST_LEAVE_DETAILS_V’ >> CUST_LEAVE_DETAILS_V.txt

• -r or -R is recursive,
• -n is line number, and
• -w stands for match the whole word.
• -l(lower-case L) can be added to just give the file name of matching files.

> CUST_LEAVE_DETAILS_V.txt will write the output of the command returned to a file name CUST_LEAVE_DETAILS_V.txt

source

 

 

Accessing shared path in Virtual box

I have a PC with windows in it and Virtual Box with Manjaro i3. So now I went to shared folder in Virtual box and created a path.

I have installed youtube-dl and downloaded some playlist and so I need to transfer folder and files to my windows

I checked the manjaro documentation to install virtual box host modules by below command

pamac install virtualbox $(pacman -Qsq "^linux" | grep "^linux[0-9]*[-rt]*$" | awk '{print $1"-virtualbox-host-modules"}' ORS=' ') 

Now I have rebooted as said in the documentation

Added my user to vbox group

sudo gpasswd -a $USER vboxusers

Now run the below commands to start the service

systemctl enable vboxservice
systemctl start vboxservice
groupadd vboxsf

After starting the service navigate to $cd /media and there you will find the shared folder.

Thanks

Query to get Invalid Objects in oracle apps

Below is the query to get Invalid Object in Oracle apps

 

select object_name, object_type, owner
from dba_objects o
where status = ‘INVALID’
order by
decode(o.owner,’SYS’,’01’,
‘SYSTEM’,’02’,
‘APPS’, ’06’,
‘APPS_MRC’, ’07’,
’03’),
decode(o.objecT_type,’PACKAGE BODY’,’10’,
‘VIEW’,’05’,
‘MATERIALIZED VIEW’,’06’,
‘SYNONYM’,’04’,
‘FUNCTION’,’07’,
‘PROCEDURE’,’07’,
‘PACKAGE’,’08’,
‘TABLE’,’02’,
’01’) ,
o.object_name ;

Download playlist in using youtube-dl

I was trying to get the command to download the full playlist of the youtube playlist dint get a proper command.

I just went through the documentation and then I got the command

$ youtube-dl -o '%(playlist)s/%(playlist_index)s - %(title)s.%(ext)s' https://www.youtube.com/playlist?list=PLwiyx1dc3P2JR9N8gQaQN_BCvlSlap7re

Query to get jdr path in oracle apps

Sometimes in form function for a OAF page there will be only Region code there will not be Region path.

In order to get the region path use the below Query. We can search using the PATH_NAME in the below query

SELECT PATH_NAME, jdr_mds_internal.getDocumentName(path_docid) as component
,      path_type    ,      path_seq    ,      creation_date    ,      last_update_date
FROM jdr_paths;