View Full Version : oracle answers


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

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