View Full Version : answers


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

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