PDA

View Full Version : Oracle Miscellaneous

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
  1. newby question finding average
  2. problem of sys.utl_file.fopen
  3. ORA-12899, value too large
  4. DBMS_SCHEDULER.CREATE_JOB
  5. installing "oracle 8i (8.1.5) for windows nt" on windows xp/2000
  6. PostFix Migration to Collaboration Suite 10g
  7. Usings HINTS
  8. ORA-01779, update join view
  9. Partitioning of Large tables of the index
  10. trivia: origin of names for UPPER() and LOWER()
  11. cursor or exception
  12. Reference data manitenance tool?
  13. Supply Date based on DOW
  14. Supply Date based on DOW
  15. Problem with a date in the query !!
  16. Oracle 9i tutorial or ebook
  17. put away characters in result of query
  18. OO4O, BLOB, AddNew and "Row must be locked"
  19. formatting columns in SQL*Plus
  20. Challenging SQL Query Problem. Can you solve it?
  21. New tool for database developers, DBAs and analysts!
  22. problems on views
  23. New to Oracle
  24. Update query on Oracle with PL/SQL
  25. NEWBIE QUESTION: BEST WAY TO LEARN ORACLE DB
  26. TNSPING from PL/SQL?
  27. Find the first record, for every day
  28. How can I find out differcences from two database?
  29. NULLs
  30. Input/output error while trying to run Oracle Installer on Linux
  31. Unable to deinstall oracle home
  32. OO4O preparing statements?
  33. Update trigger, detecting missing columns
  34. Distinct not working when convert DATE using TO_CHAR
  35. Sever and Client on one machine - delete one TNSNAMES.ORA?
  36. owa_pattern.pattern as a type
  37. Oracle sequence - primary key in cycle
  38. How to send an alert messages when tablespace increases.
  39. Oracle vs. Microsoft in analysis languages
  40. Oracle not logging or tracing
  41. Obtaining Oracle Licence/Installed Products
  42. Security Implications of using DBMS_JOB
  43. How to find the Overall cost of a query?
  44. How are Blobs Exported during Export Utility + Oracle 9i
  45. [FAQ] Oracle Database FAQ
  46. Query and Update/Insert Large Tables Frequently ...
  47. Help!! Trigger for delete a record after update
  48. test
  49. ORA-04061
  50. can get log on to oracle 9i
  51. can get log on to oracle 9i
  52. Transfer of Large Objects
  53. Please help me with a simple query!!!
  54. JavaDoc for Oracle PL/SQL?
  55. Can't connect to Oracle Dbase with SQL Server 2005 Express
  56. =?iso-8859-1?q?NLS=5FSORT_don=B4t_work=3F?=
  57. Oracle 10 and C++
  58. Setting up Oracle Database for Production
  59. Setting up Oracle Database for Production
  60. Setting up Oracle Database for Production
  61. Running select queries only in my script
  62. SELECT CASE WHEN errors when using OraOLEDB and Static ADO RS
  63. Copy a record from 1-table to another
  64. remote sessions (database link, v$session)...
  65. Inserted value too big
  66. About Oracle 10g XE
  67. OracleMTSRecoveryService, OracleCSServices in 10G
  68. New columns in V$yablespace
  69. dbms_output from dbms_jobs procedures
  70. table objects
  71. tom kyte reference to build an index
  72. Question about SQL Query
  73. Import error - SQL statement exceeded buffer length
  74. Anyone know how to break an SQL-Plus Worksheet output stream?
  75. Looking for a book / intro to analysing SQL traces
  76. 9ids can be used as application server ??
  77. Where clause and cartesian product
  78. Associative Arrays - Oracle 9i
  79. ORA-3004: when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value
  80. C++ driver for Oracle
  81. CLOB to file
  82. How to add joins in triggers and cascading triggers
  83. Help Resources -- Forum/Tips N' Tricks/Tutorials/Blogs
  84. help!"EXEC SQL ENABLE THREADS" cause memory leak?
  85. Urgent: Equivalent of @@rowcount in Oracle
  86. ORA-29516: Aurora assertion failure: Assertion failure at eox.c:317
  87. Getting the FIRST and LAST records in a group efficiently in SQL?
  88. Newbie PL*SQL question
  89. degree asignment
  90. Protocol Violation
  91. OraOLEDB.Oracle, ref cursors and VB
  92. info about Oracle session
  93. PHP oracle fetch out sequence !
  94. SqlNet problems
  95. Cursor concept
  96. Can you pass a table name into a stored procedure?
  97. Counting the number of occurrences of a specific character is a column
  98. ora -01843
  99. print table name and the number of rows in it
  100. Basic Issue: Update query based on two tables not working! Any help appreciated!
  101. Wanted: Application & Database Security Consultant
  102. Wanted: Application & Database Security Consultant
  103. Oracle issues after switching from a workgroup to domain
  104. Looking for Performance with a Where In Clause
  105. Effect of env changes on performance???
  106. Pivot query
  107. Does Oracle create temporary indexes for sub queries?
  108. Ora10 JDBC Driver with TIMESTAMP WITH LOCAL TIME ZONE
  109. RMAN Backup: Change Archivelog all crosscheck
  110. ODBC cannot access Oracle tables under different schemas in one session
  111. Possibility to replicate an index
  112. Adding hints to PL/SQL?
  113. Humor needed
  114. Re:
  115. Assignment HELP
  116. Beginner SQL question (on intersecting groups of records)....
  117. SP return Cursor
  118. Loading CLOB/BLOB using SqlLoader
  119. Question about timezone context within a trigger
  120. Oracle Data Miner (ODM)
  121. optimize this query
  122. Internal date format (numerical)
  123. ORA-03117 resulting from package procedure parameter record types
  124. does any one know where i can get a copy of oracle 8i?
  125. extracting xml tag name
  126. ORA 22922 nonexistent lob value with stored procedure
  127. change managment software for Oracle
  128. collection of primitive type
  129. How to drop a default value for a column
  130. OEM vs Standalone
  131. Filter records in HTMLDB 2.0
  132. Send email whith oracle
  133. Data Comparison
  134. Data Comparison
  135. RMAN for other cases than total disaster?
  136. RMAN question - Global Retention
  137. Internationalization - poinetrs please
  138. =?iso-8859-1?q?Oracle_-_Anf=E4ngerfrage_zu_Datentyp_DATE?=
  139. Oracle can read file not allowed by oracle user
  140. Executing exp as batch job fails
  141. Oracle costs and requirements
  142. Multiple column sorting with a decode
  143. Export tables question
  144. Celerons and Semprons with Oracle 10g
  145. swap/memory ratio
  146. Oracle replication and MS SQL-server
  147. Oracle 10g - 32bit to 64bit conversion
  148. Oracle licensing for dual core processors
  149. How to insert a timestamp in a record?
  150. Rounding problems
  151. Oracle Client for Linux on PPC (iBook)?
  152. Execution statistics on SQLs, SPs, SFs and Package Calls
  153. Collection in pl/sql
  154. UPDATE... SET... FROM x
  155. how to get the old value in a oracle event alert ?
  156. Insert into totally slow...
  157. Nested Table not working correctly.
  158. date range question
  159. Say hello to everybody, and seeking for help
  160. ORA-01536: space quota exceeded for tablespace 'DME'
  161. Week Number of the Year Question
  162. Avoiding Duplicate Inserts
  163. Urgent Requirement
  164. commit after or before close cursor - best practise
  165. Oracle 8.1.7 and 9i on same AIX server
  166. Left Outer Join, group by, and date-based queries
  167. "TOP N" limit in Oracle 9i sql query utilizing count(*)
  168. Oracle Applications Forums
  169. best way to to a "union" in a table?
  170. Oracle APPS 10.7SC password
  171. restricting table read access to admins
  172. new data type or alias for NUMERIC(18)?
  173. Get Previous Day (ie Last Sunday)
  174. Index-Organized Tables
  175. Replace substrings in a column
  176. AFTER SERVERERROR Trigger
  177. insert blob data with pro*c
  178. error when select xmltype
  179. Oracle Licensing, guys i need your expert opinion on this.
  180. [FAQ] Oracle Database FAQ
  181. Slow Oracle Update only under load
  182. Database Fails to Open after Recover TableSpace - No Backups!
  183. pivoting SQL result sets
  184. Changing long to clob results in ora 1461
  185. Why my Oracle Instance Fails..?
  186. Adjusting column length with varchar ;-(
  187. Edit a previous command
  188. How to get consecutive pairs from a table in SQL?
  189. Join table to file?
  190. Installing Oracle Client using response files and OUI 2.2
  191. How to change the datatype of the View column?
  192. utl_file.fopen with "Append/Write" option
  193. Multiple instances of oracle
  194. Do I need to reinstall Oracle after swapping in new motherboard?
  195. Help rewriting query
  196. InStr and Length Problem, ora-01460
  197. Materialized View Progress
  198. problemwith access on standard DB after installation (Oracle 10g)
  199. How to get output text immediately
  200. Oracle network authentication encryption?
  201. How to unlock user SCOTT
  202. Any free beginner tutorials online?
  203. How to create CLOB within ANYDATA ?
  204. custom aggregate function in C++
  205. SQl - Yes/No Grouping
  206. Adding sqlplus to an existing Oracle client installation
  207. How to Use Cursor variable in Where Statement
  208. regrouping 4 sql (count) queries into 1 query with a group by, howto?
  209. HELP with SQL
  210. help with a recursive SQL query
  211. Connectivity help
  212. Trace files for specific errors
  213. SQLNet Tracing
  214. getting error on UTL_FILE.FOPEN
  215. Which has the lowest overhead?
  216. Impact of foreign key on insert or update to Parent table
  217. Oracle DBA professionals needed for CMMi Level 5
  218. database link
  219. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  220. Backup Options
  221. [Beginner] Problem with Order by of a date
  222. classic ora-00904 & Crystal
  223. converting points to circles
  224. Advanced Materlized view is not updating data
  225. Oracle Reports Win98 vs WinXP
  226. How do I script object creation?
  227. Using bind variables with Execute Immediate and context index
  228. performance issue - mass updates
  229. Express Edition
  230. Problem for AWR in 5-nodes 10g RAC
  231. sys fails fast refreshing
  232. about db_domain
  233. Oracle10g: The oracle.sql.INTERVAL type
  234. All about oracle certification.
  235. Assigning Bind Variables to Substitution Variables in PL/SQL
  236. Help - Deferred transactions headache!
  237. Oracle 8.0.5
  238. Oracle Personal license
  239. How to avoid self-joins ?
  240. SDO_NN with Oracle Spatial 10g
  241. Oracle scripting
  242. Oracle Lite for qtek 9090
  243. Can some body help me with changing to the oracle sp.
  244. how do I calculate free space in schema
  245. generating diagrams (as html-page) with pl/sql
  246. SQL statement is to large, and creates a error
  247. Difficult Query Problem
  248. ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK
  249. Oracle Performance on V240
  250. NLS_LENGTH_SEMANTICS=CHAR and column storage size