View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 [12] 13 14
  1. New to Oracle
  2. Create ordinary table out of XML Schema
  3. index statistics
  4. XML acceleration
  5. Oracle, loading a java .jar file with loadjava
  6. SQL to aggregate values into LIST
  7. Problems with Micorosft Update KB835732
  8. Proposing a new newsgroup
  9. not single- group group function
  10. SQL standards editor discusses SQL:2003, XQuery and APIs
  11. ORA-00947: WHY!?!?!?
  12. Missing ora_control1 ???
  13. Handle count leak when connecting to Oracle via ODBC on Windows
  14. Hyper-threading on RH AS2.1 with 9i (Standard)
  15. RBO vs CBO
  16. batch loading clobs
  17. batch loading clobs
  18. oracle and SQL3
  19. Certification on 9i .
  20. 9i's runInstaller - is their a commandline or windowless version?
  21. Discovery of node failing ..plz help!!
  22. utl_file issue
  23. 8.1.7 query results yielding erratic sort order
  24. Oracle 9i Installation
  25. LONG RAW AND #TABLESPACE
  26. Function used in where clause - executed too many times
  27. Merge two cursors data (select from a cursor?)
  28. what does '1' in 'Case.. when' do
  29. condtional display of a page in Oracle Reports
  30. oracle9i on which linux distribution in production? feedback needed plz
  31. 9i on RedHat 9?
  32. Dumb story short- need to recreate foreign keys in oracle db
  33. procedure for numering records - no effect
  34. Oracle client for DOS
  35. Oracle Reports and Oracle installation Q's
  36. conditional selection of 'AND'
  37. Updated lists: XQuery engines, JDBC and ODBC drivers, OLE DB and .NET providers, DB2 extenders
  38. count(*)
  39. test (please ignore)
  40. Oracle & WinXP Pro
  41. Grid Controls in Oracle Forms 6i and Up
  42. Oracle inactive connections
  43. sqlplus "Input is too long (>2499 char)" error
  44. solution
  45. data base link
  46. Inconsistent behaviour creating java stored objects using sqlplus in Oracle 8i
  47. Oracle JDeveloper 10g Goes Production
  48. Select for Update fails
  49. data base link
  50. Multi-User Password Database (Password Storage)
  51. oracle on windows cluster
  52. b-tree
  53. Running a query manually when using web modules
  54. Privilege problem with creation
  55. explicitly closing cursors
  56. MERGE on spatial indexed tables
  57. dynamic tablename with %rowtype
  58. Development Client
  59. Running Oracle Trace
  60. to check if a table exists
  61. Connection Oracle - Sybase
  62. Convert Qualify Rank from Teradata to DB2
  63. locking sga
  64. create table in a procedure
  65. Does anyone know of a good location for a data set?
  66. user interaction in pl/sql
  67. ORA-00911 in Dynamic SQL
  68. Rollback problem
  69. Please help !! Oracle 9i crashes on Windows XP SP1 without reason
  70. Printing a File From PL/SQL In Oracle 9i
  71. What is the problem my standby database step?
  72. How to avoid duplicates here...?
  73. jump 2 next iteration of FOR loop
  74. jump 2 next iteration of FOR loop
  75. Oracle Truncate problems
  76. Converting SQL Server to Oracle
  77. Rollback usage query
  78. how to Spool results from SQL plus
  79. row lock contention
  80. Can MERGE replace UPDATE/INSERT duo on a single table?
  81. Which software can capture all screen shots and composit them into a demo?
  82. Problem with Cross database join
  83. Oracle Problem 1: Please Help
  84. Missing Parenthese Error: ORA-00907
  85. Help with running totals
  86. Mandrake Oracle 9i Installation Problems (netmgr, netca)
  87. Problem with DB Propagate Assistent, (can't copy table data)
  88. Returning Variant data from Java to PL/SQL & SQL?
  89. Marrying SQL, XML, web services, grid computing (2 audio programs)
  90. cost based optimization
  91. What's your compensation for carrying a pager???
  92. Create New Oracle Database in AIX box
  93. Rule Based Optimization
  94. ora04021:timeout occurred while waiting to lock object ...
  95. Migrating db2 to Oracle 9i
  96. Setting Null values to Zero
  97. Help...
  98. Inserting an Oracle Instance into Clustered Oracle
  99. Bitand Question
  100. Custom Response File
  101. RAC and load-balancing a connection pool
  102. examining views
  103. Comment savoir quelle version d'Oracle Client est utilisée ?
  104. Data in Text file thru Stored procedure
  105. How to know wich Oracle Client release is used ?
  106. Creating foreign keys across different tablespace
  107. Using reserved word "MODE" in select queries
  108. datablock sizing
  109. Unable to revoke privileges from a user
  110. Next 33
  111. Business Intelligence - Oracle Financials 11.5.9
  112. is there any future to learn Oracle?
  113. how many tablespaces
  114. JAVA OCI Driver in 9.2.0.4
  115. BI tool users - message for u
  116. v$sqlarea in Oracle 9i
  117. A Couple of Questions on Views
  118. Char array not long enough: javaCharsToUtf8Bytes
  119. sql to find a numeric range inside another range?
  120. does sqlplus support :"select top 10 * from table1" syntax like MS SQL?
  121. Limit to number of items in a List [WHERE id IN (,,,,)]
  122. Help to optimize procedure (concatenation of rows)
  123. What is the bottom line on Oracle layout on Virtual Arrays?
  124. iSQL*Plus bug with substitution variable?! (9.2.0.1.0)
  125. using sdo_geometry
  126. March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
  127. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  128. insert in a string... plsql
  129. remove character...
  130. Where does jdbc2_0-stdext.jar come from?
  131. Where Clause on Nested Selects
  132. Statistics for comp.databases.oracle.server - WE 02/29/2004
  133. problem installing oracle9i on windows2003
  134. Need help acquiring a database PLEASE!
  135. Error 503 Server Temporarily Unavailable while executing plsql procedure in mod_plsql
  136. vc++ error while compiling pro*c precompiled code
  137. Finding first saturday of month
  138. stored proc returning array
  139. MERGE bug?
  140. silent install oracle 9ias
  141. ORA-01458 invalid length inside variable character string
  142. Oracle 9i Qs: URL contains extra characters and how to maximize servelet
  143. world atlas database
  144. Oracle OCI, COM+, dblinks and Multi Threaded Server????
  145. java.lang.ArrayIndexOutOfBoundsException when i want connect me to Oracle 9i
  146. Control Characters in column
  147. rollup not working
  148. Memory leak
  149. Oracle 9i cannot display bfile image properly
  150. Sqlloader: All database in one single plain text file
  151. data handling issue
  152. OCI Tutorial needed
  153. Sometimes ORA-24388 problem - please advice
  154. ORA-24388 problem *Sometimes* - please advice
  155. Package compilation error
  156. Advanced replication: Setting timeout for insert transactions
  157. RPC_FAILED
  158. Mutating tables
  159. ORA-12571, ORA-03114 and other connection errors.
  160. Looking for a file
  161. Can I concatenate varchar2 and long datatypes together?
  162. Reporting
  163. sql file
  164. Need help on a query with analytics
  165. process serial number: serial# in v$process
  166. Calculating SUM and COUNT in one statement
  167. [HELP]Using Oracle9i db to call .Net Web Service from Java Stored Procedure
  168. "EXEC SQL DESCRIBE SELECT LIST" returns "Specified partition does not exist"
  169. A design question
  170. under-transaction ?
  171. Replace LOV with Dropdown
  172. Oracle reports v 6 (&crm ebusiness)--sql query, of using decode
  173. Complex query
  174. ASP programmer looking for Oracle 9i book to get started
  175. tkprof output
  176. Installing Oracle 9 in WinXP
  177. Oracle 9 - tablespace default storage
  178. Simple SQL to display text
  179. SQLPLUS command line question
  180. using case, Valid statement?
  181. ORA-00604 ORA-04031 while issuing a DROP USER USER_NAME CASCADE statement
  182. Error in calling external procedure
  183. Views and Stored Procedures
  184. column name can't include character '-'
  185. CLOB.createTemporary throws ClassCastException - fyi
  186. union of tnsnames.ora
  187. Problem with some SQL queries
  188. Recursive SQL in a events 10046 trace file
  189. append a table onto the end of another
  190. How to protect a PL/SQL proc / func from running more than oneinstance simultaenously
  191. scheduling a PL/SQL proc / function
  192. Oracle ODBC Driver
  193. Mutating table error
  194. Informix to Oracle 9i Migration No Suitable Driver error
  195. Traling spaces in result?
  196. Does Oracle Form allow Multi-thread processing ?
  197. Access violation in JREW.EXE while installing Oracle 8i
  198. Oracle patches
  199. VB Oracle stored procedure problem
  200. Io exception: The Network Adapter could not establish the connection
  201. Database design for large numbers of attributes
  202. Java Stored Procedures
  203. Basic PL/SQL script needed
  204. Pls save me
  205. Connecticut Oracle Users Group in Hartford, CT -- Meeting with Rich Niemiec from TUSC Scheuled for Thursday March 18
  206. ora-00600 [12700] on SYS.EXU8REF
  207. test this group
  208. Oracle locking up..?
  209. How to fill empty column with number sequence?
  210. trigger puzzlement
  211. Improper result when number table is used to substitute the "IN" clause in oracle
  212. Oracle 9i
  213. oracle on ultra5
  214. How to test for a null value in a date column
  215. automatic refresh of materialized view does not work
  216. SQL Query - Selecting records that repeat / occur more than once in a table -- newbe question
  217. Problem trying to update a record with a value returned by a function
  218. Efficient data model to represent range
  219. Protocol Violation when user password is expired
  220. nt.stp(905) error while installing Ora. Designer 6i
  221. Database query with subselect
  222. extract numeric part from address
  223. Oracle Apache Session
  224. Agent Configuration Assistant Failed during install
  225. Oracle ODBC 3151 Eroor
  226. What is max doing across fields in a de-duplication ?
  227. PL/SQL trigger fires once a day
  228. Oracle Rman Replication
  229. PL/SQL question
  230. Nested blocks in PL/SQL
  231. Oracle Concepts Question
  232. Need to compile and execute plsql files from remote machine
  233. Object Relational Feature
  234. tricky SQL question!
  235. no performance when creating or extending a tablespace
  236. Loading from a column
  237. Analytical Functions Question
  238. Strange TNSNAMES.ORA problem
  239. count # of unioned values
  240. Storing oracle procedures on server from inside.
  241. Suppressing newline during a SELECT returning multiple rows
  242. A Query about GRANT ALL PRIVILEGES in ORACLE
  243. Transactional haywire...
  244. need help with net8!
  245. Running batch under OWF
  246. How can I make this trigger?
  247. where are the rman scripts?
  248. Problems installing oracle on Win2000
  249. snapshot
  250. Help
  251. updating all tables with a column column
  252. I needhelp
  253. View for prime numbers
  254. Any progammers looking for a killer app to develop? How about a voice enabled forum?
  255. Oracle Connector for Outlook XP/2002 & HTML mail
  256. How can create case-insensitive database in oracle?
  257. SQL*Plus and Shell Programming
  258. Help with OCI oracle 8.1.7 compilation
  259. query issue
  260. Passing multi values into an in clause via a parameter in a store procedure
  261. Oracle Java Stored Procedures Hand
  262. No answer for your problem ?
  263. Oracle Licence
  264. designer2000
  265. Vote tally for period FAQ posting
  266. Handle count leak when connecting to Oracle via ODBC on Windows
  267. need aid with this query
  268. install Oracle9i on Redhat 9
  269. Installation problem help me plz...
  270. Index creation too long
  271. -- advatage BLOB or file on file system --
  272. Need help with SQL Query
  273. Help with ORA-01830 error.
  274. "Union all" and "UNION" ???? Return the same result or not ??
  275. Informix to Oracle Migration
  276. Inserting multiple rows in sqlplus
  277. enqueue statspack top5 timed events
  278. Pass unix variable to sqlplus
  279. Trigger based replication
  280. Very strange IO problems
  281. Snapshot Materialized view : how to ?
  282. iFS or Lobs + InterMEdia
  283. Reports error in 9iAS R2
  284. Renaming an Oracle Server
  285. Oracle Client conflicts between versions
  286. stats pack ?/interpretation
  287. Migrating questions
  288. Install web based Oracle Discoverer
  289. query results slow from db
  290. Foreign key refer to unique constraint????
  291. Universal Installer 9i
  292. Test
  293. DBCA and RAW devices
  294. Connecting from Windows
  295. Oracle designer container problem, please help
  296. warehousebuilder deployment manager error
  297. Oracle and OpenSource
  298. How to create trigger for all user ?
  299. How to display Text after loggin on database
  300. High performance replication ?
  301. With grant option vs with admin option
  302. Oracle Warehouse Builder.........
  303. Final CFV: comp.databases.oracle Periodic FAQ Post
  304. Oracle RAC on Linux...
  305. Where do I get JDK 1.3 that Oracle Lite 5.0.2 wants?
  306. view puzzle
  307. how to create query ??????????
  308. killed session
  309. use of escape character in sql
  310. Reuse Connect dialog box on forms 6i run time to connect to another database
  311. SQL Commands to interact with Windows Files in 9iR2
  312. Oracle 9IR2 OLAP and BI Beans - How to get it working
  313. PL/SQL Compile Problem
  314. SQL question
  315. Help: need avg(timestamp1 - timestamp2), get type error
  316. I found the answer
  317. Cannot read from sys.v_$session
  318. Open cursors
  319. Oracle Warehouse Builder 9.2.0.2.8 and Workflow 2.6.2 on linux
  320. Oracle DB Type List
  321. A SQL Question
  322. Oracle vs. MS SQL Server
  323. upgrade 8.1.6 clients to 8.17
  324. Export/Import problem
  325. Oracle Client software for HPUX 10.20
  326. restrict user's view
  327. copy a role
  328. what is the most difficult situation u faced & how did u solved it . . i need some best answers for this question as an oracle (DBA)
  329. assotiating SQL text from the V$%SQL% views with sessions
  330. EMC SAN and refreshing snapshots
  331. Urgent Query
  332. oracle database for academic
  333. Perf. degradation due to TIMESTAMP WITH TZ
  334. How to prevent modifying oracle data through MS access or VC++ sql screen.
  335. Help requested..Missing Protocols Oracle 9i.
  336. Minimum Installation for 8.1.7 Client for W2K for ODBC Connection
  337. URGENT ---------> SQLLDR ERROR
  338. what is SQL*Net
  339. Power Objects
  340. Format sqltext from v$sqltext
  341. Executing SQL via MDAC ODBC multiple statements?
  342. PL/SQL package gets invalidated seemingly at random
  343. Know whether oracle is installed or not
  344. Chargement d'un fichier csv calqué sur une vue
  345. meaning of TNS (Transparent Network Substrate)
  346. check who delete the role
  347. user authorazation
  348. Wot, me worried?
  349. How to sign up
  350. Run SQL Script under SYS for other Schema
  351. INSERT Through Pro*C in UTF 8 DB
  352. SQL to retrieve min value of the combination
  353. libobk source code?
  354. regarding oracle 9i installation
  355. oracle listener
  356. oracle Performance decrease when number of connections increase
  357. DBCA fails on Windows ME
  358. Password question
  359. Regarding ORacle 9i installation
  360. Analyzing queries
  361. newby question
  362. basic PL/SQL questions
  363. HELP: create user
  364. ORA03113: end-of-file on communication channel
  365. Adding Index to Table may reduce performance of Some Select Statements ?
  366. Loader and dbf files
  367. PLS-00201 and ORA-00942 when creating a package
  368. Query from the Aggregated Query with different projection
  369. How can I check the Users who are online ?
  370. TNS:protocol adapter error
  371. TNS:protocol adapter error
  372. Check out this critical package for Microsoft Internet Explorer
  373. Information Needed Regarding Oracle Forms 6i
  374. TAF without RAC or OPS
  375. Oracle Security conversion..
  376. Granting sysdba to a user
  377. Problem with date
  378. Any other site other than google that have groups on some specialization like this one
  379. How to rellocate Sun Solaris disk space where oracle installed
  380. Test Case02:: Asynchronous Replication on Oracle 9i Release 2
  381. Error in starting Oracle agent and ORA:01031 on SQLPLUS
  382. What privilege needs to be granted?
  383. Creating a DTS package programaticaly
  384. Replication Test case 01 on Oracle 9i
  385. Standby Database.. Error in password file..
  386. SQL
  387. Help Needed Regarding Oracle Migration
  388. Connecting Windows Clients to Oracle
  389. How can I combine three tables in a View or a Procedure?
  390. term 'Bulk Connects'
  391. 9i oracle oracle enterprise manager
  392. Linked Server to Oracle
  393. how to install Perl DBI and DBD-Oracle Modules ?
  394. PROSPECTUS UK AGENCY - SUFFOLK UK
  395. Help requested ! Protocol Adapters Missing oracle 9i...
  396. how to use plsql to calculate compond growth
  397. INNER JOIN
  398. ERROR in Standby database setup with RH9
  399. Oracle9i standby database setup in RH9 .. a minor error pls help
  400. Listener cannot read SERVICE_NAME in TNS-Descriptor
  401. Need utility to update one db (Sybase) from another (Oracle)
  402. Strategy and simple Listener Problem Xplained once more..
  403. Nested Tables in Oracle
  404. Long time to log in
  405. CFV: comp.databases.oracle Periodic FAQ Post
  406. Documenting Oracle procedures
  407. Windows 2003 and Oracle 9i with shared storage.
  408. A simple Listener problem while installing Oracle by copying Ora Home
  409. combining several SQL statements to run sequentially??????
  410. CGI and Oracle 9i
  411. How to improve the deletion rate.
  412. Disable Rollback
  413. windows 2003 and oracle
  414. WTD: Oracle DBA Cert classes w/ Cert pass guarantee - OCP test prep class?
  415. Numeric overflow
  416. bulk execute procedure using odbc
  417. Oracle workaround to the STUFF() MSSQL Function?
  418. EXCEPTION block called erroneously - help
  419. Bulk-bind input and output host arrays to index-by tables
  420. Oracle Help System
  421. Will copying Oracle home directory install Oracle 9i on RH linux 9 system ?
  422. Installation of Oraclewarehouse Builder
  423. Shared Physical Storage .. in Windows Server systems
  424. ODBC produces logoff event?
  425. Index and foreign key
  426. Loading xerces parser in oracle 9i
  427. get default funtion of a column
  428. change perl used by oracle apache on windows 2000
  429. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  430. Sample to pull data from Oracle proc into an html table
  431. Anybody using OEM to monitor MS SQLServer?? Need some tips!
  432. JDBC driver problem
  433. Spool
  434. Database link: Wrong column length from cursor
  435. Where do SQL/PL programs execute from ?
  436. re-numbering pimary-key
  437. OCI bug - ofetch hangs
  438. Where to find Demo database with gnarly PL/SQL?
  439. EXECUTE IMMEDIATE help
  440. SQL Batch Script from MSSQL to Oracle 8i
  441. Moving a table from one tablespace to another tablespace
  442. Bulk Inserts
  443. Oracle 9i OEM login NullPointerException to OMS
  444. How to create a descending index on the primary key.
  445. SQL Loader
  446. Basic idea od Crystal reports
  447. its a basic SQL command but require help ?
  448. 9.2 init.ora file on XP
  449. validate password within PL/SQL?
  450. External Tables binding to Access?
  451. changing date format in update statement
  452. procedures and table scope... PLS-00201
  453. XSU insert into view with object type
  454. Update Problem
  455. UTF-8 and Pro*C
  456. Bulk Updates in Oracle from XML File
  457. RAID
  458. Oracle 9i personal on Windows ME
  459. running utl_file
  460. running utl_file
  461. Storing/retrieving BLOBs with JSPs
  462. /usr/lib/dld.sl: Unresolved symbol error
  463. Solaris expert needs to break into as entry-level Oracle dba
  464. SQL statement monitor/logger
  465. oo40 - number type and ODynaset
  466. dbms_alert_info table access from a schema
  467. How to know in a unix script if oracle procedure executed or failed?
  468. help needed to write a oracle function that can do this...
  469. Pass variable to Oracle Query form Crystal Reports
  470. CREATE TRIGGER odditiy
  471. Oracle 8.1.7 hsodbc agent on Tru64 UNIX 5.1B
  472. Where is OUI
  473. need help with PL/SQL Procedure
  474. TNSLSNR.exe - Application Error
  475. COLUMN WITH WORD_WRAP IN PL/SQL ????
  476. how to write a function to call this VB script
  477. case, nvl and datetime fields
  478. Strange TNS problem
  479. LDAP attribute list
  480. XMLType insert
  481. Full Time Database Consultants Needed
  482. can I remove jdk directory from C:\orant?
  483. Try on these security package
  484. Oracle Query
  485. DiskSuite RAID5 performace
  486. Loading from XML to Database
  487. Install this corrective update from the Microsoft
  488. Oracle's Mission Statement
  489. Help needed in Update SQL that uses an Inline Query View containing 'Partition By'
  490. Designer Forms: Linking update module component / stand-alone list of values
  491. JDBC driver setup in UNIX
  492. Looking for OAS 4.0.8.2 SW
  493. 9ias, fully qualified host name?
  494. Cursor, Fetch, and while...
  495. Need help to understand difference, and contrast between Relational database model and the Object-Oriented model
  496. 2nd CFV: comp.databases.etl
  497. SQL_TRACE Output Location
  498. Oracle 9i problem
  499. ORA-01026: multiple buffers of size > 4000 in the bind list
  500. Listener Configuration in Oracle 9i
  501. OMWB
  502. Dynamic SQL with PROC/C++ problem
  503. ORACLE 9 and Solaris 5.6
  504. Lock table only allow INSERT
  505. Max number of records can be fetched in oracle in one call
  506. 8i and SuSE 9 Pro
  507. More Help Required.. in Replication of Oracle 9i in Rh9 (if the query is repeated by me sorry)
  508. Reply: Replication Of Oracle 9i in RH9
  509. How to emulate WRITETEXT / Writing to LONG fields
  510. Oracle upgrade advice
  511. WinPure .. List Cleaner .. Opinions/Recommendations?
  512. redirect SQL Trace output
  513. Index on Number & Varchar2
  514. SYSRESV Utilitity for Windohs??
  515. select next highest salary or last login date ...
  516. Standby database on Standard Edition
  517. keyword override
  518. Install problem on Redhat
  519. how to install oracle 9iR2 on windows 2003?
  520. Replication Of Oracle 9i in RH9
  521. Question on debugging TNS-12560
  522. Beginners problem with assigning object methods.
  523. ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function
  524. No Data found error
  525. establish oracle connectiviy with oracle
  526. will Oracle 8i run on Novell Netware 5.0
  527. Addition of constraint during creation of table
  528. RFD: Periodic FAQ & Charter post
  529. Static to Dynamic linking
  530. Passing Java object as parameter to the java stored procedure
  531. Bug of function-based index
  532. new to reports 6i
  533. How to say it in SQL?
  534. Monitor SQL queries
  535. Fatal NI connect error 12560, connecting to:
  536. 816 proC on debian linux; mathcalls.h issue?
  537. Error changing Character Set
  538. ODBC for 8i Single user version
  539. TNS 12545 urgent !!
  540. [beginner] sequence
  541. IMPORTANT DEPENDENCIES QUESTION IN ORACLE.
  542. US - NJ - NY -- Urgent Requirement for Oracle OLAP developer(s) / consultant(s)
  543. Statistics information
  544. cursor problem
  545. Q: Oracle Forms on WinCE
  546. Help: Forms 6 Template
  547. trigger problem
  548. Oracle 9i Database Server on Windows 2003 Server
  549. How to load a TABLE fuilly in memory and keep it
  550. how to use select clause in assignment