关于oracle xe搜索查询的问题
这是我第二次使用ORACLE xe和Apex。这是我想要做的..我正在尝试执行以下查询 SELECT * FROM EMPLOYEES WHERE JOB_TITLE = 'CLERK'
但不是从 sql 命令提示符而是从 gui/apex 和这里就是这样-我创建了带有一个文本字段和一个提交按钮的第一页。
当然，现在我会在文本字段值 CLERK 中输入，并且我希望单击提交按钮，将其带到第 2 页，并在第 2 页上接收查询的参数。当然，查询将位于第2页。
我相信这对于了解 Oracle 的人来说相当简单，我当然知道如何使用 PHP/Mysql 做到这一点，它很简单，因为我需要的就是这样：
#1 Get value from input
#2 Pass it to the next page using javascript or whatever
#3 Execute query on the next page using the value passed in where
谢谢，解释提示提示链接.. 任何东西都是欢迎
this is my second time using ORACLE xe and Apex. Here is what I'm trying to do .. I'm trying to execute the following query SELECT * FROM EMPLOYEES WHERE JOB_TITLE = 'CLERK'
but not from sql command prompt but from gui/apex and here is how- I have created page one with one textfield and one submit button.
Now of course I'd type in the text field value CLERK and I'd like onclick on submit button that I be taken to page2 let say, and on that page2 to receive argument for the query. The query will be located at page2 of course.
I believe that this is fairly simple for someone who knows oracle, I know of course how I'd do this with PHP/Mysql its simple as it can be all I need is this :
#1 Get value from input
#2 Pass it to the next page using javascript or whatever
#3 Execute query on the next page using the value passed in where
Thank you, explanation tips hints link .. anything is welcome
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以从任何其他页面引用 Apex 应用程序中的任何项目。例如，在第 1 页上，您有一个项目 P1_JOB_TITLE，然后在第 2 页上，您编写如下查询：（
警告：确保第 1 页没有“重置”过程，该过程会在页面已提交）
但是请注意，如果您不希望该项目位于不同的页面上，则该项目不必位于不同的页面上 - 您可以将其与报告位于同一页面上。
You can refer to any item in an Apex application from any other page. For example, on page 1 you have an item P1_JOB_TITLE, then on page 2 you write a query like:
(warning: make sure that page 1 doesn't have a "reset" process which would clear the value of the item when the page is submitted)
Note, however, that the item doesn't have to be on a different page if you don't want it to - you could have it on the same page as the report.