View Full Version : answers

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