select apex_web_service.make_rest_request 2> (p_url => 'https://sv443.net/jokeapi/v2/joke/Programming?amount=10', 3> p_http_method => 'GET') as json_output 4> from dual; {"error": false,"jokes": [{"category": "Programming","type": "single","joke": "The generation of random numbers is too important to be left to chance.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 39,"lang": "en"},{"category": "Programming","type": "single","joke": "\"Can I tell you a TCP joke?\"\n\"Please tell me a TCP joke.\"\n\"OK, I'll tell you a TCP joke.\"","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 58,"lang": "en"},{"category": "Programming","type": "twopart","setup": "Why do Java programmers hate communism?","delivery": "They don't want to live in a classless society.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 53,"lang": "en"},{"category": "Programming","type": "single","joke": "Algorithm: A word used by programmers when they don't want to explain how heir code works.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 51,"lang": "en"},{"category": "Programming","type": "single","joke": "Your mama's so FAT she can't save files bigger than GB.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 9,"lang": "en"},{"category": "Programming","type": "single","joke": "Hey Girl,\nRoses are #ff0000,\nViolets are #0000ff,\nI use hex odes,\nBut I'd use RGB for you.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 41,"lang": "en"},{"category": "Programming","type": "single","joke": "A SQL statement walks into a bar and sees two tables.\nIt approaches, and asks \"may I join you?\"","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 5,"lang": "en"},{"category": "Programming","type": "twopart","setup": "What do ou get if you lock a monkey in a room with a typewriter for 8 hours?","delivery": "A regular expression.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 26,"lang": "en"},{"category": Programming","type": "single","joke": "Judge: \"I sentence you to the maximum punishment...\"\nMe (thinking): \"Please be death, please be death...\"\nJudge: \"Learn Java!\"\nMe: \"Damn.\"","flags": {"nsfw": false,"religious": alse,"political": false,"racist": false,"sexist": false},"id": 45,"lang": "en"},{"category": "Programming","type": "twopart","setup": "How do you know God is a shitty programmer?","delivery": "He wrote the OS for an entire universe, but idn't leave a single useful comment.","flags": {"nsfw": false,"religious": false,"political": false,"racist": false,"sexist": false},"id": 19,"lang": "en"}],"amount": 10} Copyright © 2020, Oracle and/or its affiliates 10