Connect Oracle with visual Studio Code

lecture i am going to discuss what how to connect oracle database with visual studio code the first thing is open the visual studio code thereafter you need to go on the extension after that here you need to search oracle then you can see oracle developer tools for vs code and this is the version 21.40 and you can see 217k people that download it this is 67k 35k so selecting the first option click on this install so it's currently installing and for restore and this is to download this is from oracle core present so when installed successfully here i can create it click on this icon then after first you need to click on this plus so this you need to fill that so here you can see this is oracle sql developer click on this plus then you need to specify this all information so giving here hr test is the connection name username this i'm going to connect with the escort give the power password then hostname localhost port s1521 and this here overseer so if although correct click on this test so it's a success so here you need to do the same thing so basic words here and to here giving connecting with the escort user give the password then if you give all the correct click on this create connection so it's creating the connection of the and it's so successful after that click on there then you need to give the password of the escort press enter then you can see table stat comes relational device views processor and many more things okay so after that the next is here this is the device right click there click in so database so here you can see this is the so data then you can get the data of emp and here this is the describe and generate sql query so this is the sql query so right click then you can see here execute sql so just removing where condition then after right click then you can here execute sql so you can get the according to the skill query you can get 30 dollars after that the next to the best thing about though so here i'm going to discuss the best to think about so this is now sql query so if you write here select so if you press s then you can get here so many options oracle select rows oracle drop store procedure many more things and if you select this one press enter then you can here get the drop procedure this all like this if you write your sc at e30 then you can get here with the select so many things so select then from here you can get the hints start the address all this is particular columns that comes so local many more you can get here so let's use here start then you can get your local again this if i use your f then you can get from floor so many things page file so many things okay so this is the best thing about the oracle sorry visual studio code then you can get so many helping things there so let's use a select star form so selecting bonus so here bonus that come press enter after that right click then execute sql then you can get the data of bonus status and automatically it's query that comes so selected there selected that all the columns here so this is the way we can connect to oracle with the visual studio code okay so i hope guys this video is still helpful for you so now this video is over so thanks for watching see next week thank you

Channel: Adam Tech

Views: 40,113

Keywords:

Id: ECL4gg85b9U

Length: 4min 55sec (295 seconds)

Published: Mon Jun 06 2022