View Full Version : oracle answers

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

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