View Full Version : oracle answers


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

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