oracle9i
Privileges for a Oracle 9i statistics job
We want to move our automated statistics gathering from an external script into Oracle 9i\'s job scheduler. It\'s a very simple job, and the code basically looks like this:[详细]
2022-12-25 22:58 分类:问答Is an Oracle 9i Client compatible with an Oracle 11g Server?
We currently have an Oracle 9i Client running on an HPUX Itanium platform and are looking at upgrading the Server from an Oracle 9i Windows 2000 Server to an Oracle 11g W2K3 Server.[详细]
2022-12-25 18:05 分类:问答How to find size of a data type in pl/sql (oracle 9i)?
I want to find the size of any data type in pl/sql,for eg DECLARE x boolean; I want to find size of like X,is there any function like (sizeof()开发者_Python百科 in C) or any how i can find it.Please[详细]
2022-12-25 14:13 分类:问答Boolean data type size and want to print its value?
I want to know size of data typeboolean , i used VSIZE() functio开发者_如何转开发n but it is not working for boolean and[详细]
2022-12-25 06:39 分类:问答How to export Oracle statistics
I am writing some new SQL queries and want to check the query plans that the Oracle query optimiser would come up with in production.[详细]
2022-12-24 01:38 分类:问答Creating directory?
When I create a directory using sytem user (vin.txt is my file) create directory emp_dir1 AS \"\'C:\\Documents and Setting开发者_Go百科s\\Administrator\\Desktop\\vin.txt\'\";[详细]
2022-12-23 07:27 分类:问答Hibernate not releasing data base connections
Following is the configuration details: <property name=\"hibernateProperties\"> <props> <prop key=\"hibernate.dialect\">[详细]
2022-12-23 05:33 分类:问答How to use a calculated column in where condition?
How to use a calculated column in thewhere condition in Oracle 9i? I want to use something like select decode (:pValue,1,[详细]
2022-12-22 06:40 分类:问答merge statement err
I have created two tables with following descriptions SQL> desc new_emp NameNull?Type EMPNONUMBER(4) ENAMEVARCHAR2(10)[详细]
2022-12-21 18:38 分类:问答Oracle syntax error [duplicate]
This question already has answers here: How do I limit the number of rows returned by an Oracle query after ordering?[详细]
2022-12-21 08:11 分类:问答
加载中,请稍侯......