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. Can I select(*) from T only fields that are not null?
  2. Re: Can I select(*) from T only fields that are not null?
  3. Re: Can I select(*) from T only fields that are not null?
  4. Sum on like wildcard - replacing decode statement
  5. How does Oracle know if a program has crashed, so it can rollback?
  6. Comparing Rows
  7. why outer join is faster?
  8. How to get different columns total in one time query?
  9. Good Way to SELECT Max Occurence
  10. Question about UTL_FILE
  11. Phantom Read
  12. dba_dependencies "extra" rows?
  13. [HELP]sqlldr question
  14. pl/sql aggregation
  15. ORA-00060: deadlock detected while waiting for resource
  16. Are the two SQLs equivalent?
  17. ORA-01799: a column may not be outer-joined to a subquery
  18. Speed Problem with INSTEAD OF INSERT VIEW FOR EACH ROW
  19. ConText Index Maintenance - Optimize Blocking Sync
  20. Need someone to interview for an academic paper
  21. Join XMLType tables
  22. PL/SQL Trigger (PLS-00201: identifier '...' must be declared)
  23. Can I do this strictly in SQL*Plus?
  24. Easy JOIN question for the pros
  25. Trigger problem
  26. Find rows with a change in a field compared with the previous row
  27. Oracle-Advanced SQL-question
  28. 'Alter index rename subpartition' on table with not commited data(from other session)
  29. Newbie Cursor Question
  30. How to Learn PLSQL
  31. Takeover time, reverse replication in DataGuard setup?
  32. Data Normalization & Working with Views
  33. Calculating log normal distribution
  34. Collection would be good!
  35. Does varchar2 size matter?
  36. Need an ORACLE HR Admin in MIAMI, FLORIDA!! 85k + 20% Bonus + RELO
  37. Help with PL/SQL and XmlType
  38. pro*C help !!!!!!!!!!!!!!!
  39. ORA-22288 when DBMS_LOB.FILEOPEN even if server can see the file
  40. Dynamic XMLelement generation
  41. Problem in comparison of two way records in table
  42. Problem in comparison of two way records in table
  43. Compare current and next row data
  44. Corporate Training On Oracle Applications
  45. Sorting alphanumeric column
  46. conflicting versions of regsvr32
  47. test
  48. Object Libraries in Oracle Forms
  49. two tables, one result set, but no join!
  50. extracting records using a cursor within a cursor (again)
  51. Mutliple calls to an ASP page which executes an Oracle Stored Procedure. Sessions blending causing errors.
  52. Oracle Warhouse Builder reading Navision
  53. Application vs database users
  54. External table field options
  55. Horny Teen Girls
  56. [FAQ] Oracle Database FAQ
  57. Teens4cash
  58. Connecting PHP with Oracle 9i
  59. Oracle ODBC driver does not show up in Data Source Administrator
  60. Oracle AERS database model
  61. Row values changing back to old values randomly???
  62. Poszukiwany Instruktor - Specjalista ORACLE
  63. dbms_xmlschema.registerSchema - invalid XML document
  64. "WITH" statements and ADO...
  65. [Newbie] Oracle
  66. dbms_xmlschema.registerSchema - invalid XML document
  67. Frm-92050 : Fail to connect ...
  68. Oracle Client breaks c# interop?
  69. Oracle JDBC driver's limitations
  70. Constrainting NUMBER
  71. ORA-07445: exception encountered: core dump
  72. java.sql.SQLException: Exhausted Resultset
  73. Calling Procedure
  74. Move online vs online redef
  75. SQL*Plus 'xxx rows selected' echo line
  76. Different results from stored Proc when run from differentprograms.
  77. Another newbie question about UPDATE
  78. extracting records using a cursor within a cursor
  79. Issue with creating tables
  80. TEENS FUCKIN FOR CASH
  81. bind within functions
  82. 1351026 CD-R, DVD R, DVD CASES LOWEST PRICE! 13
  83. Can RedHat ASE 2.1 primary Oracle DB have SUSE physical standby?
  84. jdbc and batch update
  85. equal names of: parameter of procedure - columns of table
  86. Generating Huge Table
  87. SQL*Plus and Feedback (xx Rows Selected) Line
  88. Did the query return any rows
  89. slow defining in OCI/OCCI: 65% time in internal to external datatype conversion
  90. Which DB instance(among 2 running instances) is preferred with Oracle TAF feature?
  91. Documentation for 8.*
  92. How do I suppress the echo
  93. Vennela Technologies Offering Beautiful Courses On Oracle
  94. Vennela Technologies Offering Beautiful Courses On Oracle
  95. Unix scripts on Windows
  96. Simple update problem
  97. Starting an applet from oracle scripting
  98. looking for good books for PL/SQL.
  99. Minimising deep indentation
  100. Encryption Wizard Offers Large Object Binary support for Oracle Customers.
  101. Invalid column name
  102. Select a single row
  103. "CASE when" strange
  104. View containing all days since day X
  105. System.out.print <-- Where does it go?
  106. OCI 7.x multithread performance issues
  107. CHALLENGING:: Dynamic OR Session specific Views. Possible?
  108. Caculating "business days" in Oracle
  109. Quality low cost broadband phone & PC to Phone services
  110. reset a sequence in a trigger
  111. Connect Oracle Server from a Pocket Pc
  112. Replace Command - Clueless Newbie Question
  113. Inserting into CLOB datatype field in oracle 9i using easysoft-odbc driver
  114. CLOBs in Triggers - assigning to :new.XXXX
  115. Is this sql reference valid?
  116. dynamic SQL query question
  117. foreign keys between 2 tables - newbie question
  118. Table Design In General
  119. Windows Explorer search file contents not working on .sql files.
  120. Return table name and record count
  121. Oracle Release Number CLient Vs. Database
  122. comparing CLOBs
  123. Oracle 10g R2 Discoverer with SSO
  124. PL/SQL beginner
  125. oracle db2
  126. CLOB problem in a Stored Function
  127. for loop mit select - Firebird -> Oracle
  128. Extract same datetime records
  129. Oracle JDBC problem
  130. Finding table modification timings(not just the last one)
  131. 3 dimensional Oracle database
  132. A question about UPDATE. How smart is oracle
  133. return full recordset and sum of recordset
  134. inserting records from a table to another using %rowtype
  135. General SQL statement question
  136. pivot query
  137. executing procedure with CLOB parameter from C
  138. Correct settings in SQL*Loader control file
  139. please, help me...
  140. Automated file loading
  141. sqlplus and stdout... SEEING WHAT RAN??
  142. light weight gui client
  143. Find a table name for user packages..
  144. SQL help
  145. Creating materialized view on remote database
  146. Oracle Database Link Won't work
  147. Tab labels width and the navigational arrows...
  148. does oracle support more than one CPU for SuSE Linux 9.1 or 9.2 or 9.3 Professional Linux
  149. OEM for iAS Application Server Control - Wrong Status Display
  150. logging information from a stored procedure calls
  151. oracle 10g filenames of db_files have strange ? marks ..why
  152. [8.1.7.4] Duplicate tablespace
  153. ATTN: VSATYA RE:Help on Data Integrity Constraints ATTN: VSATYA
  154. 9.2.0.7
  155. find the last date of between two months ranges
  156. Oracle trigger... strange...
  157. column width
  158. Does Oracle Support MD5()
  159. Oracle Instantclient
  160. selecting from functions returning resultsets
  161. xml data to columns table
  162. speed up select distinct
  163. Need SQL help on updating a table from another table
  164. ODBC SQLFreeStmt leave open cursor "select null from dual" on Oracle 9
  165. LDAP Query for Oracle
  166. ORA-16068: redo log file activation identifier mismatch
  167. Creating Cubes with OEM and AWM
  168. Is there any third party tools to connect active directory with Oracle?
  169. TOAD tablespace-map?
  170. returning modified resultsets
  171. question on mass deletes
  172. Answers to Oracle 1Z0-040
  173. Returning Ref cursor between two oracle database
  174. SQL*Loader Skipping The Last Record In A Flat File
  175. PL/SQL Newbie Question
  176. character set problem in Oracle 10g
  177. DB connectivity
  178. Can one create a type (domain) and see it in the OEM type dropdown lists?
  179. Job wont run at scheduled time
  180. Drop user causes session to freeze with no error message returned?
  181. sqlplus hangs an database connect
  182. SQL Profiler
  183. laptop RAC
  184. Oracle reports performance 10g--Tips welcomed!!
  185. Pro*COBOL Question
  186. Storage parameters
  187. Modification in code for RAC
  188. resetting initial_extents
  189. Calling PL-SQL block from Shell Script
  190. How to free empty_blocks
  191. PL/SQL developer Oracle9i Enterprise edition
  192. Oracle Order Management
  193. extents on new tables
  194. Packing or freeing datafiles?
  195. Oracle Transaction Boundary ..
  196. UTL_HTTP and Cookies
  197. Space in database table's fields
  198. Oracle's query parameter syntax equivalent to @ in SQL's
  199. Help on Data Integrity Constraints
  200. multiply column values within a partition
  201. SQL question
  202. Passing SQL*Plus bind variables to host command
  203. sqldr -- help
  204. How to see user objects from particular user
  205. MS Access 2000
  206. MS Office 2000
  207. MS Office
  208. I can I install fonts in 10G
  209. Backup and Recovery
  210. Re: Live Reorganize from SQL-script?
  211. Re: Live Reorganize from SQL-script?
  212. Re: Live Reorganize from SQL-script?
  213. Live Reorganize from SQL-script?
  214. Many insertions at one shot
  215. Oracle PL/SQL
  216. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  217. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  218. PLSQL vs SQL Parser
  219. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  220. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  221. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  222. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  223. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  224. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  225. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  226. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  227. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  228. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  229. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  230. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  231. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  232. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  233. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  234. STARTUP failed
  235. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  236. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  237. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  238. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  239. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  240. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  241. Improve performance of XML parsing, please help
  242. Oracle Error - ORA-01861: literal does not match format string"
  243. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  244. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  245. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  246. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  247. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  248. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  249. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=
  250. =?Big5?B?sXqsT6dfpmK0TafkpECt06R3w9K56qVppuaqurxXp VumrKRKqNO3vaTopqGhSA==?=