Oracle Database Actions (SQL Developer Web) Tour: 2021 Edition

Подписаться 9 тыс.

Просмотров 4,6 тыс.

50% 1

Here's a complete tour of your web interface for the Oracle Database, from running queries, building relational diagrams, loading data, building REST APIs, working with JSON, performance monitoring, and creating database users.
'Chapters' -
+ SQL worksheet 2:45
+ Opening TABLEs ('slider') 11:52
+ Importing data to a new table 16:50
+ Drag and Drop tables/plsql to generate code 20:14
+ Converting a SQL statement to a Chart 22:35
+ Data Modeler and relational diagrams 25:30
+ REST API Development and Testing 28:15
+ JSON Collections & Documents 34:24
+ Charts 39:45
+ Creating Database users 41:47
+ Instance Viewer 44:07
+ Performance Hub 45:58
+ Session Browser 47:14

Наука

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@b_rizzle4808 3 года назад

is there an aggregation type in that chart maker?

@JeffSmiththat 3 года назад

No, it just defaults to sum, so best to do the aggregation in the SQL

@chadlomax4500 2 года назад

Hello and Thank you Jeff, By default the only account I can get to Database Actions on ATP is my admin account. I tried granting roles and web access to the user but to no avail. Do you now how to get a user other than admin to access Database Actions?

@JeffSmiththat 2 года назад

Use the admin - users panel, and the web access slider for your user

@chadlomax4500 2 года назад

@@JeffSmiththat That does not work for me my man. I'll try to figure this out. Thanks.

@JeffSmiththat 2 года назад

What happens when you try?

@JeffSmiththat 2 года назад

@@chadlomax4500 like, db username, did you provide an alias in the advanced properties, and did you get an error when you use their direct link (from user card).

@chadlomax4500 2 года назад

@@JeffSmiththat Boom. Thank you for following up. So, Web Access was already checked. My problem was not taking the alias into account. Now, I go do database actions => alias as username => then normal login username and password.

@Anonymousvlogger1 2 года назад

Hi Jeff, Is there any way to find all database names in Oracle ?

@JeffSmiththat 2 года назад

A database has a service name or SID...what do you mean by 'database names?'

@Anonymousvlogger1 2 года назад

@@JeffSmiththat I mean to say that, I just want to know which / how many databases are currently installed on my machine

@Anonymousvlogger1 2 года назад

Ca we search it using any specific SQL queries ?

@Anonymousvlogger1 2 года назад

@@JeffSmiththat you are right... Just service names will aslo be fine... But it should show for all databases Is it possible ?

@JeffSmiththat 2 года назад

@@Anonymousvlogger1 if they're running you can check the OS processes, each should have a PMON running for example SQL is ran in a database, so if you're asking about databases on your machine, that's not going to get answered with SQL. There is an exception..if you're using Oracle Multiteneant you could have multiple pluggable databases, then you could query dba_pdbs for a list of those in your container database.