View Full Version : oracle answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 [13] 14 15

  1. SP call does not work
  2. Performance problems with remote queries
  3. top 5 ( or n) salaries in each department
  4. Looking for some help on a simple command....
  5. JDBC / Oracle : beware the bind variables ?
  6. Wrong no of type of arguments for field called 'keywords'
  7. Oracle DB Report Generator - beta testers needed
  8. storing dbl_min in Oracle 9.2
  9. Oracle Report Generator - beta testers needed
  10. How to query a remote database?
  11. Code for "bucket-ized" time table???
  12. Query Help
  13. db defragmentation
  14. store procedure from dbf file
  15. Audit log.
  16. HELP: imp error
  17. How to start ? client & database.
  18. Westell Wirespeed B90-220030-04 and Oracle Services
  19. Oracle Text with Numbers
  20. 11i Newgroups?
  21. PL/SQL: Exceptions & Sub-programs...
  22. MSCOMMLIB * - how to send & receive data via COMM PORT
  23. oracle 9i on debian
  24. Oracle Client Install
  25. Oracle9i: SQL Exam# 1Z0-007 wanted
  26. Oracle install problem
  27. Oracle DB features that support BI/ warehousing
  28. user_exit
  29. External Tables
  30. Creating a database is slow on Windows XP
  31. Database Report Generator - beta testers needed
  32. What Oracle SQL syntax does Oracle have that is not ANSI SQL ?
  33. finanial application....
  34. ORA-12224 TNS:no listener
  35. Read data via COMM port
  36. Defragmentation of Oracle 91 files on W2000 server
  37. creating joins between tables with "group by" clause to limit rows
  38. ORACLE DBA
  39. Finding Statement that ran on x date?
  40. How to find out when UTL_FILE. PATH is VALID but the directory doesn't exist
  41. How to set up LongReadLen and LongTruncOk?
  42. Need to learn Oracle
  43. Not Sure Which Analytic To Use
  44. selecting the differences between 2 large tables
  45. Determine underlying tables in a view
  46. Importing Data to DB with Added tables / columns
  47. ORA-06575: Package or function VALUE_1 is in an invalid state
  48. Strange parse counter on tkprof
  49. Strange parse counter on tkprof
  50. OraOLEDB and Inner Join
  51. PERL/Oracle opening (San Jose)
  52. http://%%20 when running Forms from Form Builder
  53. Query Help
  54. Runing oracle report in Web
  55. connection dropped by firewall
  56. SELECT DISTINCT causes ORA-03113 only on SQLPlus
  57. Calling VB components from PL/SQL
  58. Help! How to solve the ORA-03113 end-of-file on communication channel ?
  59. Generating XML from Oracle 8i datas
  60. OS username?!
  61. ALTER TABLE requires extra parentheses for Oracle?
  62. jdbc failover to standby question
  63. Windows v Unix Performance on Oracle 9i
  64. What do you think about this post ?
  65. copy a DB from PC1 to PC2
  66. Oracle View Problem
  67. OO4O usage in a VC++ 6 DLL ?
  68. loadjava error loading classes
  69. Why isn't bitmap index being used in this example
  70. sqlplus default script directory
  71. Equals-Operator on RAW Columns
  72. Executing Multiple Scripts.
  73. What is use of trim
  74. Array selection and update.
  75. Help on Oracle Update statement
  76. Bin Laden Captured - photos and video
  77. Reestablishing a db connection after a network failure
  78. Client Problems
  79. trying to move from reports generated in CGI mode to reports generated in Servlet mode
  80. Do I need to create a field type LONG?
  81. Creating a table with field type long. Initial storage settings?
  82. Conversion of Location Codes with Foreign Keys
  83. Uninstalling Oracle Client
  84. Materlized view Refresh Interval
  85. PL/SQL: Dynamically passing/changing value in WHERE clause ???
  86. Master/detail in dev2000
  87. PL/SQL Blocks
  88. Odp.net and Proxy (n-tier) Authentication
  89. LTM
  90. 10g
  91. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  92. New to Oracle
  93. Create ordinary table out of XML Schema
  94. index statistics
  95. XML acceleration
  96. Oracle, loading a java .jar file with loadjava
  97. SQL to aggregate values into LIST
  98. Problems with Micorosft Update KB835732
  99. Proposing a new newsgroup
  100. not single- group group function
  101. SQL standards editor discusses SQL:2003, XQuery and APIs
  102. ORA-00947: WHY!?!?!?
  103. Missing ora_control1 ???
  104. Handle count leak when connecting to Oracle via ODBC on Windows
  105. Hyper-threading on RH AS2.1 with 9i (Standard)
  106. RBO vs CBO
  107. batch loading clobs
  108. batch loading clobs
  109. oracle and SQL3
  110. Certification on 9i .
  111. 9i's runInstaller - is their a commandline or windowless version?
  112. Discovery of node failing ..plz help!!
  113. utl_file issue
  114. 8.1.7 query results yielding erratic sort order
  115. Oracle 9i Installation
  116. LONG RAW AND #TABLESPACE
  117. Function used in where clause - executed too many times
  118. Merge two cursors data (select from a cursor?)
  119. what does '1' in 'Case.. when' do
  120. condtional display of a page in Oracle Reports
  121. oracle9i on which linux distribution in production? feedback needed plz
  122. 9i on RedHat 9?
  123. Dumb story short- need to recreate foreign keys in oracle db
  124. procedure for numering records - no effect
  125. Oracle client for DOS
  126. Oracle Reports and Oracle installation Q's
  127. conditional selection of 'AND'
  128. Updated lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders
  129. count(*)
  130. test (please ignore)
  131. Oracle & WinXP Pro
  132. Grid Controls in Oracle Forms 6i and Up
  133. Oracle inactive connections
  134. sqlplus "Input is too long (>2499 char)" error
  135. solution
  136. data base link
  137. Inconsistent behaviour creating java stored objects using sqlplus in Oracle 8i
  138. Select for Update fails
  139. Oracle JDeveloper 10g Goes Production
  140. data base link
  141. Multi-User Password Database (Password Storage)
  142. b-tree
  143. oracle on windows cluster
  144. Running a query manually when using web modules
  145. Privilege problem with creation
  146. explicitly closing cursors
  147. MERGE on spatial indexed tables
  148. dynamic tablename with %rowtype
  149. Development Client
  150. Running Oracle Trace
  151. to check if a table exists
  152. Connection Oracle - Sybase
  153. Convert Qualify Rank from Teradata to DB2
  154. locking sga
  155. create table in a procedure
  156. Does anyone know of a good location for a data set?
  157. user interaction in pl/sql
  158. ORA-00911 in Dynamic SQL
  159. Rollback problem
  160. Please help !! Oracle 9i crashes on Windows XP SP1 without reason
  161. Printing a File From PL/SQL In Oracle 9i
  162. How to avoid duplicates here...?
  163. What is the problem my standby database step?
  164. jump 2 next iteration of FOR loop
  165. jump 2 next iteration of FOR loop
  166. Oracle Truncate problems
  167. Rollback usage query
  168. Converting SQL Server to Oracle
  169. how to Spool results from SQL plus
  170. row lock contention
  171. Can MERGE replace UPDATE/INSERT duo on a single table?
  172. Which software can capture all screen shots and composit them into a demo?
  173. Problem with Cross database join
  174. Oracle Problem 1: Please Help
  175. Missing Parenthese Error: ORA-00907
  176. Help with running totals
  177. Mandrake Oracle 9i Installation Problems (netmgr, netca)
  178. Problem with DB Propagate Assistent, (can't copy table data)
  179. Returning Variant data from Java to PL/SQL & SQL?
  180. Marrying SQL, XML, web services, grid computing (2 audio programs)
  181. cost based optimization
  182. What's your compensation for carrying a pager???
  183. Create New Oracle Database in AIX box
  184. Rule Based Optimization
  185. ora04021:timeout occurred while waiting to lock object ...
  186. Migrating db2 to Oracle 9i
  187. Setting Null values to Zero
  188. Help...
  189. Inserting an Oracle Instance into Clustered Oracle
  190. Bitand Question
  191. Custom Response File
  192. RAC and load-balancing a connection pool
  193. examining views
  194. Data in Text file thru Stored procedure
  195. Comment savoir quelle version d'Oracle Client est utilisée ?
  196. How to know wich Oracle Client release is used ?
  197. Creating foreign keys across different tablespace
  198. Using reserved word "MODE" in select queries
  199. datablock sizing
  200. Unable to revoke privileges from a user
  201. Next 33
  202. Business Intelligence - Oracle Financials 11.5.9
  203. is there any future to learn Oracle?
  204. how many tablespaces
  205. JAVA OCI Driver in 9.2.0.4
  206. BI tool users - message for u
  207. v$sqlarea in Oracle 9i
  208. A Couple of Questions on Views
  209. Char array not long enough: javaCharsToUtf8Bytes
  210. sql to find a numeric range inside another range?
  211. does sqlplus support :"select top 10 * from table1" syntax like MS SQL?
  212. Limit to number of items in a List [WHERE id IN (,,,,)]
  213. Help to optimize procedure (concatenation of rows)
  214. What is the bottom line on Oracle layout on Virtual Arrays?
  215. iSQL*Plus bug with substitution variable?! (9.2.0.1.0)
  216. using sdo_geometry
  217. March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
  218. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  219. remove character...
  220. insert in a string... plsql
  221. Where does jdbc2_0-stdext.jar come from?
  222. Where Clause on Nested Selects
  223. Statistics for comp.databases.oracle.server - WE 02/29/2004
  224. problem installing oracle9i on windows2003
  225. Need help acquiring a database PLEASE!
  226. Error 503 Server Temporarily Unavailable while executing plsql procedure in mod_plsql
  227. vc++ error while compiling pro*c precompiled code
  228. Finding first saturday of month
  229. stored proc returning array
  230. MERGE bug?
  231. silent install oracle 9ias
  232. ORA-01458 invalid length inside variable character string
  233. Oracle 9i Qs: URL contains extra characters and how to maximize servelet
  234. world atlas database
  235. java.lang.ArrayIndexOutOfBoundsException when i want connect me to Oracle 9i
  236. Oracle OCI, COM+, dblinks and Multi Threaded Server????
  237. Control Characters in column
  238. rollup not working
  239. Memory leak
  240. Oracle 9i cannot display bfile image properly
  241. Sqlloader: All database in one single plain text file
  242. data handling issue
  243. OCI Tutorial needed
  244. Sometimes ORA-24388 problem - please advice
  245. ORA-24388 problem *Sometimes* - please advice
  246. Package compilation error
  247. Advanced replication: Setting timeout for insert transactions
  248. RPC_FAILED
  249. Mutating tables
  250. ORA-12571, ORA-03114 and other connection errors.
  251. Looking for a file
  252. Can I concatenate varchar2 and long datatypes together?
  253. Reporting
  254. sql file
  255. Need help on a query with analytics
  256. process serial number: serial# in v$process
  257. Calculating SUM and COUNT in one statement
  258. [HELP]Using Oracle9i db to call .Net Web Service from Java Stored Procedure
  259. "EXEC SQL DESCRIBE SELECT LIST" returns "Specified partition does not exist"
  260. A design question
  261. under-transaction ?
  262. Replace LOV with Dropdown
  263. Oracle reports v 6 (&crm ebusiness)--sql query, of using decode
  264. Complex query
  265. ASP programmer looking for Oracle 9i book to get started
  266. tkprof output
  267. Installing Oracle 9 in WinXP
  268. Oracle 9 - tablespace default storage
  269. SQLPLUS command line question
  270. Simple SQL to display text
  271. using case, Valid statement?
  272. ORA-00604 ORA-04031 while issuing a DROP USER USER_NAME CASCADE statement
  273. Error in calling external procedure
  274. Views and Stored Procedures
  275. column name can't include character '-'
  276. CLOB.createTemporary throws ClassCastException - fyi
  277. union of tnsnames.ora
  278. Problem with some SQL queries
  279. Recursive SQL in a events 10046 trace file
  280. append a table onto the end of another
  281. How to protect a PL/SQL proc / func from running more than oneinstance simultaenously
  282. scheduling a PL/SQL proc / function
  283. Oracle ODBC Driver
  284. Mutating table error
  285. Informix to Oracle 9i Migration No Suitable Driver error
  286. Traling spaces in result?
  287. Does Oracle Form allow Multi-thread processing ?
  288. Access violation in JREW.EXE while installing Oracle 8i
  289. Oracle patches
  290. VB Oracle stored procedure problem
  291. Io exception: The Network Adapter could not establish the connection
  292. Database design for large numbers of attributes
  293. Java Stored Procedures
  294. Basic PL/SQL script needed
  295. Pls save me
  296. ora-00600 [12700] on SYS.EXU8REF
  297. test this group
  298. Oracle locking up..?
  299. How to fill empty column with number sequence?
  300. trigger puzzlement
  301. Improper result when number table is used to substitute the "IN" clause in oracle
  302. Oracle 9i
  303. oracle on ultra5
  304. How to test for a null value in a date column
  305. automatic refresh of materialized view does not work
  306. SQL Query - Selecting records that repeat / occur more than once in a table -- newbe question
  307. Problem trying to update a record with a value returned by a function
  308. Efficient data model to represent range
  309. Protocol Violation when user password is expired
  310. nt.stp(905) error while installing Ora. Designer 6i
  311. Database query with subselect
  312. extract numeric part from address
  313. Oracle Apache Session
  314. Agent Configuration Assistant Failed during install
  315. Oracle ODBC 3151 Eroor
  316. What is max doing across fields in a de-duplication ?
  317. PL/SQL trigger fires once a day
  318. Oracle Rman Replication
  319. PL/SQL question
  320. Nested blocks in PL/SQL
  321. Oracle Concepts Question
  322. Need to compile and execute plsql files from remote machine
  323. Object Relational Feature
  324. tricky SQL question!
  325. no performance when creating or extending a tablespace
  326. Loading from a column
  327. Analytical Functions Question
  328. count # of unioned values
  329. Strange TNSNAMES.ORA problem
  330. Storing oracle procedures on server from inside.
  331. Suppressing newline during a SELECT returning multiple rows
  332. A Query about GRANT ALL PRIVILEGES in ORACLE
  333. Transactional haywire...
  334. need help with net8!
  335. Running batch under OWF
  336. How can I make this trigger?
  337. where are the rman scripts?
  338. Problems installing oracle on Win2000
  339. snapshot
  340. Help
  341. updating all tables with a column column
  342. I needhelp
  343. View for prime numbers
  344. Any progammers looking for a killer app to develop? How about a voice enabled forum?
  345. Oracle Connector for Outlook XP/2002 & HTML mail
  346. How can create case-insensitive database in oracle?
  347. SQL*Plus and Shell Programming
  348. Help with OCI oracle 8.1.7 compilation
  349. query issue
  350. Passing multi values into an in clause via a parameter in a store procedure
  351. Oracle Java Stored Procedures Hand
  352. No answer for your problem ?
  353. Oracle Licence
  354. designer2000
  355. Vote tally for period FAQ posting
  356. Handle count leak when connecting to Oracle via ODBC on Windows
  357. need aid with this query
  358. install Oracle9i on Redhat 9
  359. Installation problem help me plz...
  360. Index creation too long
  361. -- advatage BLOB or file on file system --
  362. Need help with SQL Query
  363. Help with ORA-01830 error.
  364. "Union all" and "UNION" ???? Return the same result or not ??
  365. Informix to Oracle Migration
  366. Inserting multiple rows in sqlplus
  367. enqueue statspack top5 timed events
  368. Pass unix variable to sqlplus
  369. Trigger based replication
  370. Very strange IO problems
  371. Snapshot Materialized view : how to ?
  372. iFS or Lobs + InterMEdia
  373. Reports error in 9iAS R2
  374. Renaming an Oracle Server
  375. Oracle Client conflicts between versions
  376. stats pack ?/interpretation
  377. Migrating questions
  378. Install web based Oracle Discoverer
  379. query results slow from db
  380. Foreign key refer to unique constraint????
  381. Universal Installer 9i
  382. Test
  383. DBCA and RAW devices
  384. Connecting from Windows
  385. Oracle designer container problem, please help
  386. Oracle and OpenSource
  387. warehousebuilder deployment manager error
  388. How to create trigger for all user ?
  389. How to display Text after loggin on database
  390. High performance replication ?
  391. With grant option vs with admin option
  392. Oracle Warehouse Builder.........
  393. Final CFV: comp.databases.oracle Periodic FAQ Post
  394. Oracle RAC on Linux...
  395. view puzzle
  396. Where do I get JDK 1.3 that Oracle Lite 5.0.2 wants?
  397. how to create query ??????????
  398. killed session
  399. use of escape character in sql
  400. Reuse Connect dialog box on forms 6i run time to connect to another database
  401. SQL Commands to interact with Windows Files in 9iR2
  402. Oracle 9IR2 OLAP and BI Beans - How to get it working
  403. PL/SQL Compile Problem
  404. SQL question
  405. Help: need avg(timestamp1 - timestamp2), get type error
  406. I found the answer
  407. Open cursors
  408. Cannot read from sys.v_$session
  409. Oracle Warehouse Builder 9.2.0.2.8 and Workflow 2.6.2 on linux
  410. Oracle DB Type List
  411. A SQL Question
  412. Oracle vs. MS SQL Server
  413. upgrade 8.1.6 clients to 8.17
  414. Export/Import problem
  415. Oracle Client software for HPUX 10.20
  416. restrict user's view
  417. copy a role
  418. what is the most difficult situation u faced & how did u solved it . . i need some best answers for this question as an oracle (DBA)
  419. assotiating SQL text from the V$%SQL% views with sessions
  420. EMC SAN and refreshing snapshots
  421. oracle database for academic
  422. Urgent Query
  423. Perf. degradation due to TIMESTAMP WITH TZ
  424. How to prevent modifying oracle data through MS access or VC++ sql screen.
  425. Minimum Installation for 8.1.7 Client for W2K for ODBC Connection
  426. Help requested..Missing Protocols Oracle 9i.
  427. URGENT ---------> SQLLDR ERROR
  428. what is SQL*Net
  429. Power Objects
  430. Format sqltext from v$sqltext
  431. Executing SQL via MDAC ODBC multiple statements?
  432. PL/SQL package gets invalidated seemingly at random
  433. Know whether oracle is installed or not
  434. Chargement d'un fichier csv calqué sur une vue
  435. meaning of TNS (Transparent Network Substrate)
  436. check who delete the role
  437. user authorazation
  438. Wot, me worried?
  439. How to sign up
  440. Run SQL Script under SYS for other Schema
  441. INSERT Through Pro*C in UTF 8 DB
  442. SQL to retrieve min value of the combination
  443. libobk source code?
  444. regarding oracle 9i installation
  445. oracle listener
  446. oracle Performance decrease when number of connections increase
  447. DBCA fails on Windows ME
  448. Password question
  449. Regarding ORacle 9i installation
  450. Analyzing queries
  451. newby question
  452. basic PL/SQL questions
  453. HELP: create user
  454. ORA03113: end-of-file on communication channel
  455. Adding Index to Table may reduce performance of Some Select Statements ?
  456. Loader and dbf files
  457. PLS-00201 and ORA-00942 when creating a package
  458. Query from the Aggregated Query with different projection
  459. How can I check the Users who are online ?
  460. TNS:protocol adapter error
  461. TNS:protocol adapter error
  462. Check out this critical package for Microsoft Internet Explorer
  463. Information Needed Regarding Oracle Forms 6i
  464. TAF without RAC or OPS
  465. Oracle Security conversion..
  466. Granting sysdba to a user
  467. Problem with date
  468. Any other site other than google that have groups on some specialization like this one
  469. How to rellocate Sun Solaris disk space where oracle installed
  470. Test Case02:: Asynchronous Replication on Oracle 9i Release 2
  471. Error in starting Oracle agent and ORA:01031 on SQLPLUS
  472. What privilege needs to be granted?
  473. Creating a DTS package programaticaly
  474. Replication Test case 01 on Oracle 9i
  475. Standby Database.. Error in password file..
  476. SQL
  477. Help Needed Regarding Oracle Migration
  478. Connecting Windows Clients to Oracle
  479. How can I combine three tables in a View or a Procedure?
  480. term 'Bulk Connects'
  481. 9i oracle oracle enterprise manager
  482. Linked Server to Oracle
  483. how to install Perl DBI and DBD-Oracle Modules ?
  484. PROSPECTUS UK AGENCY - SUFFOLK UK
  485. Help requested ! Protocol Adapters Missing oracle 9i...
  486. how to use plsql to calculate compond growth
  487. INNER JOIN
  488. ERROR in Standby database setup with RH9
  489. Oracle9i standby database setup in RH9 .. a minor error pls help
  490. Listener cannot read SERVICE_NAME in TNS-Descriptor
  491. Need utility to update one db (Sybase) from another (Oracle)
  492. Strategy and simple Listener Problem Xplained once more..
  493. Nested Tables in Oracle
  494. Long time to log in
  495. CFV: comp.databases.oracle Periodic FAQ Post
  496. Documenting Oracle procedures
  497. Windows 2003 and Oracle 9i with shared storage.
  498. A simple Listener problem while installing Oracle by copying Ora Home
  499. combining several SQL statements to run sequentially??????
  500. CGI and Oracle 9i
  501. How to improve the deletion rate.
  502. Disable Rollback
  503. windows 2003 and oracle
  504. WTD: Oracle DBA Cert classes w/ Cert pass guarantee - OCP test prep class?
  505. Numeric overflow
  506. bulk execute procedure using odbc
  507. Oracle workaround to the STUFF() MSSQL Function?
  508. EXCEPTION block called erroneously - help
  509. Bulk-bind input and output host arrays to index-by tables
  510. Oracle Help System
  511. Will copying Oracle home directory install Oracle 9i on RH linux 9 system ?
  512. Installation of Oraclewarehouse Builder
  513. Shared Physical Storage .. in Windows Server systems
  514. ODBC produces logoff event?
  515. Index and foreign key
  516. Loading xerces parser in oracle 9i
  517. get default funtion of a column
  518. change perl used by oracle apache on windows 2000
  519. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  520. Sample to pull data from Oracle proc into an html table
  521. Anybody using OEM to monitor MS SQLServer?? Need some tips!
  522. JDBC driver problem
  523. Spool
  524. Database link: Wrong column length from cursor
  525. Where do SQL/PL programs execute from ?
  526. re-numbering pimary-key
  527. Where to find Demo database with gnarly PL/SQL?
  528. OCI bug - ofetch hangs
  529. EXECUTE IMMEDIATE help
  530. SQL Batch Script from MSSQL to Oracle 8i
  531. Moving a table from one tablespace to another tablespace
  532. Bulk Inserts
  533. Oracle 9i OEM login NullPointerException to OMS
  534. How to create a descending index on the primary key.
  535. SQL Loader
  536. its a basic SQL command but require help ?
  537. Basic idea od Crystal reports
  538. 9.2 init.ora file on XP
  539. validate password within PL/SQL?
  540. External Tables binding to Access?
  541. changing date format in update statement
  542. procedures and table scope... PLS-00201
  543. XSU insert into view with object type
  544. Update Problem
  545. UTF-8 and Pro*C
  546. Bulk Updates in Oracle from XML File
  547. RAID
  548. Oracle 9i personal on Windows ME
  549. running utl_file
  550. running utl_file