Oracle 12C New Feature JSON Functions in SQL

oracle 12c new features

How to generate JSON document from SQL itself?
This video helps you in writing SQL to generate JSON document from oracle database.

oracle 12c new features for developers

---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

---------------------------------------------------------------------------------------------------------------------------

[baskarbaskar]

Hi, Thanks for the Video. I am aware of Oracle Database but not JSON. So, I was wondering how to use JSON in Oracle Database and this Video made it very clear and simple. Just increase your Voice Volume The volume at 8.58 is fine. So maintain that volume level. In all the other places, I have to keep my ears near to the Speaker of my laptop in order to listen what you are saying.

[parijujare]

Thanks for the video. Could you also please share how the json data will be insert into a table

[akashsoni]

Hello Shiva, Thanks for the videos, if we want to parse JSON file to Oracle database table, could you please tell me.

[shrihara]

Hi,
Is it possible to do this other way around?
I have a JSON and I want to create table like structure from it.

[Asteducation]

Awesome explanation, and very useful information. Thanks man

[akshayphadnis]

Sir how can we use it in PLSQL. I have a varchar2 variable with JSON data, how can I parse it to extract key, value out of it?

[antonybabu]

Hi i want to create procedure it's gives return values in json formate at single row comma separated...can you pls tell me if is it possible to make it

[arifmohammed]

good video Siva, is there a way to consume third party api into oracle table

[aravindrajendran]

Nice siva..
Doing a great job.
Keep it up 👍

[BewithuNnk]

Hi, I want to be work on real time project of Plsql. How to do it. Could you please help me to improve my coding skills.

[shashank]

Hi siva,
When I m trying
Select json_object('hltkey' value hlt_ key) from hlt_cfg_config;
I m getting error.. Missing right parenthesis? Why

[abhishekkumarch]

hi, bro videos are very instresting ..can we have series where java interacts with plsql and how it takes data from oracle db..please make this ..thanks

[paapaasare]

How do I get data from a json API and insert it into a table?

[megakarunya]

How to validate a json object in database?

[abhishek-bbvg]

How to print the key value pair like "Department name" : "ACCOUNTING"

[ziyaddhailey]

How to fetch data after converting to case to

[srikanthsri]

in real time where do we use this json document???

[susmithareddy]

what is json and where we use json and advantages of json