View Full Version : oracle answers


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

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