我想让我的智慧互动。 第一夫人 我想显示项目清单,然后要接受用户的选择,并按选择显示结果。
但是,当我尝试时,在显示名单之前,我正在迅速挑选。
谁能帮助我?
我想:
LIST OF COUNTRIES : (am getting this list by calling a procedure )
注 不结盟运动
CHOOSE COUNTRY to be REPLACED : (这将在变数中节省下来,如 var1)
注 不结盟运动
CHOOSE COUNTRY to be REPLACED : (这将在变数中节省下来,如var2)
在接受价值观之后,我想用var2取代var1。
因此,现在谁能告诉我,应该做些什么?
我认为,你希望有一个接受用户投入的附加文字。 Try establishing a batch file and use the “accepttable prompt questionnaire. 粉碎注射攻击(这预示着对数据输入的好办法)。
See here for Oracle doc on communicating with user in SQLPlus.
例如,如果你的环境是指挥线,那么你可以使用附加说明来做到这一点。 我在一份便衣档案中做了类似工作,作为5分钟的带宽。
PROMPT will basically echo text to the screen. ACCEPT will allow you to accept user input.
To display your list of options, just run a simple select.
一旦你们接受你们的意见,就从那里经过程序。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
I ve got the following objects: CREATE FUNCTION CONSTFUNC RETURN INT DETERMINISTIC AS BEGIN RETURN 1; END; CREATE TABLE "FUNCTABLE" ( "ID" NUMBER(*,0) NOT NULL, "VIRT" NUMBER GENERATED ALWAYS AS ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I was wondering, is there a way to make a kind of one to one left outer join: I need a join that matches say table A with table B, for each record on table A it must search for its pair on table B, ...
I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL ...
I just came across NULL values in NOT-NULL fields in our test database. How could they get there? I know that NOT-NULL constraints can be altered with NOVALIDATE clause, but that would change table s ...
I m studying databases and am currently working on a object-relational DB project and I ve encountered a small problem with the number of possible constraints in an object table. I m using "Database ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
