View Full Version : oracle answers


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

  1. Oracle MERGE Statement Error
  2. Oracle 8i defrag
  3. Oracle Application Server webcached leaking file handles
  4. Connecting mobile application to database
  5. Empty string behaviour...
  6. Upgrade from 10.1 to 10.2
  7. Oracle data unload into DB2
  8. Sqlplus (set verify command)
  9. Oracle Rac
  10. SQL re-parsing on query executed against a remote database usingdatabase links
  11. Questions regarding materialized view logs ...
  12. help!...Call Oracle Store Procedure in a Package
  13. Wanted:Oracle Portal Course Material
  14. BLOB from Oracle
  15. Joins vs nested selects
  16. Oracle and Postgre SQL Help
  17. Virtual Indexes
  18. question about internal
  19. Inpersonate a user
  20. I cannot install emca anymore on oradb10g which runs o.k. after upgrade mac osX 10.4.2
  21. Question about init file
  22. Binding an array to an input variable in OCI
  23. Very basic question
  24. Oracle Vs. Ms Sql: Comparing Date To Variable
  25. Help needed to connect DB2k on PC to v7.3 on VMS
  26. SELECTing multiple rows to a single output line
  27. Oracle 10G RAC stability problems
  28. whether timestamp types are supported in oracle dynamic sql?
  29. oracle designer-timestamp-date
  30. PowerPoint Slides Available for Intro & Advanced DB Course
  31. Mysterious 9.2.0.4 (on HP-UX) problem
  32. PL/SQL Object Question
  33. Help with JDBC
  34. ff
  35. why to migrate from infromix to oracle
  36. How to do UPDATE with GROUP BY
  37. Oracle 7.3 v 9.2 client connection problems
  38. ORA 7.3 v 9.2 client conneection problems
  39. "No size set for variable length data" Oracle update error with empty string in .NET
  40. tnsnames.ora
  41. XML Batch Processing (large files)
  42. with clause for subquery factoring
  43. UTL_FILE(HELP)
  44. DW + Oracle: see tbls w/ recordset but not insert
  45. Rules Engine
  46. Convert timestamp to date
  47. Oracle Reports JDBCPDS
  48. Changing db_block_size
  49. Great News Blog!
  50. Which Operation of the Complex SQL is doing full table scan
  51. Fast bulk load with API?
  52. Is it possible to delete parts of a table without using rollback??
  53. Help needed for Database Replication
  54. Why you don't usually get answers here ...
  55. Why you don't usually get answers here ...
  56. SQL - Select and filtering whereby a date is not null.
  57. Forms Builder speed
  58. Performance difference between Windows and Solaris 10g
  59. Sequence Error ORA-02287
  60. Order By Performance Problem on View
  61. How to build database to support user-specified entities and attributes?
  62. Pivot query in oracle- Please help!!
  63. Pivot query in oracle- Please help!!
  64. Read Text file into Oracle Reports
  65. OCI library for Oracle 8.1.7.4.0 on OpenVMS
  66. Follow up to previous post
  67. SQL Query
  68. AVG and SUM in subquery return wrong values
  69. Invalid attribute/identifier error
  70. XML joining Nested resultsets
  71. How to build database to support user-specified attributes?
  72. port/protocol for sqlplus connectivity
  73. Problems: Oracle 9 Installation and Windows XP SP2
  74. Oracle 9 Installation Problems under Windows XP SP2
  75. install oracle 8.1.7 and developer 6i under same oracle home.
  76. Installing Oracle on Linux Redhat
  77. Converting a bare number to an interval and back
  78. ORA-29531 - And the method is declared both PUBLIC and STATIC
  79. External SQL functions exported by DLLs
  80. How to debug .pc file instead of debug generated .c file?
  81. PL SQL Cursor beginner
  82. Aarrrgh - this is NOT the place to ask!!
  83. Flashback over database link
  84. Pro*c for Windows
  85. how to do dbms_application_info.set_module from JDBC code
  86. SQL - Date Math question
  87. Pro*c for Windows
  88. Sample database with SQL triggers
  89. Open help file through forms 6
  90. Oracle Software Updates fees
  91. PL/SQL Examples
  92. Export of data
  93. Calling an Oracle stored procedure
  94. Invalid Date Stored In Oracle - Any Guesses ?
  95. how can I connect to oracle in C language?
  96. How to pass an Integer Array to a Stored Procedure?
  97. Version control of Oracle Stored Objects.
  98. Oracle Text for searchengine across multiple columns/tables with different datastore
  99. UTL_SMTP Stripping MIME-Version header information
  100. UTL_SMTP Stripping MIME-Version header information
  101. Pro*COBOL and (possible) NULL host variabe in WHERE condition
  102. DB2 User Group Italy - next meetings March 2005
  103. object_id vs data_object_id in user_objects
  104. Oracle to SQL Server using JDBC
  105. format date with Oracle Dynamic SQL
  106. Oracl Lite 10g and ADO.NET problem :(
  107. Need latest patch for 6i Tools
  108. Printing Bitmap instead of Character
  109. Does Oracle JDBC driver support data compression
  110. Pls help,oracle error
  111. How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer
  112. iSQLPlusTimeOutInterval in 10g
  113. sqlplus 10g and OS X
  114. Alternatives to SQL *Plus
  115. Converting a type (e.g. Decimal) BEFORE writing to ResultSet ?
  116. Comparing DATE with TIMESTAMP fields possible ?
  117. serious problem in advanced replication
  118. I need records to be in the same order as they were inserted in
  119. Inner join with where
  120. Trigger insert on parent table question
  121. moving oracle DBs & 9ias from system A to system B
  122. OBE error
  123. Spotlight For Oracle
  124. Can you help me with JDBC getDate() error?
  125. Retrieving database record with the lowest value in field aaa?
  126. Converting NUMBER, DATE and VARCHAR2 database fields from Resultset to variables?
  127. Getting MetaData for JDBC tables with getTables() does not work?
  128. J monografia Administração J
  129. Detecting the INSERT format for DATE database fields?
  130. DB2 Crushes Oracle RAC on TPC-C benchmark
  131. CLOB: Why are they so slow (compared with VARCHAR2)
  132. Instant Client 10g
  133. Help, need hiring manager input
  134. replication and primary key
  135. Looking for authoritative reference on PL/SQL grammar
  136. acceptable way to program
  137. Ocp Certificate Question
  138. Minimal Install Config?
  139. What (dev) tools does Oracle use (internally) to create applications of the E-Business suite 11i or older version?
  140. A possible breakthrough in analyzing 500GB+ data bases
  141. configuration management
  142. design of application / schema / multiple development schemas
  143. table API
  144. ora-04021 - how to analyze
  145. Which oracle server ?
  146. DLookup uses twice the SEQUENCE numbers
  147. Breaking News: MySQL beats Oracle in Benchmark
  148. Unhandled Exception on Oracle Form Builder
  149. website hosting
  150. common UPDATE syntax for SqlServer and Oracle
  151. to oracle or to ms sql server 03
  152. Avoiding automatically starting Oracle
  153. MOLAP info
  154. Inserting a value for a BLOB field using an SQL script
  155. I found this great little site
  156. Debugging "Table Mutating" errors... 8.1.6
  157. Function called for row not in query result
  158. [q] Designers
  159. DBA Needed
  160. Cross: Molio bih preporuku...
  161. Oracle DST Setting in OpenVMS Version.
  162. Native Delphi driver
  163. Oracle Download Fails (Disk Full)
  164. HELP: ORA-12571: Packet writer failure
  165. Linked Server (Oracle 9i)
  166. barcode function
  167. Dynamically execute PL/SQL statement
  168. insert into returns 0 rows
  169. 9i DBA Fundamentals I CDROM
  170. Why would explicit system privileges work and inherited through a role fail?
  171. Unique constraint and NULL values
  172. Oracle Forms Developer error on Oracle9i Developer Suite
  173. membership operator with pattern matching
  174. selecting a column according to a minimum
  175. RMAN
  176. Comparison of DB2 and Oracle?
  177. how to sql query this?
  178. How to Fail at Software Development
  179. Uninstalling Oracle9i Personal Edition
  180. How to specify column header titles in a SQL CREATE TABLE statement?
  181. MSAccess and Oracle
  182. Oracle Frontend / Backend Protocol
  183. Server Data on Insert property
  184. Oracle 10g & EM
  185. Number of Quarters
  186. How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
  187. Good tutorial or book on Oracle db?
  188. Distributed transactions and Oracle RAC load balancing problems - advice needed!
  189. ADO Addnew and identity columns
  190. cursor select/delete where current of not working
  191. Missing from one table
  192. Data not importing correctly
  193. Oracle programs - no source, only executable?
  194. Using the NEW_TIME function
  195. Calling COM or DLL's from triggers ?
  196. Implementing complicated constraints
  197. Service Temporarily Unavailable (Help)
  198. Update question
  199. hi
  200. Failing to connect to Oracle Server in ASP Session_OnEnd
  201. Selecting a column twice
  202. 9i and W2003 server
  203. 10g timestamp
  204. GLOBAL TEMPORARY table - serious join performance problem
  205. Desperation Post JDev/Applets
  206. REF CURSOR returned from Java -- How to use?
  207. problems with export
  208. Oracle ODBC connection problem
  209. Retrieve the DBMS_OUTPUT buffer from ASP/ADO
  210. Question about commit
  211. Optimization advice
  212. Anybody used the Universal Table Browser?
  213. Can we delete files from cdump folder
  214. Oracle9i: very big problem with precition of SYSTIMESTAMP !
  215. Granting privileges on table owned by different owner
  216. Granting the privileges of existing objects within a schema to a new role
  217. Oracle 9i: Problems with SQL parameters
  218. dead.letter in my RMAN backuppiece
  219. accessing a view from another user
  220. Oracle Data Server
  221. Oracle 11i position/Ottawa/Canada
  222. test
  223. Caompaq fire wire usb 2.0 PCI cards and Redhat Linux / Oracle RAC10g
  224. Administration script to check DB
  225. Schema changes on on large tables
  226. Creating an EUL Gateway for Discoverer
  227. Creating a table in Oracle DB if it does not exist, using SQL
  228. user_tab_columns
  229. Migrating tablespace from dictionary managed to locally managed
  230. Index Organize Tables
  231. [q] How To Create Rpository
  232. how to identify 2 different session on same machine
  233. can I audit a truncate on a specific table in Oracle8?
  234. when to merge two databases
  235. Configuring 10g OEM for USER DEFINED ALERTS
  236. Bring over Oracle 9i db to Oracle 10g
  237. Oracle ODBC Drivers
  238. SQL Loader
  239. Oracle_sid
  240. Easy end user reporting and graphing tool for Oracle standard edition.
  241. New install of 10g
  242. SELECTION CRITERIA
  243. Openning/Shutting down Oracle database from the Client's SQL*Plus
  244. Tables without primary key
  245. 10g job scheduler errors
  246. Poor performance after oracle 8i upgrade
  247. Red Hat Professional Workstation
  248. Bakbone Software
  249. Help with Import ORACLE
  250. Installing 9i or 10G on Linux RedHat x86 - errors.
  251. test
  252. database structure problem - advice please?
  253. Start 10g Infrastructure and AS
  254. Again about Oracle 8i on Win XP Pro
  255. Create trigger on view with long raw column
  256. Java Tree In Oracle Forms
  257. Find the store with the Max Sales for each month
  258. Regarding query
  259. error linking oci7 with oracle9i on AIX 4.3
  260. Reorder Primary Key - any problem?
  261. Oracle Database performance on Windows 2003 with IIS 6
  262. Create ResultSet "from scratch" in Oracle Java Stored Procedure?
  263. Oracle error
  264. can you intergrate oracl REPORTS with version constrol software LIKE.....
  265. oracle
  266. PLS-00306: wrong number or types of arguments in call to '||'
  267. Migrating from HP-UX to AIX
  268. Installing Oracle 9.2 without using OUI (Alpha OpenVMS 7.3-1)
  269. Subject: Oracle Analysts, Designers, Developers needed. Oracle 9i, 11i, PL/SQL, tools knowledge etc
  270. AIX CIO with Oracle
  271. For Billy Verreynne
  272. import dmp into SQL Server
  273. Covert Oracle SQL to MSSQL statement?
  274. basic plsql question
  275. SQL optimizations in Oracle
  276. Killing oracle sessions
  277. Oracle (6i) application crashes in Citrix farm with error ORA-06508.
  278. Oracle (6i) application crashes in Citrix farm with error ORA-06508.
  279. Application Development Framwork for 10g and BC4J for 9i
  280. send a table of records from pro C to Oracle pl/sql stored procedure
  281. DBFlash for Oracle - looking for beta testers (modified post)
  282. DBFlash for Oracle - looking for beta testers
  283. db2 vs oracle
  284. PL/SQL Intervals are dizzy
  285. O8 reorganization or O9 upgrade - which first?
  286. Show/Hide column name
  287. Oracle administration and Performance - Linux Cluster vs Windows Cluster
  288. ORA-06502 PL/SQL character string buffer too small
  289. dbms_job polling interval
  290. table relationships
  291. Oracle Forms Reference
  292. PROC Problem : Select for update
  293. [9i] Not enough large pool during export
  294. Is the Oracle ORAOLEDB.DLL oledb driver thread safe?
  295. Oracle 11i with AIX 5.2
  296. TNSPING works SQLPLUS fails whsn connecting to remote server
  297. connections differences between 8i and 9i
  298. Large Table Update/Merge problem
  299. FETCH arbitrary columns from a ref_cursor
  300. ORA-12154: TNS:could not resolve service name
  301. Understanding "lsnrctl status"
  302. [q] IMAGE
  303. Question on select count()
  304. RMAN resynchonize question
  305. How to call a private package level function
  306. Convert Long to Varchar
  307. direct path insert
  308. how to increase processes?
  309. How to return a status from sqlplus to .ksh unix script ?
  310. PL/SQL error !
  311. change port number
  312. Resizing the SGA
  313. How to bulk insert an array to Binary data using OCI.
  314. question about Oracle certification
  315. problem w/ creating view to show previous year's data...
  316. ingres odbc driver
  317. Select query for sum of hours
  318. How to UPDATE using ROWNUM and ORDER BY
  319. Unable to install Oracle 9i on IBM R51 notebook
  320. Oracle 9i: Keep multiple servers in sync
  321. Insert multiple rows via XML?
  322. calculating aggregates over row intervals in an update
  323. Transactions on remote databases
  324. SQL Update with a Join Syntax
  325. HOW to USE 'LONG RAW' in Bulk Insertion using OCI
  326. SQL 9i OUTER JOIN QUERY
  327. PL/SQL problem with Updates that specify varchar
  328. ORA-00054: resource busy... - what on Earth?
  329. Calculating Average on columns with zeros.
  330. Report Generator for Oracle and other RDBMS - beta testers needed
  331. Oracle Forms
  332. How to insert an Array to Oracle?
  333. Conversion UTF-8 -> CL8MSWIN1251
  334. encapsulate/embed pl/sql in DAO
  335. sql - statement: building differences between data-sets
  336. View-Concept Data Mining Oracle
  337. Enterprise OpenSource Project using Java Stored Procedures of Oracle
  338. tablespace
  339. Dynamic SGA and pinned
  340. Error message on ODBC Connection
  341. Problem with Oracle
  342. Corrupt Primary Key index on table causing ORA-600 internal error
  343. Java Stored Procedure extraction from Oracle database.
  344. Fastest for Inserting into Oracle?
  345. Invalid attribute in connection string. Nuby needs HELP!
  346. low cardinality and highly concurrent db
  347. Oracle SQL query by date
  348. dynamic sql substr length strange value (aix/hp differences?)
  349. Law for ORACLE administrators
  350. Database design
  351. Report Generator for Oracle and other RDBMS - beta testers needed
  352. Oracle JDBC connection string : how to hide password ?
  353. Easy as Oracle Forms, powerful as java
  354. rowid ?
  355. Oracle Noob need help with function
  356. How to lock a row over a SELECT followed by an UPDATE
  357. SQL*Plus Parameters
  358. Query Performance
  359. Trying to store field values in a variable
  360. is Oracle technically better than Ingres ?
  361. PL/SQL - ref cursor
  362. Oracle10g on Solaris10
  363. Arnold Schwarzenegger Commits Suicide
  364. query help
  365. Report Generator for Oracle and other RDBMS - beta testers needed
  366. PL/SQL online programming courses
  367. getting server name and db name
  368. Recovery From Loss Of Control File
  369. DB Logoff vs. Schema Logoff
  370. Cisco Access Control Server and Oracle Internet Directory
  371. Couple of Days Oracle Work Available in Surrey
  372. Ahhhhhhhh
  373. INFORMIX equivalent of DBSERVERNAME in ORACLE
  374. Load Balancing in Oracle 9i Forms Application
  375. CBO bug?
  376. Output parameter and dynamic sql
  377. PL/SQL code
  378. Ordinal Function
  379. Oracle 10G Net Config fails to start - installation issue on Windows in a domain
  380. Misterious Error in Pro*C
  381. Pass variable into View?
  382. optimizing sql joins?
  383. Oracel database consolidation criteria
  384. Manually convert data from ZHS16GBK to UTF8 on ORACLE 8(Character Set US7ASCII)
  385. accessing multiple instances
  386. sql corrector
  387. Optimizing Sql - unable to use index
  388. Wrapping up of Views in Oracle DB
  389. Return multiple queries from stored procedures
  390. Return multiple queries from stored procedures
  391. archived active redo logfile group corrupted
  392. Transform Cursor to Bulk
  393. Oracle DB with Pro/5
  394. Oracle ETL consultant (discoverer & warehouse builder exp.) - canada
  395. SQL Problem
  396. update table a.fkid from table b.pkid
  397. Pro*COBOL Precompiler - Generic Make File
  398. Oracle column default value
  399. Oracle column default value
  400. Optimising Oracle 9i for million-record JDBC read-only access
  401. Rollback segs,
  402. connecting to Oracle via .net web application
  403. Using the same type in 2 instance
  404. Oracle 7.3.4 media for AIX 4.3
  405. Is Storage Capacity Planner available inOracle 10g?
  406. UTL_SMTP and attachments
  407. Oracle database creation
  408. system tablespace
  409. Autonomous procedure falsely committing?
  410. problem with windows and linux
  411. Get calling instance information in external procedure
  412. Installing Oracle XML DB ro Oracle 9.2 on HP
  413. os_authent_prefix
  414. Locking a Table Within an INSERT
  415. help!ORA-01445: cannot select ROWID from a join view without a key-preserved table
  416. Help writing an SQL Script
  417. Project help!
  418. sql*loader packed decimal date format to be loaded to Oracle.
  419. obtaining the PL/SQL code of packages ??
  420. REGEXP_LIKE
  421. User defined data elements
  422. update table a from table b
  423. How to Clear the List of Oracle Client Homes install on a User Machine...
  424. best reporting tool?
  425. I must be missing the obvious
  426. poor performance because of slow storage
  427. Oracle Dates through Data Provider - ORA-01858
  428. How do you create an XML document using SQL
  429. Trigger Question
  430. Export Problems
  431. Help Need for a Query
  432. Sql output problem in SQLPLUS....
  433. RUN_PRODUCT -- (6i to 9i Web)
  434. how can i join the comp.databases.oracle group?
  435. sql optimization
  436. having trouble installing 10g
  437. Export Problems
  438. OMLETv4 The Ultimate Visual Real Time Oracle Monitoring Tool
  439. dropping FGAC package
  440. Tomorrow...
  441. Performance issue with new 9i database
  442. Bad performance calling stored procedures
  443. Help Need for a Query
  444. Changing Login Banner
  445. ora-00600 error while connecting to oracle database
  446. How to track structural changes in db
  447. Book recommendations
  448. NLS_LANG and language of ORA-[xxxxx]
  449. URGENT HELP ME!
  450. Need help with an SQL query
  451. Q: recreate table with index on another tablespace
  452. convert string to int
  453. "shared memory realm not available" on Orc9i, W2k
  454. 11i Expense distribution report
  455. how to make a column at column no X, a primary key
  456. change long row to blob
  457. Problems installing oracle 9i on Suse Linux Pro 9.1
  458. Report Generator for Oracle and other RDBMS - beta testers needed
  459. Function Based Index and java.lang.String
  460. Devoloper licenses
  461. question about database design
  462. Upgrade question
  463. Backup Database
  464. Is there an equivalent of Microsoft DMO object in Oracle land ? Need to talk to Oracle from web page..
  465. how can i find out the bitwise OR in oracle
  466. Fetching from LONG in Pro*C
  467. RELICATION QUESTIONS
  468. Outer join problem
  469. Comments on InterSystems Cache Database Platform
  470. error when calling external c function
  471. Printing french accents
  472. Help me please!!
  473. recompiling the invalidated dependent packages
  474. control file heartbeat
  475. Need help on oracle 8i db
  476. UTL_FILE and Network path
  477. vs.net pro*c insert failed
  478. TOra
  479. NEED HELP and GUIDANCE!
  480. TOra - Error ORA-12705
  481. Some SQL Help Please
  482. Execution Consistency
  483. Fluctuating Cost with Range Scan
  484. Can't connect to oracle & java error
  485. Range Scan Cost Fluctuations
  486. GetString equivalent
  487. ORA-12560: TNS:protocol adapter error
  488. ORACLE Import and DISK SPACE OCCUPYING
  489. If exists in PL/sql
  490. compare many values from two tables
  491. escaping those darn ' in a package/procedure
  492. # of bill cycle
  493. Computer Books, Inc Oracle Books - up to 80% off
  494. replicating a database
  495. Start With Connect by usage without Prior keyword
  496. Sorting on NUMBER or DATE
  497. 9.2.0.4 Linux x86-64 version OEM tools missing
  498. LONGs with Oracle ODBC vs MS ODBC - Strange Translations
  499. Rollback and Commit
  500. Fine Grained Acces Control & cursor
  501. How to make a table insert trigger to hit a servlet?
  502. value of last identity inserted
  503. Last Identity added
  504. Data Modeling
  505. Timestamps and computing aggregate time.
  506. Unindexed foreign keys and full table scans
  507. How To?: Cursors and Recursion
  508. How can a 'non-owner' grant access to a table.
  509. creating a trigger on v$session.module
  510. tablespace SYSTEM used by others user, not sys. Help!
  511. Problem installing 10g on a laptop with DHCP
  512. Performance for deleting multiple records
  513. snapshot / materialized view with column types
  514. Scheduling Snapshot Refreshes
  515. Timeout on SQL calls when using the Oracle Provider for OLEDB
  516. How to return a record set from a PL/SQL procedure/function?
  517. problem calling Stored Procedure from Access
  518. ORACLE Import and DISK SPACE OCCUPYING
  519. FGAC and EMP_BASE_TABLE
  520. ora-01847 when updating a record...please help
  521. Variable inside a variable
  522. 10GAS on Linux with 10GDS on Windows XP.
  523. 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.
  524. Problem to move user in LDAP with the function DBMS_LDAP.rename_s
  525. Why ORACLE doesn't do it?
  526. creating a reports servlet - error 50125
  527. Oracle 9iAS Administrator Position Open with Major HealthcareCompany in Atlanta, GA
  528. Using pl/sql tables with Object types
  529. Career as a DBA
  530. SQL for Modeling Generalization Hierarchies
  531. Oracle Financials Proj Lead-Kingston, Jamaica-FT, bank
  532. FRM-10142 HTTP listener is not running question
  533. Moving to Visual Studio??
  534. Impact on Oracle8i (when upgrading HP Ux 11.0 to 11i)
  535. Use of 10G Database and App Server
  536. Oracle Workflow - 6 mths - Jamaica/Canada - Bank
  537. OMLETv4 The Ultimate Visual Real Time Oracle Monitoring Tool
  538. Update rows when in other table
  539. Trigger to delete record from one table with check on another table.
  540. Any suggestions to improve this query performance
  541. Grant Problem?
  542. why RESETLOGS and NORESETLOGS
  543. brain cramp or bug: inner join returns rows w/null
  544. Can NOT create Materialized View
  545. Can NOT create Materialized View
  546. Question on migrating from MSSQL temp tables and remote queries
  547. data integrity problem of Oracle 8.1.6 Standby Database
  548. IOWAIT time
  549. Host credentials?
  550. Oracle Connection Pooling