On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,629 Users
  • 2,269,769 Discussions
  • 7,916,800 Comments

Discussions

sqlcl path setting

User_ZUUOD
User_ZUUOD Member Posts: 800 Bronze Badge
edited Jan 7, 2019 10:25AM in SQLcl

Hi

i have downloaded sqlcl and setup it as in window 7 environmental path variable but when i run it on cmd like sql it says not recognized command.

can you suggest whats wrong I did.

Best Answer

  • Glen Conway
    Glen Conway Member Posts: 859 Gold Badge
    edited Nov 29, 2018 4:05PM Answer ✓

    Did you include the sqlcl\bin portion of the path to sql.exe in your PATH?  It should look something like:

    PATH=C:\Tools\sqlcl\r18_3\sqlcl\bin;C:\windows\system32; ...

    As an alternative (what I do), create a shortcut to a CMD window that starts in:

    C:\Tools\sqlcl\r18_3\sqlcl\bin 

    then run sql from there.

    Cheers

    Edit:

    Or maybe if you edited the PATH variable in your Windows System Properties -> Environment Variables,

    rather than on the fly in the CMD window,

    you forgot to open a new CMD window so the change will take effect?

Answers

  • Frank Kulash
    Frank Kulash Boston, USAMember, Moderator Posts: 43,002 Red Diamond
    edited Nov 29, 2018 1:46PM

    Hi,

    You've got the wrong Forum.  This Forum is just for questions about using the SQL or PL/SQL languages.

    I'll move this thread to the

    SQLcl

    Froum

  • Glen Conway
    Glen Conway Member Posts: 859 Gold Badge
    edited Nov 29, 2018 4:05PM Answer ✓

    Did you include the sqlcl\bin portion of the path to sql.exe in your PATH?  It should look something like:

    PATH=C:\Tools\sqlcl\r18_3\sqlcl\bin;C:\windows\system32; ...

    As an alternative (what I do), create a shortcut to a CMD window that starts in:

    C:\Tools\sqlcl\r18_3\sqlcl\bin 

    then run sql from there.

    Cheers

    Edit:

    Or maybe if you edited the PATH variable in your Windows System Properties -> Environment Variables,

    rather than on the fly in the CMD window,

    you forgot to open a new CMD window so the change will take effect?