What all i learnt today

Create a text file which contains the step for connecting to SFTP open sftp://username:password@ServerName/ -hostkey="ssh-rsa 2048 b2:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx" # Change the remote directory cd serverPath # Upload the file to current working directory get -filemask="*>=1H"  DestinationLocation # Disconnect close # Exit WinSCP exit Save this Code as File1.txt and place this in the folder where WINSCP.EXE is present. OPEN : Open Connection Username: your Username for SFTP server Password: Password for SFTP server ServerName : Server IP or Server Host name hostkey: Its a key required to make connection to that server: How to get HostKey : Run the Code Without entering the hostkey value/Tag Command line will itself show you the hostkey. serverPath: Example:  cd /opt/app/ : Go to Required Path DestinationLocation : Destination where you need to download the files get -filemask="*>=1H"  C:\TEMP\ : Get the files fro...

To navigate to the network path using cmd. please use the below command : pushd

LISTAGG: The Oracle/PLSQL LISTAGG function concatenates values of the  measure_column  for each GROUP based on the order_by_clause . Syntax The syntax for the LISTAGG function in Oracle/PLSQL is: LISTAGG (measure_column [, 'delimiter']) WITHIN GROUP (order_by_clause) [OVER (query_partition_clause)] Parameters or Arguments measure_column The column or expression whose values you wish to concatenate together in the result set. Null values in the  measure_column are ignored. delimiter Optional. It is the delimiter to use when separating the  measure_column  values when outputting the results. order_by_clause It determines the order that the concatenated values (ie:  measure_column ) are returned. https://www.techonthenet.com/oracle/functions/listagg.php Explained: Imagine a situation where, where you want to parse the multiple results of an unique identifier in single line. Like Parse all the Items associated with that oLPN Find all the...

Thank You My Dear God! Today, I am starting with with this blog, to capture all my learning, my experience and like we say, before starting anything we should start it with remembering our dear god and thanking him and i just want to say " Thank you " "Jai Mata Di" Thank you god for this day, this moment  you have given me everything, and would like to thank you with all my heart. I believe what ever thing happens, happens for something good.  You are the mastermind, your planning can never fail, we are just a small creature, which are meant to make mistakes. I e ven  don't know how to thank you! Thank you papa ji and mummy ji!