oracle11gr2
Fetching bunch of fields into a custom object defined in a package
Let\'s suppose I have a package A that has type type_bla is record (id number, ...); Also in the same package body I have a query, that fetches all the fields needed to construct the object. If I h[详细]
2023-02-15 18:08 分类:问答Scheduler jobs, slave pid and sleep
I have 2 scheduler jobs, that run different scheduler programs. Each of scheduler program run the same procedure but with different arguments.[详细]
2023-02-13 15:06 分类:问答Truncating timestamps
Let\'s suppos开发者_JAVA百科e I have a timestamp variable: select timestamp \'2011-02-24 08:30:42 +06:00\' from dual;[详细]
2023-02-12 20:39 分类:问答Oracle: list of schedules
How to retrieve all the list of schedules of current user? (Oracle 11g r2) Toad can retrieve it in som开发者_JAVA百科e way (since it draw them in the objects tree) but I cannot find the view (query)[详细]
2023-02-05 10:25 分类:问答How Can I Script Oracle Wallet Changes?
I use the Oracle wallet to store passwords for the databases I connect to.Our password policy requires us to change our passwords frequently enough that I would like to script the changes.I have a bat[详细]
2023-01-24 21:40 分类:问答Oracle RAC One Node
In the latest version of Oracle Database (11g Release 2), there\'s a new option called Real Application Clusters (RAC) One Node. What is \"One Nod开发者_高级运维e\", and how does it differ from regula[详细]
2023-01-20 15:51 分类:问答XSLT: need to replace document('')
I\'ve the following xslt file: <?xml version=\"1.0\" encoding=\"UTF-8\"?> <xsl:stylesheet version=\"1.0\" xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\">[详细]
2022-12-23 13:01 分类:问答