Return
-
Title
The Code Assist window does not show up in a "Create Table As" statement -
Description
The Code Assist window does not show up in the "Create Table As" statement when putting a period after a table name or alias.
To reproduce the problem please follow the steps below:1] Open a SQL Editor
2] Type a create table as statement. For example:CREATE TABLE XXX
AS
SELECT * FROM TEST_TABLE A WHERE A.
/ÂYou will see that the Dot-lookup-columns pop-up window does not appear.
ÂNote that the dot look up works with the same select if you do not have the CREATE TABLE XXX AS statement before. -
Resolution
WORKAROUND:
Type the select and then add the create table as statementSTATUS:
Waiting for fix in a future release of SQL Navigator -
Defect ID
ST8843