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

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

Are Raisins good or bad for you? (kishmish)

.

What are raisins?
Raisins are minimally processed, with no added ingredients or preservatives. 

How are raisins made?
Dried in the sun or in a food dehydrator
They are high in sugar and calories, so they should only be eaten in moderation.

Caution:
To prevent natural discolouration, dried fruits are sometimes treated with sulphur dioxide.
This compound can lead to discomfort, headaches and nausea when digested.


Do Raisins Go Bad - Shelf life period ? how long do raisins survive?
About 3-5 months in the pantry if opened
 6 months in the pantry if unopened.
 9-12 months in the fridge (both opened and unopened)


How much portion of Dry Fruits raisins per day?
A portion of dried fruit is around 30g.
This is about 1 heaped tablespoon of raisins, currants or sultanas,
1 tablespoon of mixed fruit,
2 figs, 3 prunes or 1 handful of dried banana chips.

Tip:
Soak 8-10 raisins overnight in a glass of water and then eat them in the morning.


Side affects of raisins
Too much dietary fiber can be bad for your stomach
Too many antioxidants can cause damage to your body
May cause Hypotension.

Can raisins make you sick?

It increases soluble fiber. Too much fiber may cause gastrointestinal upset, such as cramps, gas, and bloatingSome people may even develop diarrhea

Additional Information

The soaking allows all the vitamins and minerals of raisins to be released in the water while restricting sugar content. The process multiplies the benefits of black raisin for your body, hair growth, and skin.

How long to soak raisins?

Cover the raisins with room temperature liquid and soak for 30 minutes. After that time has passed, they're ready to use!