问题描述
我有一个问题，但现在还不能解决.在我的数据库上，我有字符串:
I have a problem and I can't solve it yet. On my database I have the string:
TO_DATE(' 2015-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN').
因此，在构建查询时，它类似于以下内容:
So when I'm building my query it is like the following:
Select my_field FROM my_table.
结果是:
TO_DATE(' 2015-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
明白吗?
如何在选择查询中提取此字段的值作为命令语句?
How to I extract the value of this field as a command statement on a select query?
推荐答案
我可以解决问题.我正在搜索动态SQL，并选择了正确的plsql以获取结果.
I could solve the problem. I was searching for Dynamic SQL and I made the right plsql to get the result.
由于该表可能会有一个以上的结果，所以我使用了CURSOR来创建一个类型. (TYPE tpT IS REF CURSOR; cCursor tpT;)然后，我进行查询(vSQL)并使用OPEN cCursor FOR vSQL运行它；然后我对结果的任何实例进行了循环处理.因此在LOOP内，当AUX具有字符串TO_DATE(' 2015-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN').时，我做了一个EXECUTE IMMEDIATE 'SELECT ' || AUX || ' FROM DUAL' INTO DATE_AUX.然后var DATE_AUX的值为'01-MAR-15'.
As the table could have more then one result I used a CURSOR to make a type. (TYPE tpT IS REF CURSOR; cCursor tpT;) Then I made my query (vSQL) and run it with OPEN cCursor FOR vSQL; then I did a Loop to any of the instances of the result. So inside the LOOP I did a EXECUTE IMMEDIATE 'SELECT ' || AUX || ' FROM DUAL' INTO DATE_AUX, when AUX have the string TO_DATE(' 2015-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN').. Then the var DATE_AUX has the value '01-MAR-15'.
感谢您提供的所有帮助.感谢@ justin-cave，@ jim-mcnamara和@ dan-bracuk.抱歉，我的信息一塌糊涂.
Thank you for all the help. Thanks @justin-cave, @jim-mcnamara and @dan-bracuk for your time. And I'm sorry for the mess of information.
这篇关于以TO_DATE命令作为数据库值的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！