My mind was blown several times watching this video. Thank You!!!

@DatabaseStar

2 жыл бұрын

Glad you enjoyed it!

Im starting my first IT job as a PL/SQL developer and this video is a life saver, Thank you!!

@DatabaseStar

Жыл бұрын

Glad it was helpful!

@deepakmandal161

4 ай бұрын

I know SQL cmd,PLSQL cmd ,oracle sql,MySQL ,postgresql what other skill should have to work in PLSQL developer??

@deepakmandal161

4 ай бұрын

What exactly you do in company ???and how??

Finally found about block selection which I needed them early!

@DatabaseStar

2 жыл бұрын

Great, yeah it's a helpful feature!

CRazy how one can use a product for many years and never fully know it. You have given me some helpful insights, thank you

@DatabaseStar

Жыл бұрын

Glad it was helpful!

You made me fall in love with SQL. Thanks a lot

@DatabaseStar

2 жыл бұрын

Happy to hear that!

I wish I knew block selection years ago. So many years spent adding ',' to each line or using notepad to replace or excel to create the columns etc. Blown away

@DatabaseStar

Жыл бұрын

Yeah it's very handy! I use it in several other editors.

Thank you, very much appreciated 🙏

@DatabaseStar

2 жыл бұрын

Glad you like the video!

Thank You Sir for tips and Tricks 👍

@DatabaseStar

2 жыл бұрын

Glad you found them useful!

Very useful information, Gracias for content..

@DatabaseStar

2 жыл бұрын

Thanks!

VERY USEFUL VID, THANKS SR

@DatabaseStar

Жыл бұрын

You're welcome

very very informative thanks alot.

@DatabaseStar

2 жыл бұрын

Glad it was helpful!

really good tips. I'm also looking for some tip to keep the code format when copying and pasting and also keeping the colors in SQL editor. I looked for it hardly but it seems to be a feature that does not exist. I heard Toad has a setup where you copy using Rich Text. In case you know anything please also share.

@DatabaseStar

Жыл бұрын

That would be ahelpful feature. I'm not sure how to do it unfortunately!

usefull tips thank you dear

@DatabaseStar

2 жыл бұрын

Thanks!

One feature you’d like is improved backup. It has become very simple to spare your work in the tool. Before this patch we were developers were permitted to save around hundred articulations as a matter of course. But now you set aside to 500 explanations in the addition to the new feature of Oracle DB, cloud services has improved the transferring information.

@DatabaseStar

9 ай бұрын

Thanks, that's good to know!

Thanks a lot! Is there a keyboard shortcut to hide the result grid, Like the Microsoft SQL Server Management Studio's Ctrl+R?

@DatabaseStar

Жыл бұрын

Good question, I'm not sure. There's a list of keyboard shortcuts currently in SQL Developer in the Preferences window, and you can set a shortcut if it's in the list and none is applied.

@JeffSmiththat

Жыл бұрын

you can do it via keyboard, but not easily, def not with a single keystroke. Limitation I hope to have fixed with our new version of SQL Dev coming later in 2023.

Thanks.

@DatabaseStar

Жыл бұрын

No problem!

How do you extract results (including the column names) from a stored procedure which output is a sys refcursor?

@DatabaseStar

Жыл бұрын

Oh I'm not sure. I haven't worked with sys refcursors very much recently.

Hi, Thanks for the awesome tips. I am trying to duplicate the connection window on the left. Is it possible? Basically, I am trying to open multiple packages and tables in parallel and currently with 1 connection window, I have to scroll to packages and tables list each time.

@DatabaseStar

13 күн бұрын

Hmm I'm not sure if you can actually. You can open multiple packages at once, in different tabs, but you would have to scroll the list each time.

Nice video

@DatabaseStar

Жыл бұрын

Thanks!

Amazing video.. Thanks.. Pls make one for pgadmin too..

@DatabaseStar

Жыл бұрын

Thanks! Good idea.

Do you have tips on exporting queries faster?

@DatabaseStar

Жыл бұрын

Exporting the results of queries? Not that I know of. There may be a command to save the results of a query to a text file or CSV file in SQL but I don't know off the top of my head.

@JeffSmiththat

Жыл бұрын

When you export the results, the application runs the query again. If you want to avoid this, return all the results from the query BEFORE you do an export.

sql developer is real pain whenever you import/export huge data especially into excel/csv format. it literally hangs and locks everything - crazy.

@DatabaseStar

2 жыл бұрын

Yeah, I've found it can be slow when doing this. That's annoying that it locks :(

@JeffSmiththat

Жыл бұрын

if it's a huge file, always convert it to CSV first, and then the memory footprint and CPU requirements will be a FRACTION of what they'd be otherwise.