1 2 Previous Next 20 Replies Latest reply on Jun 22, 2018 10:59 PM by 3730927

    Completion Insight SQL Developer Version 18.1.0.095

    3730927

      Hi,

       

      I am new here and this is my first post.

       

      I am attempting to become more familiar with Oracle SQL Developer and am having issues with the Completion Insight utility.  I feel like this should be an easy thing to figure out but can't find the solution.

       

      Version 18.1.0.095

      Build 095.1630

       

      Settings:

      In tools -- > preferences -- > completion insight:  I have everything checked, popup speed lowered to .1 seconds, and suppressed results set to 100.

       

      Issue:

      I have a table called entity.  In that table is a column called id_number.  When I either let the columns self-populate or when I hit cntrl_space, the full list of columns is not displayed.  Instead the list ends in an ellipses and I have to click it to then refresh the list to see id_number as an option.  Once I hit the ellipses ALL of the missing columns appear (there are multiple columns missing from the full list).  Screen shot below (the ellipses I am referring to is at the bottom of the displayed columns):

       

       

      We have been using PL/SQL Developer.  In that software when you attempt the same action, it gives you a pop-up organized by the order in which the columns appear and you can quickly click on the one you want from the table.  Screen shot below:

       

      Is there another setting I need to tweak or is this not an option within the software?

       

      Thanks,

       

      Greg Kelly

        • 1. Re: Completion Insight SQL Developer Version 18.1.0.095
          thatJeffSmith-Oracle

          please share the DDL for your table

          • 2. Re: Completion Insight SQL Developer Version 18.1.0.095
            3730927

            I am assuming this is what you want.  Again -- > second day with the software.  Just did a right click on the table -- > quick DDL -- > save to clipboard.  It just seems random for the missing columns. 

             

             

            Here is another screen shot at the top of the return; the DDL follows after that.  I tried even doing select e. from advance.entity e and when I stop after the e. it still gives me the same return as below.  Was thinking it had something to do with not specifying the DB but no luck.  Also tried it without using an alias.  Same results.  Kind of a pain because the software has it alphabetical and the DDL is by column occurrence which is actually what I want to have happen (plus fixing the missing columns from the list).

             

             

             

             

            --------------------------------------------------------
            --  DDL for Table ENTITY
            --------------------------------------------------------

              CREATE TABLE "ADVANCE"."ENTITY"
               ( "ID_NUMBER" VARCHAR2(10 BYTE) DEFAULT ' ',
            "PERSON_OR_ORG" CHAR(1 BYTE) DEFAULT ' ',
            "RECORD_TYPE_CODE" VARCHAR2(2 BYTE) DEFAULT ' ',
            "RECORD_STATUS_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "STATUS_CHANGE_DATE" DATE,
            "RELATIONS_NBR" NUMBER(6,0) DEFAULT 0,
            "QUESTION_RETURN_DATE" DATE,
            "CLASS_AGT_CODE" VARCHAR2(15 BYTE) DEFAULT ' ',
            "XCOMMENT" VARCHAR2(2000 BYTE) DEFAULT ' ',
            "PREF_ADDR_TYPE_CODE" VARCHAR2(2 BYTE) DEFAULT ' ',
            "PREF_MAIL_NAME" VARCHAR2(60 BYTE) DEFAULT ' ',
            "REPORT_NAME" VARCHAR2(60 BYTE) DEFAULT ' ',
            "ENTITY_SRC_CODE" VARCHAR2(3 BYTE) DEFAULT ' ',
            "SOLICIT_CTRL_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "SOLICIT_CTRL_CHNG_DATE" DATE,
            "SOLICIT_CTRL_DATE" DATE,
            "SOLICIT_CTRL_COMMENT" VARCHAR2(40 BYTE) DEFAULT ' ',
            "ALUM_MAG_MAIL_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "MAIL_CODE1" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE2" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE3" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE4" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE5" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE6" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE7" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE8" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE9" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MAIL_CODE10" VARCHAR2(3 BYTE) DEFAULT ' ',
            "PREF_NAME_SORT" VARCHAR2(60 BYTE) DEFAULT ' ',
            "NAME_CHANGE_DATE" DATE,
            "DIRECTORIES_NBR" NUMBER(6,0) DEFAULT 0,
            "DELETE_IND" CHAR(1 BYTE) DEFAULT ' ',
            "DELETE_MODIFIED_DATE" DATE,
            "DELETE_OPERATOR" VARCHAR2(32 BYTE) DEFAULT ' ',
            "PREF_CLASS_YEAR" VARCHAR2(4 BYTE) DEFAULT ' ',
            "PREF_SCHOOL_CODE" VARCHAR2(4 BYTE) DEFAULT ' ',
            "LAST_NAME" VARCHAR2(25 BYTE) DEFAULT ' ',
            "FIRST_NAME" VARCHAR2(25 BYTE) DEFAULT ' ',
            "MIDDLE_NAME" VARCHAR2(25 BYTE) DEFAULT ' ',
            "PERS_SUFFIX" VARCHAR2(25 BYTE) DEFAULT ' ',
            "PROF_SUFFIX" VARCHAR2(25 BYTE) DEFAULT ' ',
            "INSTITUTIONAL_SUFFIX" VARCHAR2(40 BYTE) DEFAULT ' ',
            "PREFIX" VARCHAR2(25 BYTE) DEFAULT ' ',
            "SALUTATION" VARCHAR2(40 BYTE) DEFAULT ' ',
            "GENDER_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "ETHNIC_CODE" VARCHAR2(8 BYTE) DEFAULT ' ',
            "RELIGION_CODE" VARCHAR2(2 BYTE) DEFAULT ' ',
            "LANGUAGE_PREFERENCE_CODE" VARCHAR2(3 BYTE) DEFAULT ' ',
            "BIRTH_DT" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "BIRTH_PLACE" VARCHAR2(36 BYTE) DEFAULT ' ',
            "CHILDREN_NBR" NUMBER(6,0) DEFAULT 0,
            "DEATH_DT" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "DEATH_NOTIFIED_DATE" DATE,
            "DEATH_CONFIRMED_DATE" DATE,
            "DEATH_PLACE" VARCHAR2(30 BYTE) DEFAULT ' ',
            "DEATH_LETTER_DATE1" DATE,
            "DEATH_LETTER_DATE2" DATE,
            "DEATH_OBIT_CODE" VARCHAR2(2 BYTE) DEFAULT ' ',
            "DEATH_ALUM_MAG_DATE" DATE,
            "PREF_JNT_MAIL_NAME1" VARCHAR2(60 BYTE) DEFAULT ' ',
            "PREF_JNT_MAIL_NAME2" VARCHAR2(60 BYTE) DEFAULT ' ',
            "MARITAL_STATUS_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "MARITAL_STATUS_CHG_DT" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "MARITAL_COMMENT" VARCHAR2(255 BYTE) DEFAULT ' ',
            "MARITAL_SRC_CODE" VARCHAR2(3 BYTE) DEFAULT ' ',
            "SPOUSE_STATUS_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "SPOUSE_NAME" VARCHAR2(60 BYTE) DEFAULT ' ',
            "SPOUSE_ID_NUMBER" VARCHAR2(10 BYTE) DEFAULT ' ',
            "SPOUSE_SALUTATION" VARCHAR2(40 BYTE) DEFAULT ' ',
            "SPOUSE_NICKNAME" VARCHAR2(25 BYTE) DEFAULT ' ',
            "SPOUSE_BIRTH_DT" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "MARRIAGE_PLACE" VARCHAR2(60 BYTE) DEFAULT ' ',
            "MARRIAGE_DT" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "MARRIAGE_ALUM_MAG_DATE" DATE,
            "JNT_SALUTATION" VARCHAR2(80 BYTE) DEFAULT ' ',
            "JNT_ADDRESS_IND" CHAR(1 BYTE) DEFAULT ' ',
            "JNT_MAILINGS_IND" CHAR(1 BYTE) DEFAULT ' ',
            "JNT_GIFTS_IND" CHAR(1 BYTE) DEFAULT ' ',
            "JNT_TELEPHONE_IND" CHAR(1 BYTE) DEFAULT ' ',
            "CITIZEN_CNTRY_CODE1" VARCHAR2(5 BYTE) DEFAULT ' ',
            "CITIZEN_CNTRY_CODE2" VARCHAR2(5 BYTE) DEFAULT ' ',
            "ORG_LONG_NAME1" VARCHAR2(60 BYTE) DEFAULT ' ',
            "ORG_LONG_NAME2" VARCHAR2(60 BYTE) DEFAULT ' ',
            "CUSIP_CODE" VARCHAR2(9 BYTE) DEFAULT ' ',
            "CASE_CODE" VARCHAR2(9 BYTE) DEFAULT ' ',
            "MATCHING_RATIO_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "HOLDINGS_SIZE_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "ETHNIC_SRC_CODE" CHAR(1 BYTE) DEFAULT ' ',
            "POLITICAL_INTEREST_CODE" VARCHAR2(5 BYTE) DEFAULT ' ',
            "EMPLOYEE_FULL_TIME_CNT" NUMBER(10,0) DEFAULT 0,
            "EMPLOYEE_PART_TIME_CNT" NUMBER(10,0) DEFAULT 0,
            "LAST_RESEARCH_DT" DATE,
            "INCORPORATION_DT" DATE,
            "VIP_IND" CHAR(1 BYTE) DEFAULT ' ',
            "YR_END_RCPT_REQUESTED_IND" CHAR(1 BYTE) DEFAULT ' ',
            "YR_END_RCPT_START_DATE" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "YR_END_RCPT_STOP_DATE" VARCHAR2(8 BYTE) DEFAULT '00000000',
            "DATE_ADDED" DATE,
            "DATE_MODIFIED" DATE DEFAULT SYSDATE,
            "OPERATOR_NAME" VARCHAR2(32 BYTE) DEFAULT ' ',
            "USER_GROUP" VARCHAR2(2 BYTE) DEFAULT ' ',
            "LOCATION_ID" NUMBER,
            "GROUP_ID" NUMBER,
            "MAIL_CHANGE_SOURCE" VARCHAR2(3 BYTE) DEFAULT ' ',
            "MARITAL_CHANGE_SOURCE" VARCHAR2(3 BYTE) DEFAULT ' ',
            "PRIMARY_SPOUSE_ENTITY_IND" CHAR(1 BYTE) DEFAULT 'N'
               ) SEGMENT CREATION IMMEDIATE
              PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
            NOCOMPRESS LOGGING
              STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
              TABLESPACE "ADVANCE_DATA" ;
            --------------------------------------------------------
            --  DDL for Index ENTITY_KEY_ENC
            --------------------------------------------------------

              CREATE INDEX "ADVANCE"."ENTITY_KEY_ENC" ON "ADVANCE"."ENTITY" ("ID_NUMBER", "DATE_MODIFIED")
              PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
              STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
              TABLESPACE "ADVANCE_DATA" ;
            --------------------------------------------------------
            --  DDL for Index ENTITY_KEY3
            --------------------------------------------------------

              CREATE INDEX "ADVANCE"."ENTITY_KEY3" ON "ADVANCE"."ENTITY" ("SPOUSE_ID_NUMBER")
              PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
              STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
              TABLESPACE "ADVANCE_DATA" ;
            --------------------------------------------------------
            --  DDL for Index ENTITY_KEY2
            --------------------------------------------------------

              CREATE INDEX "ADVANCE"."ENTITY_KEY2" ON "ADVANCE"."ENTITY" ("PREF_SCHOOL_CODE")
              PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
              STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
              TABLESPACE "ADVANCE_DATA" ;
            --------------------------------------------------------
            --  DDL for Index ENTITY_KEY1
            --------------------------------------------------------

              CREATE INDEX "ADVANCE"."ENTITY_KEY1" ON "ADVANCE"."ENTITY" ("PREF_CLASS_YEAR")
              PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
              STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
              TABLESPACE "ADVANCE_DATA" ;
            --------------------------------------------------------
            --  DDL for Index ENTITY_KEY0
            --------------------------------------------------------

              CREATE UNIQUE INDEX "ADVANCE"."ENTITY_KEY0" ON "ADVANCE"."ENTITY" ("ID_NUMBER")
              PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
              STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
              PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
              BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
              TABLESPACE "ADVANCE_DATA" ;
            --------------------------------------------------------
            --  Constraints for Table ENTITY
            --------------------------------------------------------

              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PRIMARY_SPOUSE_ENTITY_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARITAL_CHANGE_SOURCE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CHANGE_SOURCE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("USER_GROUP" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("OPERATOR_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DATE_MODIFIED" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DATE_ADDED" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("YR_END_RCPT_STOP_DATE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("YR_END_RCPT_START_DATE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("YR_END_RCPT_REQUESTED_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("VIP_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("EMPLOYEE_PART_TIME_CNT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("EMPLOYEE_FULL_TIME_CNT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("POLITICAL_INTEREST_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ETHNIC_SRC_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("HOLDINGS_SIZE_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MATCHING_RATIO_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("CASE_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("CUSIP_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ORG_LONG_NAME2" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ORG_LONG_NAME1" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("CITIZEN_CNTRY_CODE2" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("CITIZEN_CNTRY_CODE1" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("JNT_TELEPHONE_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("JNT_GIFTS_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("JNT_MAILINGS_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("JNT_ADDRESS_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("JNT_SALUTATION" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARRIAGE_DT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARRIAGE_PLACE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SPOUSE_BIRTH_DT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SPOUSE_NICKNAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ENTITY_SRC_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("REPORT_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_MAIL_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_ADDR_TYPE_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("XCOMMENT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("CLASS_AGT_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("RELATIONS_NBR" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("RECORD_STATUS_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("RECORD_TYPE_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PERSON_OR_ORG" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ID_NUMBER" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SPOUSE_SALUTATION" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SPOUSE_ID_NUMBER" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SPOUSE_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SPOUSE_STATUS_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARITAL_SRC_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARITAL_COMMENT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARITAL_STATUS_CHG_DT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MARITAL_STATUS_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_JNT_MAIL_NAME2" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_JNT_MAIL_NAME1" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DEATH_OBIT_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DEATH_PLACE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DEATH_DT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("CHILDREN_NBR" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("BIRTH_PLACE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("BIRTH_DT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("LANGUAGE_PREFERENCE_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("RELIGION_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ETHNIC_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("GENDER_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SALUTATION" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREFIX" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("INSTITUTIONAL_SUFFIX" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PROF_SUFFIX" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PERS_SUFFIX" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MIDDLE_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("FIRST_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("LAST_NAME" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_SCHOOL_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_CLASS_YEAR" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DELETE_OPERATOR" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DELETE_IND" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("DIRECTORIES_NBR" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("PREF_NAME_SORT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE10" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE9" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE8" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE7" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE6" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE5" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE4" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE3" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE2" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("MAIL_CODE1" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("ALUM_MAG_MAIL_CODE" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SOLICIT_CTRL_COMMENT" NOT NULL ENABLE);
              ALTER TABLE "ADVANCE"."ENTITY" MODIFY ("SOLICIT_CTRL_CODE" NOT NULL ENABLE);

            • 3. Re: Completion Insight SQL Developer Version 18.1.0.095

              I am attempting to become more familiar with Oracle SQL Developer and am having issues with the Completion Insight utility.  I feel like this should be an easy thing to figure out but can't find the solution.

              The FIRST PLACE to look for information is the Sql Developer User Guide.

               

              Can you confirm that you have downloaded and read the relevant portion of that doc?

              In tools -- > preferences -- > completion insight:  I have everything checked, popup speed lowered to .1 seconds, and suppressed results set to 100.

              . . .

              I have a table called entity.  In that table is a column called id_number.  When I either let the columns self-populate or when I hit cntrl_space, the full list of columns is not displayed.  Instead the list ends in an ellipses

              Ok - but are you aware that there are MORE THAN 100 columns in your table?

               

              The ellipses indicate there is more to see - and more will be displayed when you click them.

              Once I hit the ellipses ALL of the missing columns appear (there are multiple columns missing from the full list).

              EXACTLY - just as I described above - if you had more than 200 there would STILL BE some missing but more would appear when you click the ellipses.

               

              That is how that functionality works - it uses your preference setting to determine how much to display at one time.

                Screen shot below (the ellipses I am referring to is at the bottom of the displayed columns):

              Ok - but you did NOT post anything showing ellipses - not that we need to see it now.

              We have been using PL/SQL Developer.  In that software when you attempt the same action, it gives you a pop-up organized by the order in which the columns appear and you can quickly click on the one you want from the table.

              Well Sql Developer is NOT pl/sql developer - the tools have different functionality and even functions that are the same operate differently as you have discovered. Yet another reason to read the docs BEFORE doing things.

               

              And in my opinion, and the majority of others, you can NOT 'quickly click on the one you want' when columns are listed in apparent physical order since you have no idea where the column really is.

               

              Kind of a pain because the software has it alphabetical and the DDL is by column occurrence which is actually what I want to have happen (plus fixing the missing columns from the list).

              Sorry - but you are in the minority.

               

              It is virtually USELESS to display a pick list in (apparent) physical order because

               

              1) no user knows, or would be expected to know, what the (apparent) physical order really is

               

              2) users should NEVER rely on any (apparent) physical order to work with tables or columns since that apparent order can change and a column that appeared to be in one location may later appear to be in a different location.

               

              3) as your own images show when only SOME of the columns are displayed there is no way for the user to know what columns (based on column number or apparent physical order) are being displayed. Which means they have no way of knowing if the column they want is in the previous page, the next page or doesn't even exist.

               

              4) users DO KNOW the column name they want and alphabetical order makes it EASY to find no matter where it is.

              Again -- > second day with the software.

              Again - download and RTFM - there are NO SHORTCUTS.

               

              If you want to learn what functionality is available, what it does and how to use it you need to FIRST read the docs. Sure - you may still have questions after reading the docs but many of your questions could be answered by them.

              • 4. Re: Completion Insight SQL Developer Version 18.1.0.095
                thatJeffSmith-Oracle

                100 suggested columns won't be very helpful.

                 

                Type the first few characters of the column you want, and then invoke the insight. The advice will be much more useful then.

                • 5. Re: Completion Insight SQL Developer Version 18.1.0.095
                  3730927

                  You are correct -- > there are 106 per a column count using dba_tab_columns.  Increasing it still gives me the ellipses.  Sorry I forgot to mention that.  Also the ellipses screen shot is the first image I posted; it is hard to see but is at the bottom of the list as described in the initial post.

                   

                  I would assume if that was the actual issue, I would be seeing all of the columns alphabetically until the cut off but that isn't the case.  'I' for id_number, should be on the list if this were true.  It is selectively excluding some of the columns.  Under your logic Birth_date and Birth_place should be second and third on the list but they aren't there.

                   

                  I searched the guide.  'Ellipses', 'Completion Insight', 'Code Editor', and 'Preferences'.  I used the in-app help doc.  I watched the Oracle video regarding this topic.  I "googled" it.

                   

                  The video suggests it should be working.

                   

                  After failing to find a solution on my own, I came here for the support of a professional community. 

                   

                  You wrote a lot but unfortunately none of it actually helped.

                  • 6. Re: Completion Insight SQL Developer Version 18.1.0.095
                    3730927

                    Jeff your videos are what brought me here.  I greatly appreciate them.  It has saved me a ton of time figuring out the software and your tips are awesome.  I can't find where you talked about Code Editor but it's why I came here.  Your video showed a smooth and solid interaction where whenever you punched in a letter, you got the drop down displayed for you of all the matches in the table.  Mine isn't doing that.

                     

                    If I unclick "enable completion Auto-Popup in SQL worksheet", then type id_ and cntrl+space -- > it will auto populate.  Since it is a unique value, I am guessing it doesn't need a drop down which is cool.  If I do the same for birth I do get birth_date, and birth_place showing as options.  But again, it doesn't work when auto pop-up is enabled.  In the video I thought you were using the auto-pop-up feature but maybe you were hitting cntrl+space? 

                     

                    That's the only way I can get the feature to work which is fine but the video and the settings seem to suggest it should be auto-populating a drop down list as I type in letters in the select statement and that just isn't happening.

                     

                    Thanks

                    • 7. Re: Completion Insight SQL Developer Version 18.1.0.095
                      thatJeffSmith-Oracle

                      auto only works if the number of suggested hints are fewer than the limit defined in the preferences, which defaults to 10

                       

                      I always turn auto off and use ctrl_space -> that way i'm in charge

                      • 8. Re: Completion Insight SQL Developer Version 18.1.0.095
                        thatJeffSmith-Oracle

                        FWIW I tried your exact scenario, I think

                         

                        AUTO-COMPLETE ON

                         

                        • 9. Re: Completion Insight SQL Developer Version 18.1.0.095
                          3730927

                          When you type bir -- > do the column options automatically appear?  Or do you still have to hit cntrl(+)space?  I wrote the exact same code and I don't get an auto-drop-down list.  I have all four boxes in preferences clicked and set it to 10 matches with a .1 second popup speed.    I was under the impression I wouldn't have to hit keys to make the list appear.  It does appear if I use the key combo.  Maybe I'm just not understanding the feature due to my history with PL/SQL Developer and the word 'auto' but I assumed the feature would trigger the appearance of the columns as I typed letters.

                           

                          thanks again.

                          • 11. Re: Completion Insight SQL Developer Version 18.1.0.095
                            3730927

                            There has to be something that needs to be turned on somewhere else that I am overlooking.  Like it is off by default on install.  I went through all of the preference options and nothing stood out to me.  I just don't get it.  Nothing appears for me.

                             

                            At least I know it is a feature and it should be working.    I'll just keep trying to figure it out.

                             

                            Thanks.

                            • 12. Re: Completion Insight SQL Developer Version 18.1.0.095
                              thatJeffSmith-Oracle

                              If the query takes too long to respond, I don't think auto will work

                               

                              Check the statements log panel

                              • 13. Re: Completion Insight SQL Developer Version 18.1.0.095
                                3730927

                                Ok -- think I am on the right trail with the statement logs.  I generated the same scenario we are working from -- > select * from entity where bir -- > log shows the following:

                                 

                                SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type

                                FROM sys.all_tab_cols

                                WHERE hidden_column = 'NO' and rownum <=50 and owner = ? and table_name = ?

                                 

                                One of the issues I mentioned yesterday was a failure for all of the columns to populate on the drop down without hitting the ellipses.  It is because all of the ones missing have a rownum > 50.  Such as id_number (87), birth_place (65), and birth_date (64).  I am assuming you get a full list on your end so there must be a way to change that value.

                                 

                                 

                                • 14. Re: Completion Insight SQL Developer Version 18.1.0.095
                                  thatJeffSmith-Oracle

                                  but you don't have 50 columns that start with 'BIR' do you?

                                  1 2 Previous Next