View Full Version : oracle answers


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

  1. 8i to 9i upgrade
  2. Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
  3. Oracle Real Aplication Cluster
  4. Oracle Real Aplication Cluster
  5. Help needed in SQL Query for Hierarchy
  6. saving files as LOB to Db
  7. Oracle JDeveloper 10g Preview is out - includes many PL/SQL features
  8. Oracle 8i on WinXP?
  9. Getting structure of a table in query format
  10. How to create a SIMPLE distributed database in Oracle??
  11. what is the difference to use the password file and normal account to login?
  12. Problem with MERGE and database link
  13. ora-01031 insufficent privileges
  14. She doesn't want the ODBC users to see system views/tables via M$ Access.
  15. How tough can I be for the user PUBLIC?
  16. Diagnosing Transaction Enqueue (TX) Locking Issue
  17. Company thought DB2 will be better than Oracle.
  18. Re: XML problem on appendChild
  19. Prcedural replication issue
  20. external table
  21. RMAN restore with Windows
  22. Oracle vs. Informix
  23. question about password file
  24. number defined being truncated in select (sorry double posting ;-( )
  25. ORA-04030 with PGA_AGGREGATE_TARGET
  26. control file not created at the time of installation
  27. SS7 to Oracle 9i Migration Problems
  28. How to query a string containing an apostrophe ?
  29. Default User on Windows
  30. Contract Opportunity - Ottawa
  31. Conditional printing depending on number of returned rows
  32. Cannot connect as Internal....?
  33. How to write the select query on self referencing table.
  34. Integrity constraints with type inheritance
  35. Oracle Recover/Restore
  36. How to disabled all constraints when importing data (urgent)
  37. How to disabled all constraints when importing data (urgent)
  38. ORA-01000 maximum open cursors exceeded
  39. ora-01033.oracle initialized or shutdown in progress
  40. Oracle x SQL
  41. Help query
  42. MS Word to Blob
  43. Newbie basic SQL question.
  44. re:restricted built-ins
  45. About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
  46. About Error : ORA-01034 and ORA-27101 ( on Windows XP and Oracle 8.1.7 )
  47. SYSTEM Tablespace is FULL
  48. which SCHEMAS are actually needed?
  49. CHECK Constraint
  50. How fix ORA-01000: maximum open cursors exceeded with out closing Statement.
  51. Anybody Having STUDENT INFO SYSTEM Docomentation
  52. Get the date time from Oracle date time stamp?????
  53. Re: Generic Connectivity
  54. Re: SQLPROMPT in Sql*Plus
  55. Re: generate index ddl
  56. Cursor Value to Delimited String Variable??
  57. oracle on linux and windows on the computer
  58. How to unload data
  59. Teradata DBA in Chantilly, VA
  60. Formatting BRIO Reports
  61. mail merge with Oracle forms and Word
  62. viewing Stored Procedure Definition in SQL prompt
  63. table record distribution query.
  64. SSO error
  65. Oracle , Jdbc & Long Raw field
  66. how to view sample schema
  67. URGENT: VARRAY as Input/Output variable
  68. URGENT: VARRAY as Input/Output variable
  69. SQL*Loader - Commit point reached - logical record count 27
  70. controlled population of 1 million "generated" rows?
  71. How to insert BLOB?
  72. libclntsh.so Help!
  73. Commit transaction
  74. Slow slow Pro*C compilation with sqlcheck=semantic
  75. 1
  76. Re: books
  77. SAMPLE DATA NEEDS
  78. Big problem with Oracle Portal Migration
  79. Need Query without Union and minus.
  80. 8i to 9i changes
  81. Re: Indexing with interMedia
  82. Pfile Question
  83. Cursor parameters - problems with 'FROM [inTablename]' statement
  84. Discoverer inactivity timeout
  85. Oracle Backup
  86. oracle in solaris consume lot of memory
  87. oracle collabration suite experiences
  88. Show long number in Toad 7.5.2.0
  89. OCA & OCP Certification Books
  90. RTF to Text conversion
  91. Escape sequence
  92. moving a database
  93. Re: Chronological row-update procedure
  94. Blank line Inserted - I don't like it
  95. Oracle Reports 6 recompilation
  96. Right password -> ORA-12154: TNS:Could not resolve service name
  97. Problem configurating Apache
  98. Re: Enterprise Manager Question..
  99. Re: LNK2001: unresolved external symbol
  100. How do I rename null values found in GROUP BY column?
  101. Oracle/ASP hanging
  102. Updating LOB fields through ODBC, invalid LOB locator
  103. Input mask question
  104. migrate from sql server to oracle
  105. Oracle9iAS + JBuilder9
  106. materialized view. help...
  107. Re: Oracle Universal Installer does not run on Win2000 install..
  108. confused about ifs
  109. Re: LNK2001: unresolved external symbol
  110. problem in to_date function
  111. DBMS_SQL.define_column ---- why ????
  112. How to call dynamic remote stored procedure in the dynamic sql
  113. OCI Bind for RAW field, Cannot select a record matching a hexadecimal Key (raw type)
  114. Re: help with utl_smtp email headers
  115. Indexing multiple fields with Oracle TEXT (Intermedia)
  116. URGENT PROBLEM: refresh data in Discoverer
  117. Oracle - Commit Before invoking a trigger
  118. exception
  119. Invitation to Join SV_RFID!
  120. db2 runstats
  121. Korean data load from Excel sheet to Oracle table
  122. P4 Bug and 9iR2
  123. JDeveloper 11i
  124. Strange Utl_File Error on NT
  125. Integrating crystal reports with oracle forms
  126. Re: ODBC & Correlation Name (:new and :old)
  127. Oracle password change using the Verify Password function
  128. need a Sample online hot backup script for UNIX..
  129. BLOB and .NET
  130. Un-install Oracle Personal Edition 9i
  131. Re: ODBC & Correlation Name (:new and :old)
  132. full outer join question
  133. Problem installing Oracle 9i on XP
  134. Difficulty inserting due to &
  135. Re: help with utl_smtp email headers
  136. help with update sql
  137. PL/SQL Function Help
  138. comp.databases.oracle
  139. Re: Light Oracle 9i Client install
  140. Compilation unit analysis terminated?
  141. How to handle a long strings in a pl sql stored procedure,
  142. documentation on moving OraHome to different machine
  143. Reserved words with "ROW"
  144. Oracle 9i w2k Client error -Credential retrieval failed.
  145. I have a question with sqlplus...
  146. Re: Oracle 9i software- for DBA exam
  147. .NET OLE DB Connection
  148. Re: Error PLS-00201
  149. ODBC Escape {oj} problem w/ ADO
  150. Oracle ODBC error with ENCRYPTION
  151. Re: Instance question
  152. Downgrading 7.3.4
  153. Re: Instance question
  154. Java/Oracle thin driver SQL statement limit
  155. Help required with OCI
  156. Re: Dummies guide to fast inserts ?
  157. Re: OID configuration for replacing Oracle Names
  158. Statement returing True/False in decode() function
  159. Read Only Transactions
  160. Re: Oracle 8i VS Oracle 9i certificate
  161. Re: Oracle 8i VS Oracle 9i certificate
  162. How to Inactivate the Oracle User?
  163. Backup file format
  164. problem of installing oracle on linux
  165. Reports wont print on Citrix server
  166. How to reference table/view that has "slashes" in its name!
  167. Porting database from Oracle7.0 to Oracle8i
  168. Advanced Enterprise Database Planning/Design Books
  169. Oracle tablespace management
  170. Re: Oracle on Solaris-Intelx86?
  171. Re: 8.1.7 Make file errors on Red Hat AS 2.1
  172. Help needed in SQL Query
  173. Apache installation error
  174. using Autonomous transaction
  175. Re: Help please- Heterogenous services suing General Connectivity agent
  176. Accessing Oracle from VB
  177. Number of elements in "IN operator"
  178. Designer failing to reverse Engineer
  179. Writing binary data to external file
  180. Backup
  181. Re: Problems (with Oracle9) using OCI JDBC driver on AIX 5
  182. Re: Problems (with Oracle9) using OCI JDBC driver on AIX 5
  183. User is not allowed to work in a period of time
  184. Calling Operating system command from Database
  185. executeQuery Can't pass variable to SQL. :-( Why?
  186. Re: starting Oracle service automatically
  187. Unable to compile in TOAD (purchased version)
  188. Groupped count(*) results from a view
  189. ORA-00904
  190. Re: oracle server 9i on window + linux client
  191. newbie question
  192. Re: Problem connection to an Oracle Database ??
  193. Re: Problem connection to an Oracle Database ??
  194. Unknown error in Developer 6i
  195. Re: Backup Script
  196. HELP, conexion Discoverer-Informix
  197. archivelog v/s nonarchivelog
  198. OCI Wrapper libraries ?
  199. Re: svrmgrl management API
  200. Bounce the Application Server
  201. Re: svrmgrl management API
  202. setup for online project.
  203. Oracle JDBC 9.2.0.3 slow?
  204. Collections: Bug? Table()? BULK COLLECT?
  205. Problems querying oracle db from Access 2000
  206. Connect to another DB
  207. Re: Oracle 8.1.7 problems installing
  208. Unicode Doubt in Oracle
  209. sqora.gid and sqora.fts file
  210. Re: PROBLEM WITH DISCOVERER JOINS
  211. Re: PL/SQL Collections
  212. dad
  213. Problem of installing Oracle on Linux
  214. Re: PL/SQL Collections
  215. preventing CONNECT BY from generating an error if cycles exist
  216. Re: Loadjava hangs in RedHat Linux (URGENT)
  217. Re: Loadjava hangs in RedHat Linux (URGENT)
  218. Questions about Oracle 9i Upgrade
  219. Re: Oracle on Solaris-Intelx86?
  220. Re: pro*c install in 9i
  221. Please Help me!
  222. Mysteriously dropped connection and deciphering the trace
  223. Shared Sequencers
  224. exception ORA-32101 creating environment
  225. [newbie] Why does not my installer start?
  226. dynamic table creation
  227. drop table from readonly TS
  228. URGEEEEEENT PROBLEM WITH DISCOVERER
  229. increasing extents because of ORA-01632
  230. Oracle 9i on Red Hat 9
  231. Error installing Oracle 9i
  232. Tuning SQL in Oracle
  233. Oracle client install on AIX 5.1 -- NetAssistant & SQLPLUS do not run
  234. Why is "jdbc:oracle:thin" called a thin driver?
  235. "Grant a Role"-Statement in Triggers
  236. Re: rownum HELP ....
  237. SQL Loader into another user's table
  238. Oracle Discoverer
  239. Re: CTXCAT problem on 9I
  240. oracle terminal 1.0
  241. How to hide ORA-06512 and ORA-04088 error messages?
  242. SQL sequence creation
  243. Need help with SQL statement!
  244. OCI and getting client version
  245. Re: How to create package specification and body for Student registration system
  246. Can i control ORACLE FORMS from external
  247. OWS-05101: Execution failed due to Oracle error -6550
  248. Re: How to create package specification and body for Student registration system
  249. working with dates in oracle
  250. utl_smtp x select statement
  251. Storage Capacity Planning
  252. dbWidget 1.0 - New Heterogeneous Database Development Tool
  253. Developer 2000 v 4.5 in windows 2000
  254. Re: dbms_metadata for Synonym
  255. multi row update in one SQL statment
  256. mutating table error w/trigger
  257. Oracle DBCA java.lang.NullPointerException
  258. Re: Oracle not using Index
  259. Re: Oracle Universal Installer Problem
  260. Oracle Database Applications - platform dependancy??
  261. Commit Status After Failure
  262. Oracle Client9i
  263. Required field for updates
  264. Oracle Collaboration Suite layout
  265. Constraints with several father tables
  266. ORA-00904: invalid column name
  267. another PLS-00201
  268. Please tell me more about packages component
  269. Does OCCI support Unicode?
  270. replace tags in doc files from PLSQL procedure
  271. calling an external java program from a trigger
  272. Tools for debug PL/SQL
  273. DIFFERENTIAL BACKUP QUESTION
  274. Combining 'search' values in DECODE
  275. Re: Oracle Function Ownership Problem
  276. Re: Access violation on setup of Oracle8i Personal Edition
  277. Re: Use of Parallel Query Servers
  278. Dynamic sql query
  279. not able to connect to oracle 8.17 database on win 2000
  280. Re: Use of Parallel Query Servers
  281. Unbale to find sqlcxt reference
  282. What is PL/SQL Packages?
  283. Re: how quick query can be
  284. Re: Oracle Function Ownership Problem
  285. Re: dbms_metadata for Synonym
  286. Insertar de Oracle a Sql Server
  287. Fooling Oracle re: extent allocation
  288. import table between Oracle 9i to MS Access - errors?
  289. Break a table into small finite tables
  290. Cube Viewer Problem
  291. UTL_FILE.put_line limitation under Oracle 7
  292. Re: Oracle JDBC, SQLException, COMMIT is not allowed in a subordinate session
  293. linux-oracle-hyper threading
  294. Problem when using SQLPlus in Oracle 9i
  295. Re: Tunning Indexes
  296. subquery not allowed here
  297. Re: Oracle JDBC, SQLException, COMMIT is not allowed in a subordinate session
  298. Oracle Books For Sale
  299. Re: HASH Function in oracle SQL PL/SQL
  300. Oracle on Linux
  301. Re: SQL construct not supported in informix ?
  302. Fragmented database
  303. Connectstring with SQL*Loader
  304. end-of-file on communication channel while executing a sql query
  305. Re: Package problem
  306. DBMS_METADATA PL/SQL Supplied Package
  307. Which self-test software?
  308. Re: can not delete data from a table which is queried in a stored procedure
  309. Database link and ORA-02041: client database did not begin a transaction
  310. TNS-12560:Protocol adapter error from client side only...
  311. Returning record X-Y from a table
  312. Re: RAID Levels
  313. Re: Can't Open 9i Olap Viewer
  314. Re: Experienced PLSQL, Newbie to Java -- Why would one use java?
  315. Cubegeek.com - Multidimensional Thought for the BI Professional
  316. Experienced PLSQL, Newbie to Java -- Why would one use java?
  317. Performance probs with Connect 4.2 for Oracle Wire
  318. Re: Attach a file in UTL_SMTP
  319. Re: adding to source coutrol
  320. Difference between archive and redlolog?
  321. Re: Query help
  322. Tables with a row size limit?
  323. jacorb and oracle
  324. Single Complex Query Vs Temoprary Table
  325. Oracle newbie
  326. Test
  327. FRM-10095: Assertion failed in iewbdbc_oracle_to_id
  328. Query for Return character?
  329. Sure-fire "kill"
  330. OCP DBA Certs
  331. Eliminate Duplicates Using SQLLDR and/or .ctl file
  332. Re: plsql.jar and JVM
  333. Capacity Planning for Oracle database
  334. How to insert multiple rows with a single INSERT.
  335. Oracle IRC Channels
  336. OCI: How to insert BLOBs with array interface?
  337. export method
  338. Oracle Intelligent Agent Executable
  339. Re: update empty column according to existen data
  340. Help!! Any non-RAC high-availability experiences with Oracle9 ??
  341. Re: Doubt UTF8 database
  342. Re: Database Performance
  343. Oracle to double hiring of Indians
  344. -- how to check if database link is active
  345. dbms_output.putlin show up AFTER completion???
  346. difference between client adn server
  347. Oracle rounding question
  348. Searching in complete DB
  349. Mix and match
  350. SYS_XMLGEN returning blank records, PLEASE HELP, COMPLETE NEWBIE
  351. The dreaded TNS-12500 error.
  352. Re: How to get the list of variables and constants declared in a Oracle Package?
  353. Re: How to get the list of variables and constants declared in a Oracle Package?
  354. Re: How to retrieve latest record when date and time are separate ?
  355. OCI: How to insert BLOBs from OCI ?
  356. Re: How to retrieve latest record when date and time are separate ?
  357. Minimum requirements for ODBC connectivity to Oracle database
  358. Trigger and DML INSERT on separate table
  359. How to Keep selected text items from being highlighted? In forms 6.0
  360. Re: Easiest way to output XML based on SELECT statement or Stored Proc
  361. Re: How to retrieve latest record when date and time are separate ?
  362. Re: How to install SQLPLUS editor on windows for ORACLE isntalled on UNIX
  363. Oracle error log
  364. connection problem
  365. Re: How to retrieve latest record when date and time are separate ?
  366. Re: Select Top ... * from ... command
  367. How to prevent table entry from being deleted but perform statements in the body of a trigger ?
  368. How can I get database SID in stored procedure in Oracle?
  369. Re: Oracle and W32.Bugbear.B@mm
  370. UTL_SMTP x INITJVM.SQL
  371. Info on Oracle Replication
  372. Should developers have DBA role?
  373. Need to dynamically generate a SQL SELECT which excludes NULL columns
  374. Re: ORA-02291: integrity constraint (%%%) violated - parent key not found
  375. Syntax espression
  376. Is text_io part of FORMS or PL/SQL? Can text_io be used with DBMS_OUTPUT in PL/SQL?
  377. Re: problem to connect with Oracle Management Server
  378. returning a multi row select within a single row select
  379. [Quick Question] Programming Jobs on Oracle?
  380. Oracle 9i/9iAS co-existense question
  381. Re: Latest Study Guides for Oracle 8i 9i OCP OCA exam
  382. Re: Visual C++ and Oracle - increase speed and preformance?
  383. Oracle RDB stored procedures and resultsets
  384. Re: Oracle 9i
  385. Tracking users
  386. Inconsistant query results - Please help
  387. Oracle 8.1.7 on Mandrake 9.1 install problems
  388. Strange SQL behaviour when using query short-cuts
  389. undefined reference to `sqlcxt' (Pro C compilation problem)
  390. Re: Help: Oracle Workflow Mailer
  391. JDBC problem in rollback
  392. form not running on 6i
  393. Oracle dba studio
  394. Oracle on NT4 memory use
  395. Re: Newbie question....
  396. Re: Newbie question....
  397. Index on date-fields with NULL values
  398. Two instances of Oracle client on one PC
  399. Which Red Hat Linux version supports Oracle 9 DB?
  400. Strange behavious - inconsistencies between SQL in SQL*PLUS & SQL embedded in PL/SQL
  401. Adonis on Oracle
  402. Closing a data base link
  403. upgrade 8.1.5 to 9i
  404. Oracle install and Java problems
  405. Re: Export from 9i and import to 8i
  406. Re: Export from 9i and import to 8i
  407. ADDRESS_LIST, CONNECT_DATA in OCILogon
  408. Re: Why SAP is doing well when Oracle is not
  409. Oracle certification question
  410. Re: Conditional Constraint?
  411. Re: Conditional Constraint?
  412. Re: ORA-12560:TNS:Protocol Adapter Error on Netware
  413. How can I get Oracle 8i for Windows 2000 on a CD ROM ?
  414. Re: How to duplicate whole database from one machine to another machine in Windows 2000?
  415. Very slow initial connection on Oracle 8i
  416. Re: ORAKnowledge
  417. Oracle OFA, Tablespaces and Redo Logs?
  418. database link
  419. disable O/S file cache??
  420. How To Update A Table From Excel
  421. Help: Problems with ALTER TABLE
  422. PL/SQL: Printing questions
  423. Problem with Distince and Index - Inconsitant output
  424. Re: Rates of change???
  425. Problem with Oracle 9i on laptops -- disk writes every 1-2 seconds!
  426. Orcale 9i -- NOT friendly with laptops -- the probe disk-hit every second!
  427. oracle 9i on a laptop ~~ how do I prevent the ~1 second disk hit on my laptop! This is a MAJOR problem!
  428. -- determine changing time of record
  429. Standby Database Issues
  430. Re: Please help running DBCA
  431. Problem with TOAD 7.5 and 9i DB
  432. Oracle Thin connectio fails from outside the network
  433. Re: Rates of change???
  434. Oracle 8.1.7 Unions with differing datatypes in the selects
  435. Do you have end-users like this?
  436. Re: Forms9i builder not starting on redhat linux 9
  437. Cost based optomizer problem. CBO won't merge view
  438. Re: Running PL/SQL procedure on client side
  439. Oracle Intermedia / Image Import
  440. Sample Data Model for a College - Course Scheduling and student info
  441. Rollback Segment Errors
  442. search on front of compound key
  443. How to improve deletes on a non partitioned table with no indexes
  444. Compiling Oracle Stored Procedure from VC++
  445. Re: Materialized View/Snapshot without Triggers?
  446. Get the user logged on NT with a trigger in Oracle
  447. Decode question
  448. Re: Help needed getting BC4J in Jdeveloper to recognize Rowid and Primary Key info in a MySql database
  449. Where OCIDirPathPrepare is defined?
  450. ORA-12154: TNS: could not resolve service name..when using hsodbc
  451. NT client crashes to blues screen on dual processor board
  452. OCI: generic binds
  453. FULL OUTER JOIN for oracle8(i)
  454. HELP: dbms.job - scheduling job at exact time
  455. Re: Slow client operations
  456. Re: Materialized View/Snapshot without Triggers?
  457. Re: NLS_DATE_FORMAT with SOL Loader
  458. Re: JSP not responding on 11.5.8
  459. User DB with User NT
  460. pre-production environments
  461. Inconsistent Query Results
  462. Re: cannot connect with JDBC THIN driver to ORACLE 8
  463. Re: Changing database server location
  464. Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME
  465. Re: Delete child-parent records???????
  466. changing database location
  467. Re: Installing Oracle 11.5.8 on Mandrake
  468. Cannot connect with OCI driver and Oracle 9i (9.2)
  469. ORA-01004: default username feature not supported; logon denied
  470. External Table Query runs in PL/SQL but fails in perl script
  471. File too large..
  472. question
  473. deleting data
  474. DataBase is not Connected through Application
  475. Oracle Parameter not getting value
  476. help with PL/SQL (ORA-06502 & PLS-00204)
  477. DLOOKUP function
  478. How to execute trigger instead of view while changes are done on a field in the table
  479. copy access tables to oracle
  480. Need to connect oracle database using Unix script
  481. Need a unix script to do match two files
  482. ORACLE10: Rename column that has keyword name
  483. ORA-03113 : end-of-file on communication channel
  484. Need help with append and delete duplicates
  485. How to run & view the out put of procedures in SQL:\>
  486. Oracle 9i Installation problem
  487. Informatica Licence Key-
  488. Oracle Apps
  489. How to bring up Enterprise Manager Oracle 10g
  490. Count(*) and performance
  491. Regarding tablespace issues
  492. how to change the password for sys schema?
  493. TOADS Explain plan
  494. Reg AOL
  495. Single sign-on configuration assistant failed during App Server install
  496. Update the first x of the records returned
  497. Encryption
  498. new feature in oracle 9i
  499. Run sql statement through batch file
  500. Using Collections in PL/SQL
  501. Refreshing or recreating a materialized view
  502. New to Oracle Help me out....
  503. Load Xml in oracle (SQL LOADER)
  504. Query too long
  505. Number Formatting
  506. New to Oracle
  507. Command hangs and doesn't end.
  508. SQL statement to store and retrieve 2byte letters like Japanese characters
  509. Oracle Reports 6i Download link
  510. Convert Oracle to SQL
  511. min function
  512. Timed Out Error in Oracle.
  513. What's the best way to load a PDF file into an oracle table?
  514. Top N results
  515. Prblems with DataSet Fill
  516. Duplicate Records
  517. E-Book
  518. Connection error from em oracle10g
  519. REG Oracle Discoverer
  520. trigger compilation errror
  521. Get Top 10 records
  522. decode question
  523. Assign field value based on date range of another variable in another table
  524. Regarding ORACLE
  525. FTP Batch file
  526. Data cloning in oracle 10g
  527. Retrieving the Nth record from a one-to-many subrelation table
  528. Can I commit portion of transaction in Oracle 9i?
  529. Back up or export Oracle Database Lite 10g syntax
  530. how to returning a recordset
  531. problem with connection
  532. Difference between Having & Where Clause
  533. How to connect to database????/
  534. login details
  535. Dates between the two given dates
  536. Data Dictionary Views
  537. Oracle transparent gateway in z/os
  538. Syntax error
  539. insert time only
  540. Tuning a stored procedure
  541. Regular expression in Oracle
  542. Creating Table in Oracle
  543. Calling Apex from Oracle Forms
  544. primary key
  545. date & time between
  546. Subqueries
  547. procedure and function
  548. countfunction
  549. Stored Procedure returning multiple values
  550. multiple row insert