View Full Version : oracle answers


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

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