#08 Basics of working in PL/SQL Developer
In today's lesson, we will look at the basics of working in a convenient, functional and fast visual development environment PL/SQL Developer, as well as the main pros and cons of using this environment.
Video time codes:
00:00 Introduction
00:30 Conditional cons of PL-SQL Developer
02:12 Installing the program
03:04 Connecting the Oracle client
03:54 Setting up a list of frequently used connections
05:05 Setting up and using hot keys
06:23 Setting up and using text autoreplacement
07:32 Main elements of the program interface
08:49 Launching (executing) SQL code, building a query plan, Commit and Rollback
10:05 Basic functionality of the context menu
10:23 Code autoformatting
10:42 Working with tables through the context menu (Properties, Describe, View, etc.)
11:52 Editing data in the query result output window
12:27 Single record view mode
12:54 SQL command execution log and error highlighting in the code
13:43 Working with a list of tables and other database objects
14:32 Running SQL code with variables
15:00 Exporting the obtained result to a file
16:11 Importing data into the database from a text file
16:40 Viewing current sessions
17:16 Generating random data
18:16 Recording and using macros
19:21 Bonus for channel subscribers
Official website of PL-SQL Developer: https://www.allroundautomations.com/p...
Program download page: https://www.allroundautomations.com/p...
Download page of the "User-defined Text Export" plugin https://www.allroundautomations.com/p...
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 group in Telegram, in which I answer all questions of participants online, help during the training.
Entrance to the group is free, by 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 turned out great. Something did not work out, write a question in the group. I will answer everyone and help.
Link to the group in Telegram: https://t.me/joinchat/LlHDMBmN0SAxM5_...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
★ Dear friends! If you like what I do and 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
#SQLTraining #SQLCourses #SQLLessons #CookMaxim #ExcelStore