Wednesday, November 10, 2021

Clear the command entered in a Terminal on Mac Ctrl+U and Ctrl+C

 example:

 xyz-mac:~user: mac abc/vbs/vjbad/jkbsjkn/skdnasldn/sdjkkjbasdb

Lets say you want to clear this on a Mac terminal.

Use : Ctrl + U or Ctrl + C

 Note: Use Ctrl key not Command key

 Source: https://superuser.com/questions/192490/clear-command-from-terminal-in-os-x

 Additional Keys:

Ctrl+K clears the screen 


https://osxdaily.com/2006/12/19/command-line-keyboard-shortcuts-for-mac-os-x/


Read REST data using XML input to PLSQL

declare
l_value varchar2(4000);
begin

for x in (select *
from xmltable(
   '/Entities/Entity/Fields/Field'
   passing xmltype(get_rest_details('http:///....us.xyz.com/q...../...//....'))
   COLUMNS
   name varchar2(4000) path '@Name',
   value varchar2(4000) path 'Value'
)
)
loop
htp.p(x.name||chr(9)||chr(9)||'=>'||x.value);
end loop;
exception when others then
htp.p(sqlerrm);

end;

 

-- get_rest_details is a procedure that performs authentication and call REST service
Source: https://docs.oracle.com/cd/E37097_01/doc.42/e35127/GUID-4AC0229D-85E2-439A-9485-531B7B8B6274.htm#AEAPI1955

Example:

l_clob := apex_web_service.make_rest_request(
        p_url => 'http://us.music.yahooapis.com/ video/v1/list/published/popular',
        p_http_method => 'GET',
        p_parm_name => apex_util.string_to_table('appid:format'),
        p_parm_value => apex_util.string_to_table('xyz:xml'));

What is ESG in S&P BSE ESG 100?

 ESG stands for Economic, Social and Governance.

Companies that follow good ethical practices and are in the good books of the Regulators and Government

Thursday, November 4, 2021

What are Hurricane, typhoon, cyclones? same storm, just different names.

 Good Read : 

http://thevane.gawker.com/what-is-the-difference-between-a-cyclone-typhoon-and-1617803648

a hurricane/typhoon/cyclone generally has winds stronger than 74 MPH (~124 Km/hr)

India - Cyclone, Japan -Typhoon, USA - Hurricane

How to clean your stainless steel water bottle or coffee maker using Vinegar or Bleach


Use half bottle vinegar with half bottle water i.e., vinegar to water 1:1 ratio. Rinse it.

Avoid using bleach. If you have used bleach. Use half teaspoon for 1liter water. Rinse it twice.

(2 teaspoons per gallon (3.78 liters)=> 1 teaspoon for 1.8 liters) =>~1 litre.

 

Notes:

White vinegar has 5 percent acidity; while cleaning vinegar, on the other hand, has 6 percent. 
20 percent stronger than white vinegar.

Cleaning vinegar can be used undiluted or mixed with water, depending on the job.
For tough stains on fabric furniture or clothes, use cleaning vinegar alone on a sponge or rag to wipe away the spot. 

 It is not recommended to use cleaning vinegar—or white vinegar, for that matter—on natural stone, waxed wood, cast iron or aluminum.

 Useful reads https://health.tas.gov.au/healthykids/blog/how_to_clean_water_bottles