Жыл бұрын
2 жыл бұрын
3 жыл бұрын
3 жыл бұрын
4 жыл бұрын
4 жыл бұрын
Пікірлер
@rostislavzidek2275 6 күн бұрын
can I run query within the same session as the debugger have? like i want to see global temporary table contents at certain phase?
@JeffSmiththat 4 күн бұрын
could you not just add a watch for your GTT?
@rostislavzidek2275 4 күн бұрын
@@JeffSmiththat you can add. But it will evaulate as "?"
@temirtaragay8932 16 күн бұрын
How you explain makes huge difference. Thank you!
@JeffSmiththat 13 күн бұрын
Thanks! I do try to make things easier :)
@GuerreroSUD 17 күн бұрын
Hello Jeff, the extension is excelent, but.. How do I make it so that when I format the SQL document, the keywords are in uppercase?
@JeffSmiththat 13 күн бұрын
We're publishing an update (maybe this week??) where you'll get extension settings to set formatter rules, including how to treat case for keywords (and identifiers)
@siddharthbouddha 18 күн бұрын
it can't filter data from the result sheet :(
@JeffSmiththat 13 күн бұрын
not YET - for the moment, rerun the query with the desired WHERE or HAVING clauses
@kudachbolous 18 күн бұрын
Hi every one, How can i get the report tab? Please
@JeffSmiththat 13 күн бұрын
View > Reports if that doesn't work, try Window > Reset Windows to factory settings
@kudachbolous 12 күн бұрын
@@JeffSmiththat Thanks!
@ishaan12vlog 20 күн бұрын
How to remove <<¶
@JeffSmiththat 13 күн бұрын
In preferences disable the 'show whitespace characters', it's under code editor > display
@sandeeptanjore1253 Ай бұрын
Hello Jeff - Thanks for the teaser or information presented about integrating Oracle with VS code. Just wondering if we can use this extension in VS code to debug anonymous blocks or a package/procedure/function? The way we use TOAD or PL/SQL Developer IDE to debug an object, can the same be accomplished by installing the Oracle SQL , PL/SQL extension on VS code?
@JeffSmiththat 27 күн бұрын
very soon, yes
@adeelraza-ej1yr Ай бұрын
Thanks very helpful. FYI: although you used sqlplus but how to install and make it work in the host OS?
@JeffSmiththat 27 күн бұрын
I normally use SQLcl not SQLPLUS, but the same on the host OS assuming you have a port forward, simply run sql hr/oracle@localhost:1521/freepdb1
@dmitryoleynik3710 Ай бұрын
@JeffSmiththat Hi Jeff, Could you write a link to regular expression version used in SQL Develop? I mean just Search and Search and Replace in Editor. I'm tired to find something worth
@JeffSmiththat Ай бұрын
When you open the find/replace dialog, on the toolbar is a button that looks like .* Toggle that 'on' - and then you can use regular expressions
@JeffSmiththat 2 ай бұрын
Note that our install/upgrade process changed in 2022, and I haven't had time to post an updated video. Here's a blog post that shows the latest, and includes slides www.thatjeffsmith.com/archive/2022/04/oracle-rest-data-services-version-22-1-read-the-readme/
@NirajKumar-fb7sq 2 ай бұрын
Hello Jeff sir, I installed Oracle database 21c and Oracle SQL developer 23.1.1 but after creating table & inserting data in Oracle SQL developer 23.1.1, I could not be able to see it through Oracle database 21c. please help me why this is happening.
@NirajKumar-fb7sq 2 ай бұрын
using SqlPlus command terminal i can't access the data and vice-versa.
@JeffSmiththat 2 ай бұрын
Did you COMMIT your INSERTs?
@NirajKumar-fb7sq Ай бұрын
@@JeffSmiththat yes sir now it's working. Thankyou
@rodneychan1227 2 ай бұрын
I noticed in another video introducing VS code Oracle Developer extension you can drag and drop a database connection detail into a python notebook file and code was auto generated (kzbin.info/www/bejne/m17cop5_ZdlpmrM) - Is there a setting somewhere I need to configure to allow this to happen? As I just tried this and wasnt able to get it to work.
@JeffSmiththat 2 ай бұрын
No, that's something we're currently working on, and are going to release later this year.
@RajKumar-cz5ok 3 ай бұрын
hey jeff , nice intro about ords, my client is using ords with servicenow . I need to pass the custom parameter in the query. Could you point me in the direction where i can check the how to pass query parameters with and or conjuction.
@JeffSmiththat 3 ай бұрын
Here's an example www.thatjeffsmith.com/archive/2024/05/searching-json-arrays-with-json_exists-and-rest-apis/ If that's not what you're talking about/looking for - try to give me an example of what you're trying to achieve
@edwinyulianto3660 4 ай бұрын
Compared to the standalone Oracle SQL Developer, the VSCode version has the following issues: - It is quite frustrating that the connection frequently breaks after a short period (DBTS-05102: The connection session was terminated). When this happens, you cannot use the currently opened SQL Worksheet and must open a new one. While with the standalone version usually I use KeepLive extension without hassle losing connection. - Querying data is slower than in the standalone version.
@JeffSmiththat 4 ай бұрын
Something is killing your connection, and it's not the extension. If you want your connection to remain active, you need to keep doing work. If the connection is died, the reconnect should work, once the connection has been reset, you should be able to start using your worksheet again. When you say 'slower' can you provide some details?
@shanawazali6161 4 ай бұрын
Please provide me refrence I have 3 year plsql developer
@JeffSmiththat 4 ай бұрын
Sorry, i can only provide a reference for people that I both know and have personally worked with.
@shanawazali6161 4 ай бұрын
@@JeffSmiththatokay,then u can also involve me in your team
@JeffSmiththat 4 ай бұрын
@@shanawazali6161 look for Kris Rice or myself posting open job listings, hosted on oracle.com or eeho.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/jobsearch/requisitions
@shanawazali6161 4 ай бұрын
@@JeffSmiththat thnks for sharing valuable information,but mostly position required minimum 6 year experience
@benyu8704 4 ай бұрын
Thanks Jeff for the very informative introduction. The Oracle SQL Developer extension for VS Code is getting better and better. The integration of query window with sqlcl terminal is really exciting.
@JeffSmiththat 4 ай бұрын
Thanks! We're reading our next update now, and will offer even more features, stay tuned!
@cathrerinezetadrones3169 5 ай бұрын
I would love better support for git with oracle and this seems like the perfect place to improve it
@JeffSmiththat 5 ай бұрын
We have a lot planned in this area, stay tuned!
@ZafarIqbal9922 5 ай бұрын
اس ایکسٹینشن کو میں نے وی ایس کوڈ میں استعمال نہیں کیا تھا۔ لیکن آپ نے بہت اچھی وضاحت کی ہے تو سب سمجھ آ گیا ہے۔ شکریہ
@JeffSmiththat 5 ай бұрын
آپ کی رائے کا شکریہ! مجھے خوشی ہے کہ آپ نے یہ مفید پایا۔
@daveyt88 5 ай бұрын
Thank you for the video! Is possible to import connections from SQL Developer?
@JeffSmiththat 5 ай бұрын
Yes! Follow the steps here: www.thatjeffsmith.com/archive/2024/01/how-to-import-connections-from-sql-developer-to-vs-code/
@MilanPetrovicM 5 ай бұрын
Looks awesome!
@JeffSmiththat 5 ай бұрын
Thanks Milan! Let me know if you have any questions!
@docflexis9052 5 ай бұрын
Hi Jeff my Oracle Apex GO button is disabled .Kindly guide me on how to enable it.
@JeffSmiththat 5 ай бұрын
Did you install apex, and then install ORDS? ORDS when it is installed/configured, should see that APEX is there, and auto set itself up to support it. if you go to ords/apex instead of ords/ - does it bring up APEX? Do you see any error messages as the ords startup routine runs?
@docflexis9052 5 ай бұрын
@@JeffSmiththat Yes I did install Apex first then followed by ORDS. However that is sorted now. I am getting a new error after clicking the GO button. This is the error: Not Found HTTP Status Code: 404. The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured.
@JeffSmiththat 5 ай бұрын
See my other questions in previous reply @@docflexis9052
@spandangude8973 5 ай бұрын
nice vid
@MrZtapp 5 ай бұрын
For someone that is really a novice in this area I must say that is is a VERY good video. Thanks.
@JeffSmiththat 5 ай бұрын
Ah thanks Mr Z! That's very nice of you to say, and also nice to hear!
@Praveenkumar-of7zf 6 ай бұрын
Can we Install Oracle in Mac M1 2020 directly without using any virtual machine?? if yes please suggest...!!!
@JeffSmiththat 5 ай бұрын
There is currently no OS X port of the database. We do have LINUX ARM on 19c, which means running it on your M1 via a linux container or VM should be easy.
@Zifoxpiohmte 6 ай бұрын
pls coment some translate
@JeffSmiththat 5 ай бұрын
what do you need?
@Maryam-eb1fn 6 ай бұрын
i have implemented it and still i am not getting suggestions for column names. i only get it for table name. i am using version 23.1.1.345 . if anyone has a solution i would be thankful.
@JeffSmiththat 5 ай бұрын
Maryam, can you provide an example? Are you using an alias for the table or view you are querying? Does it help if you type the first few letters of the column? How about if you press ctrl+spacebar to force the completion to run again?
@uprvrndn 7 ай бұрын
How would I setup and test Oracle wallet with Splunk DB connect?
@JeffSmiththat 7 ай бұрын
You want Splunk to talk to Oracle or Oracle to talk to Splunk? REST APIs is probably the easiest path.
@sandeepkumar-h8b1w 7 ай бұрын
is this video for freshers or for working professionals >>>>>>>?????
@JeffSmiththat 7 ай бұрын
Yes!
@sandeepkumar-h8b1w 7 ай бұрын
Hello Jeff im kanna here, where can i found this folder first and im usng oracle sql 11g am not getting a page like what to do and where i can find this all help me )-:🤕
@JeffSmiththat 7 ай бұрын
Which folder are you looking for?
@jonnathanjon1 7 ай бұрын
Hello I need clarity, Can we use sql developer tool to build sql without writing sql statements like Hyperion interactive reporting (Brio)? if that is possible, what's the latest or the best version available to connect to DB2 to pull records? appreciate your answer..
@JeffSmiththat 7 ай бұрын
This video you're commenting on shows how to browse data w/o writing actual SQL - by drag and drop. It's only for Oracle, not for IBM DB2.
@delisepalumbo6760 7 ай бұрын
i would like info on your white papees on Oracle migration.
@JeffSmiththat 7 ай бұрын
Most recent of mine is this - www.oracle.com/us/products/database/migrating-to-oracle-database-wp-3610526.pdf
@apsin4560 8 ай бұрын
Hi Jeff, can it connect to Oracle Fusion cloud ERP database ? If not then why not? I see now we have 3rd party plug-in/tools in the market which allow connection to cloud ERP.
@JeffSmiththat 8 ай бұрын
IF that database is made available to us, yes of course. It's just that normally database access for SaaS offerings is not included. This isn't a technical issue, it's a business one. Those 3rd party tools aren't really connecting to the database, by the way.
@venkatamaddineni6297 8 ай бұрын
Why there is no SQL developer app on ui which you got at 12:13...how to access that?
@JeffSmiththat 8 ай бұрын
Not sure what you mean, that's just SQL Developer with the Connections and DBA panels open/active.
@diogosiqueira1349 9 ай бұрын
Thank you so much Jeff... I was looking for it for hours and I found it here... Thank.. have a great 2024
@marcdeveaux8925 9 ай бұрын
Great video, thank you!
@JeffSmiththat 9 ай бұрын
Glad you liked it!
@LennieLenford 10 ай бұрын
This video is over five years old but is still linked to from SQL Developer, is it still relevant? (Just upgraded from version 4...)
@JeffSmiththat 10 ай бұрын
Yes, I think so at least. Most people don't get beyond running 'select * from employees' and exporting query results to Excel. I plan on updating this video once our Extension for VS Code has been released.
@jasonabdi1 10 ай бұрын
🎯 Key Takeaways for quick navigation: 00:01 🧐 *Query Builder Overview* - Introduction to the Query Builder feature in SQL Developer. - Query Builder interface reminiscent of Microsoft Access for building queries. - Comparison with manual SQL statement writing. 02:11 🔄 *Switching to Query Builder* - Demonstrates the process of converting a manually written SQL statement to the Query Builder interface. - Explains the importance of referential integrity for the Query Builder to work effectively. - Highlights the ability to visually define columns from tables in the Query Builder. 03:29 🔄 *Interactivity Between Worksheet and Query Builder* - Shows the seamless interaction between the Query Builder and the worksheet. - Modifying the query in the Query Builder reflects changes in the worksheet. - Running queries from the worksheet based on modifications made in the Query Builder. 04:19 🎯 *Advanced Query Customization* - Discusses additional features in the Query Builder, such as adding aliases, applying aggregates, and sorting. - Demonstrates the process of adding criteria to filter data in the Query Builder. - Explains the default table aliases and how to customize them. 05:46 ⚙️ *Time-Saving with Query Builder* - Emphasizes the time-saving aspect of the Query Builder, especially for complex queries with multiple joins. - Illustrates building a query with multiple tables using the Query Builder. - Highlights the efficiency of the Query Builder for users dealing with numerous table joins. 07:42 🚀 *Query Builder Use Cases* - Discusses use cases for the Query Builder, especially for users new to Oracle and databases. - Advocates for Query Builder as a tool for those who struggle with manual SQL but understand tables, columns, and relationships. - Acknowledges personal preference for manual query customization beyond the initial Query Builder skeleton. Made with HARPA AI
@JeffSmiththat 10 ай бұрын
It takes longer to read the AI generated comments to my video than it would take to actually watch my video.
@topek1196 11 ай бұрын
how to create a new database in 23c?
@JeffSmiththat 10 ай бұрын
How do you mean? Do you mean a new pluggable database in an existing 23c Container instance, or do you mean a brand new database from scratch? Nothing has changed here from either 19c multitenant or 21c.
@johnhurt888 11 ай бұрын
Hi Jeff, in SQL Developer can you make the model tab, "walk" the dependency list more than 1 step up and down? Like 2 steps to see more "distant" relations?
@JeffSmiththat 10 ай бұрын
No, but if you create a new design in full blown Data Modeler, it'll grab as much data as you give it, one or more levels, no problem.
@mohamedheba173 Жыл бұрын
Hi Jeff, I am using lb generate-schema -split to extract all changes related to a schema in a source oracle DB. and before running this command I set DDL off for STORAGE, PARTITIONING, SEGMENT_ATTRIBUTES, TABLESPACE, EMIT_SCHEMA and SIZE_BYTE_KEYWORD. after export finished i find that indexes xml file contains all information related storage and all other INDEX_ATTRIBUTES. the problem is when i try to update destination schema "In a different DB" i receive error "ORA-02203: INITIAL storage options not allowed". I notices when I use command LB GEO -OBN INDEX_NAME -OBT INDEX, xml generate without storage attributes and the update complete successfully. is there any option to avoid storage and index attribute in generate schema command?
@JeffSmiththat Жыл бұрын
I'm currently hunting down this bug, for some reason the DDL settings aren't equally being honored between generate-schema and generate-object. Your expectation of the behavior is correct, we're not doing something right. Stay tuned.
@mohamedheba173 Жыл бұрын
@@JeffSmiththat Thank you for your reply, I was using sqlcl version 23.2 when i found this issue, i downgraded to version 22 but I can still find the same issue. is there any recommended version i can use?
@JeffSmiththat 10 ай бұрын
Turns out this is how it's supposed to work, when you do the UPDATE, set your sqlformat settings, and it'll honor those. See this blog post www.thatjeffsmith.com/archive/2023/10/sqlcl-liquibase-physical-properties-for-oracle-tables/ We're looking at making this work in either direction for a future update.
@mohamedheba173 10 ай бұрын
@@JeffSmiththatThanks a lot for your reply. Yes, I used to set the sqlformat during UPDATE but SQLcl still ignoring it and raise errors.
@JeffSmiththat 10 ай бұрын
@@mohamedheba173 I need an example and more details [email protected]
@neeleshshah Жыл бұрын
Has anyone run VirtualBox in Mac OS running in Apple Mx chipset successfully?
@JeffSmiththat Жыл бұрын
Any VirtualBox? I'm sure. This particular appliance? I do not know. I would loo at 19c ARM we put out a few days ago, and then put that in a VM on your fancy Mac.
@Revanth2344 Жыл бұрын
Please help...😢 How to solve : ORDS_VERSION Does not exist error : ORA-01031 : insufficient privileges
@JeffSmiththat Жыл бұрын
Sorry for late reply! What are you doing when you get this message/error?
@sri6137 Жыл бұрын
Ords is generating output in json format. How to get output in xml format
@JeffSmiththat Жыл бұрын
Write SQL that generates XML and use the Media Resource option for your Handler blocks. I have an example here www.thatjeffsmith.com/archive/2021/04/oracle-rest-apis-and-your-xml/
@Revanth2344 Жыл бұрын
Hi jeff, In my server ords 19 is already installed and I'm unable to find the params folder (ords.parameters). As I'm trying to install new ords in same server it doesn't prompt for admin credentials.. results in ords_grant_priv.sql script error... ORDS_METADATA created but it is unable to get grant permission.. But ords got installed, app url is up for sometime and goes down again, when refreshes page it is coming up and again going down after sometime... Please guide on this issue 🙏
@JeffSmiththat Жыл бұрын
You need the SYS user to do a proper install/upgrade. "But ords got installed, app url is up for sometime and goes down again, when refreshes page it is coming up and again going down after sometime..." When it goes 'down' - what do you see in the ORDS server logs?
@Revanth2344 Жыл бұрын
I'm using aws rds , we can't alter or use SYS USER. ONE MORE THING Ords 19.2.0 installed and hosted in Tomcat server but there are no metadata and public users And there is not ords admin or runtime role in database.. My question is without those users and role in database how the application is working
@JeffSmiththat Жыл бұрын
RDS has very specific instructions.
@harikakuladevisreenivasa Жыл бұрын
thanks a lot for the video
@JeffSmiththat Жыл бұрын
No worries!
@MikeCarey101 Жыл бұрын
Is there a way to tell QB how to name the table alias? My database uses xxx_auto_key for all the indexes and foreign key names. The standard is to alias the table with the 3 letters from its primary key.
@JeffSmiththat Жыл бұрын
Yes, right click on the table, in the properties, set the ALIAS.
@Renato78100 Жыл бұрын
Ok, but which is the practical functionality this?
@JeffSmiththat Жыл бұрын
Some devs hate the SQL they are given, this helps you make it the way you prefer.
@binilarussel Жыл бұрын
hey thanks for the video. You used a csv file to import, not excel. Do you have a video on this specifically? Thanks
@JeffSmiththat Жыл бұрын
It's exactly the same. Just make sure your XLSX file doesn't have macros/pivot tables, etc - you want a workbook/worksheet with JUST the data in it.
@binilarussel Жыл бұрын
@@JeffSmiththat great! I’ll try that. Thanks for your reply.
@samuelhailemichael453 Жыл бұрын
Hi Jeff, Will there be a version of this product that is supported by M1/M2 chip Mac computers?
@JeffSmiththat Жыл бұрын
To be determined.
@aligat2311 Жыл бұрын
Thanks a lot for this demo
@JeffSmiththat Жыл бұрын
You're very welcome!