oracle - How to use bind variable value as prompt in SQL*Plus ACCEPT command -

-

i'd use bind variable value input prompt in sql*plus script. here's i've tried:

1) defined bind variable follows

sql>var prompt varchar2(100)

2) , assigned value using pl/sql

sql>exec select 'your name' :prompt dual

3) can print or select bind variable value follows:

sql>select :prompt dual;  :prompt ------------------------------------ name   sql>print prompt  prompt ------------------------------------ name

4) i'd have "your name" being shown accept prompt don't know how can achieved:

sql>accept input prompt 'prompt' prompt  sql>accept input prompt ':prompt' :prompt

5) able assign bind value substitution variable, done that:

sql>define prompt = 'your name subst'  sql>accept input prompt '&prompt.>' name subst>bob  sql>def input define input           = "bob" (char)

the way see done spooling temp.sql file , running using @temp.sql seems terrible hack

you use the column ... new_value syntax query, unless you're running script (so set termout off takes effect) you'll blank lines:

sql> var prompt varchar2(100) sql> exec select 'your name' :prompt dual  pl/sql procedure completed.  sql> set feedback off sql> column o_prompt new_value n_prompt noprint sql> select :prompt o_prompt dual;    sql> accept input prompt '&n_prompt.>' name>bob sql> def input define input           = "bob" (char)

i don't think there's way define substitution variable directly bind variable, or use bind variable in purely client statement define, accept, etc. (other print, client command exists purpose).

of course, if you're doing don't need bind variable, can more directly just:

sql> set feedback off sql> column o_prompt new_value n_prompt noprint sql> select 'your name' o_prompt dual;    sql> accept input prompt '&n_prompt.>' name>bob sql> def input define input           = "bob" (char)

Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more