Executing linux aliases from sqlplus












2















In sqlplus there is an option to execute standard shell commands, simply by prefixing them with '!'. Example: SQL>!ps -af returns expected processes. My question is, is there an option to execute user defined aliases in the same way? So far I tried:




  1. In .bash_profile: alias sample="ps -af".

  2. In sqlplus SQL>!sample. This doesn't work. /bin/bash: sample: command not found.










share|improve this question

























  • Similar issue: Have xargs use alias instead of binary

    – Kusalananda
    Feb 17 at 17:01
















2















In sqlplus there is an option to execute standard shell commands, simply by prefixing them with '!'. Example: SQL>!ps -af returns expected processes. My question is, is there an option to execute user defined aliases in the same way? So far I tried:




  1. In .bash_profile: alias sample="ps -af".

  2. In sqlplus SQL>!sample. This doesn't work. /bin/bash: sample: command not found.










share|improve this question

























  • Similar issue: Have xargs use alias instead of binary

    – Kusalananda
    Feb 17 at 17:01














2












2








2








In sqlplus there is an option to execute standard shell commands, simply by prefixing them with '!'. Example: SQL>!ps -af returns expected processes. My question is, is there an option to execute user defined aliases in the same way? So far I tried:




  1. In .bash_profile: alias sample="ps -af".

  2. In sqlplus SQL>!sample. This doesn't work. /bin/bash: sample: command not found.










share|improve this question
















In sqlplus there is an option to execute standard shell commands, simply by prefixing them with '!'. Example: SQL>!ps -af returns expected processes. My question is, is there an option to execute user defined aliases in the same way? So far I tried:




  1. In .bash_profile: alias sample="ps -af".

  2. In sqlplus SQL>!sample. This doesn't work. /bin/bash: sample: command not found.







bash alias sqlplus






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Feb 17 at 17:31









Jeff Schaller

42.9k1159137




42.9k1159137










asked Feb 17 at 16:23









M.DawidM.Dawid

184




184













  • Similar issue: Have xargs use alias instead of binary

    – Kusalananda
    Feb 17 at 17:01



















  • Similar issue: Have xargs use alias instead of binary

    – Kusalananda
    Feb 17 at 17:01

















Similar issue: Have xargs use alias instead of binary

– Kusalananda
Feb 17 at 17:01





Similar issue: Have xargs use alias instead of binary

– Kusalananda
Feb 17 at 17:01










1 Answer
1






active

oldest

votes


















2















  1. the ~/.bash_profile is only processed for a login shell.


  2. Aliases are only available in an interactive bash session.


So, referencing Invoking Bash: !bash -lic sample






share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "106"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f501195%2fexecuting-linux-aliases-from-sqlplus%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2















    1. the ~/.bash_profile is only processed for a login shell.


    2. Aliases are only available in an interactive bash session.


    So, referencing Invoking Bash: !bash -lic sample






    share|improve this answer




























      2















      1. the ~/.bash_profile is only processed for a login shell.


      2. Aliases are only available in an interactive bash session.


      So, referencing Invoking Bash: !bash -lic sample






      share|improve this answer


























        2












        2








        2








        1. the ~/.bash_profile is only processed for a login shell.


        2. Aliases are only available in an interactive bash session.


        So, referencing Invoking Bash: !bash -lic sample






        share|improve this answer














        1. the ~/.bash_profile is only processed for a login shell.


        2. Aliases are only available in an interactive bash session.


        So, referencing Invoking Bash: !bash -lic sample







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Feb 17 at 19:59









        glenn jackmanglenn jackman

        52.1k572112




        52.1k572112






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Unix & Linux Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f501195%2fexecuting-linux-aliases-from-sqlplus%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            How to make a Squid Proxy server?

            Is this a new Fibonacci Identity?

            19世紀