#14. Basics of working with SQL Plus (part 1)
In today's lesson we will talk about SQL Plus - a console program for working with Oracle DBMS via the command line.
00:00 Start
00:14 The main purpose of SQL Plus
01:49 Installing SQL Plus on Windows
03:19 Starting SQL Plus
04:20 Setting up Cyrillic display in SQL Plus
05:28 Connecting to a database from SQL Plus
06:36 Working with SELECT queries in SQL Plus
08:44 Setting up SQL Plus parameters (STORE SET, LINESIZE, PAGESIZE)
11:42 CREATE TABLE, INSERT, and DROP TABLE commands in SQL Plus
13:20 Shutting down SQL Plus
13:26 Conclusion
SQLPLUS download pages from the Oracle website:
x32 - https://www.oracle.com/database/techn...
x64 - https://www.oracle.com/database/techn...
SQL commands mentioned in the video are available at the link: https://pastebin.com/TGb8NaVT
Suggest a new topic for the video: https://vdsr7ufo2in.typeform.com/to/H...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Also, let me remind you. As part of this course, there is a Telegram group in which I answer all participants' questions online and help them along the way.
Entrance to the group is free, via the invitation link (indicated below). There is currently no limit on the number of participants.
In the specified group, ask absolutely any questions, as part of our training. Watched the video, tried to repeat. It worked out - great. Something didn't work out, write a question to the group. I will answer and help everyone.
Link to the group in Telegram: https://t.me/joinchat/LlHDMBmN0SAxM5_...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
★ Dear friends! If you like what I do and you want to support the project financially, link: https://excelstore.pro/thanks-author....
★ Let's be friends:
Facebook | / excelstore.pro
Vkontakte | https://vk.com/ExcelStore
Telegramm | https://t.me/ExcelStore
#SQLPlus #SQLTraining #SQLCourses #SQLLessons #CookMaxim #ExcelStore