14 Replies Latest reply on Jun 18, 2020 9:33 AM by Phil W

    Autocomplete

    Phil W

      I've used PL/SQL Developer for years as it is superior in many ways to SQL Developer (sorry just my opinion).

      Recently, I've looked at SQL Developer as it has come on a fair bit but simple, time saving elements still don't seem to work unless I am missing a trick.
      One is autocomplete so that if I type

        INSERT INTO TABLE_NAME(

      and wait a few seconds, a list of columns followed by all will allow me to enter all column names delimited with commas automatically.

       

      Is this possible yet please?

        • 1. Re: Autocomplete
          thatJeffSmith-Oracle

          No worries, in my opinion, we are superior in almost every way

           

          Yes, you can do what you're looking for here

           

           

          then you just need to finish off the ')'

           

          1 person found this helpful
          • 2. Re: Autocomplete
            Peter2_1

            You can also consider the drag&drop of tabels to the workssheet and the following dialogue which offers you insert, delete, join, select, ......

            2 people found this helpful
            • 3. Re: Autocomplete
              RogerT

              Tools - Preferences - Code Editors - Completion insight

               

              and there enable at least Auto-Popup in SQL Worksheets

               

              after having written the opening bracket just wait a short time, select the columns you need - the order you are picking them is the order you'll find them in the list - and there you go.

               

              hth

              • 4. Re: Autocomplete
                Phil W

                Thanks all - well maybe superior but this just doesn't work as well for me.
                I've switched it on and increased the number of suppressed popups to 200 but the following for example, just does nothing after x seconds, or pressing CTRL Space

                 

                select apex_util.prepare_url(

                 

                I know I want the 1st and 3rd parameter here but will have to look it up as I can't recall their names exactly

                • 5. Re: Autocomplete
                  Phil W

                  Sorry Jeff, I'm afraid it just doesn't seem to work intuitively

                   

                  I created a new worksheet and typed this in select apex.util.

                  Shortly after the dot I got the package procedures and functions so typed some more and then pressed down to prepare_url. The apex_util package name gets replaced

                  • 6. Re: Autocomplete
                    thatJeffSmith-Oracle

                    ugh, i see what you mean, that's definitely a bug

                     

                    explicit test cases help a lot here, thanks for that example

                     

                    I'll file a bug, but unfortunately it comes too late to have a fix included in version 20.2 (most likely)

                    1 person found this helpful
                    • 7. Re: Autocomplete
                      Mike Kutz

                      Peter2_1 wrote:

                       

                      You can also consider the drag&drop of tabels to the workssheet and the following dialogue which offers you insert, delete, join, select, ......

                      Don't forget to hit CTRL-F7 for the ever important "Format your code".

                      • 8. Re: Autocomplete
                        Vadim Tropashko-Oracle

                        The apex_util is a synonym for HTMLDB_UTIL. Try

                         

                        select HTMLDB_UTIL.prepare_url(

                         

                        This bug has been fixed for 20.2

                        • 9. Re: Autocomplete
                          Phil W

                          Vadim - I did find a bug for this but this thread mentions nothing about that!

                          • 10. Re: Autocomplete
                            Vadim Tropashko-Oracle

                            Phil, to remove possible confusion, can you please reformulate what issue you didn't find an answer in this thread? Please refrain from referring to the previous posts, even if you have to repeat yourself.

                            • 11. Re: Autocomplete
                              Phil W

                              Original message:

                               

                              >>

                              I've used PL/SQL Developer for years as it is superior in many ways to SQL Developer (sorry just my opinion).

                              Recently, I've looked at SQL Developer as it has come on a fair bit but simple, time saving elements still don't seem to work unless I am missing a trick.
                              One is autocomplete so that if I type

                                INSERT INTO TABLE_NAME(

                              and wait a few seconds, a list of columns followed by all will allow me to enter all column names delimited with commas automatically.

                               

                              Is this possible yet please?

                               

                              Plenty of responses and then Jeff Smith reported this was a bug. Issue closed.

                               

                              Then you replied to this thread with something on another thread - not sure adding details on that thread here will make anything clearer

                              1 person found this helpful
                              • 12. Re: Autocomplete
                                Peter2_1

                                for the first original question here, not for the apex_util stuff ..

                                --------------------------------

                                This works for me

                                • Type "insert into my_table ("                   -- with or without blank before the bracket
                                • press Ctrl+Space
                                • a list with the relating columns is displayed (see screenshot above)
                                • select one or more entries (with mouse and with CTRL or SHIFT - like multiple file selection in Explorer)
                                • press ENTER
                                • -> selected columns will be added beehind the opening bracket
                                • 13. Re: Autocomplete
                                  Mike Kutz

                                  Phil UK wrote:

                                   


                                  Then you replied to this thread with something on another thread - not sure adding details on that thread here will make anything clearer

                                  As I re-read the tread, it looks like:

                                  • Jeff's response (post 6) was in reference to your posts (post 4 and 5) regarding the CTRL-SPACE autocomplete feature wasn't working for your test of APEX_UTIL; he confirmed that the Autocomplete did not work because it was a (undiscovered) bug.
                                  • Vadim's response (post 7) seems to re-confirm Jeff's "it is a bug" reply; it states why the bug exists (synonym), workaround (use actual package name), and when the bug will be fixed ( v20.2)

                                   

                                  MK

                                   

                                  PS - my reply (post 7) was to inform you that there is another feature of SQL*Developer (code formatting) that I think you should try out.  It is highly customizable.

                                  I'm also going to suggest that you check out the "custom code highlighting" feature too. I use it for "Code Sniffing" of the code I have to review. (eg highlight WHEN OTHERS THEN NULL code, TO_DATE with 1 parameter, etc)

                                   

                                  PPS - make sure you check out Jeff's Blogs - https://www.thatjeffsmith.com/sql-developer/

                                  • 14. Re: Autocomplete
                                    Phil W

                                    Sorry but there is no connection between the two. They are different posts.

                                    Oracle's forum is a pretty poor so it might be this causing the issue?

                                    Also, for a company that specialises in search, why would you conduct a search per keystroke amazes me from a performance perspective. Many years ago, this was superior than it is now.