View Full Version : oracle answers


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

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