View Full Version : oracle answers

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

  1. Storing/retrieving BLOBs with JSPs
  2. /usr/lib/ Unresolved symbol error
  3. Solaris expert needs to break into as entry-level Oracle dba
  4. SQL statement monitor/logger
  5. oo40 - number type and ODynaset
  6. dbms_alert_info table access from a schema
  7. How to know in a unix script if oracle procedure executed or failed?
  8. help needed to write a oracle function that can do this...
  9. Pass variable to Oracle Query form Crystal Reports
  10. CREATE TRIGGER odditiy
  11. Oracle 8.1.7 hsodbc agent on Tru64 UNIX 5.1B
  12. Where is OUI
  13. need help with PL/SQL Procedure
  14. TNSLSNR.exe - Application Error
  16. how to write a function to call this VB script
  17. case, nvl and datetime fields
  18. Strange TNS problem
  19. LDAP attribute list
  20. XMLType insert
  21. can I remove jdk directory from C:\orant?
  22. Try on these security package
  23. Oracle Query
  24. DiskSuite RAID5 performace
  25. Loading from XML to Database
  26. Install this corrective update from the Microsoft
  27. Oracle's Mission Statement
  28. Help needed in Update SQL that uses an Inline Query View containing 'Partition By'
  29. Designer Forms: Linking update module component / stand-alone list of values
  30. JDBC driver setup in UNIX
  31. Looking for OAS SW
  32. 9ias, fully qualified host name?
  33. Cursor, Fetch, and while...
  34. Need help to understand difference, and contrast between Relational database model and the Object-Oriented model
  35. 2nd CFV: comp.databases.etl
  36. Oracle 9i problem
  37. SQL_TRACE Output Location
  38. ORA-01026: multiple buffers of size > 4000 in the bind list
  39. OMWB
  40. Listener Configuration in Oracle 9i
  41. Dynamic SQL with PROC/C++ problem
  42. ORACLE 9 and Solaris 5.6
  43. Lock table only allow INSERT
  44. Max number of records can be fetched in oracle in one call
  45. 8i and SuSE 9 Pro
  46. More Help Required.. in Replication of Oracle 9i in Rh9 (if the query is repeated by me sorry)
  47. Reply: Replication Of Oracle 9i in RH9
  48. How to emulate WRITETEXT / Writing to LONG fields
  49. Oracle upgrade advice
  50. WinPure .. List Cleaner .. Opinions/Recommendations?
  51. redirect SQL Trace output
  52. Index on Number & Varchar2
  53. SYSRESV Utilitity for Windohs??
  54. select next highest salary or last login date ...
  55. Standby database on Standard Edition
  56. keyword override
  57. Install problem on Redhat
  58. how to install oracle 9iR2 on windows 2003?
  59. Replication Of Oracle 9i in RH9
  60. Question on debugging TNS-12560
  61. Beginners problem with assigning object methods.
  62. ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function
  63. No Data found error
  64. establish oracle connectiviy with oracle
  65. will Oracle 8i run on Novell Netware 5.0
  66. Addition of constraint during creation of table
  67. RFD: Periodic FAQ & Charter post
  68. Static to Dynamic linking
  69. Passing Java object as parameter to the java stored procedure
  70. Bug of function-based index
  71. new to reports 6i
  72. How to say it in SQL?
  73. Monitor SQL queries
  74. Fatal NI connect error 12560, connecting to:
  75. 816 proC on debian linux; mathcalls.h issue?
  76. Error changing Character Set
  77. ODBC for 8i Single user version
  78. TNS 12545 urgent !!
  79. [beginner] sequence
  81. Statistics information
  82. cursor problem
  83. Q: Oracle Forms on WinCE
  84. Help: Forms 6 Template
  85. trigger problem
  86. Oracle 9i Database Server on Windows 2003 Server
  87. How to load a TABLE fuilly in memory and keep it
  88. how to use select clause in assignment
  89. migration from oracle 8i to 9i
  90. CLOB/NCLOB help needed please.
  91. Connecting to default oracle instance
  92. Hot Backup Question
  93. Q: Oracle Web-Based Tutorial
  94. VARCHAR variable in where clause
  95. Sql select question
  96. thanks
  97. Help with returning XML from Oracle function to JSP
  98. regarding some databse design rules
  99. sql*loader utillity for importing text file into oracle
  100. Remote Function Call: Internal Error
  101. MERGE over db-links
  102. OFFSET function in oracle
  103. PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared
  104. How to backup a 2 Tb Oracle data warehouse ?
  105. automatic shutdown/startup
  106. Updating LONG columns
  107. Using Veritas Netbackup with Oracle Export/Import
  108. OCI LOBS and AQ, help needed
  109. MINUS operator - How it works.!!??
  110. Complex Searches
  111. ORA-01840: input value not long enough for date format
  112. Oracle9i Forms Class
  113. Oracle Java Certification
  114. Error: ORA-01704: string literal too long
  115. Fast retrieval and display of results to web browser
  116. Migrating Oracle 7.3.2 to 9.0.1
  117. Refcursor value is invalid
  118. Session Defaults
  119. Traversing, while keeping a constant
  120. Conceptual modeling like in the book
  121. Reading flat files from pl/sql
  122. XML DB Repository Update Contents
  123. SQL Formatter
  124. minus and intersect functionality
  125. recomendations for web-based application functional design & project tracking tool?
  126. insert and select in one statement
  127. three table insert
  128. Seeking or
  129. Oracle Financials - security
  130. Ora-942 in stored procedure
  131. oracle designer
  132. Oracle 7, Indexes
  133. Will this work?
  134. Can sqlldr append to bad file?
  135. not available for install on Oracle 9i Client for openVMS
  136. idle time
  137. variable datatype returning
  138. Materialized views are not getting refreshed
  139. Extract the beginning of a string
  140. Client 8.0.6 doesn't work on win XP
  141. where is tkprof in 9.1
  142. connectivity - integration Oracle - SQL server
  143. How to prevent "Oracle8 ODBC Driver Connect" dialog from appearing?
  144. connecting c,c++ to oracle in windows or dos
  145. How to use index
  146. capture oracle pwd change in 3rd party application. help needed
  147. SQL question / Multiple rows output in one line
  148. Weird behaviour with START WITH and CONNECT BY
  149. Privileges On Procedures/Functions/Packages
  150. Seeking Patch 3006854 ( to install Oracle 9i under Red Hat Enterprise Linux 3 ES/AS
  151. ODP.Net vs OO4O
  152. Citrix Metaframe and Oracle 7 Client
  153. can't login to oracle dba studio as sysdba
  154. Oracle and Windows Server 2003
  155. Red Hat personal roadmap on the skids. Whither my dev box?
  156. Limit the levels for a query with CONNECT BY
  157. Stored Procedure Syntax to Copy data from Server to Server
  158. New Oracle monitoring tool ... Sorry :-) here is the webpage
  159. New Oracle monitoring tool ...
  160. SQLMENU50 :: user not authorized to use SQLMENU
  161. discontinued XCOFF64 file
  162. Procedure builder 1.5.8 (forms 6.0.8)
  163. Data mining/Data Warehouse on Web services
  164. moving items between databases
  165. Choosing DBMS and architecture for ecommerce website
  166. Help : Convert interbase stored proc
  167. Transaction hangs
  168. After a few minutes of querying the database my session disconnects abruptly. Can som
  169. What is the maximum number of tablespaces that contain data for a table containing tw
  170. To use C sort routines in the server side packages which file must contain support fo
  171. Which clause in a create user statement restricts the number of tables a user can add
  172. Into which file do records rejected by Oracle due to primary key constraint violation
  173. How can I improve performance of queries on tables containing all words in the dictio
  174. In which database memory areas is SQL and PL/SQL parse information is stored?
  175. I am attempting to take tablespace offline and receiving the following error: ORA-
  176. In which table is Oracle database audit information stored?
  177. 1. Do you know in which tablespace the tables that store information about the Oracle
  178. Why length()/dump() return different substring length values ??
  179. Open twice (or more) the same cursor
  180. Third party utility for encryption and full text search
  181. oracle on OS X 10.2.8
  182. query tuning
  183. Boss doesn't understand Oracle ...
  184. sql using full table scan instead of an index
  185. Removing Leading Zeros Using SQL
  186. Oracle JMS problem
  187. Enterprise Manager 2.2 on NT4 gathering from HP/UX11 and
  188. procedure compilable over db link?
  189. Oracle Sql Optimalization
  190. Errors after creating FBI
  191. Oracle Visual Basic Connectivity
  192. bdp or odbc?
  193. Oracle 8i Cursors via JDBC
  194. OODB References
  195. count (1) and count (*)
  196. DBA role
  197. UTL_FILE.OPEN problems
  198. Looking for a Gig Consulting or Full-Time
  199. Passing a space as an argument to SQL*Plus
  200. Keyword delimiters
  201. Not a valid month, please HELP!!
  202. load file to clob using loadfromfile(oracle8.1.7),but the length of file and clob is not equal
  203. Refer to block item using string
  204. how to select all rows where a colums has null
  205. reg oracle 9ids report printing
  206. Remove Duplicate Rows without a Primary Key
  207. niceSQL / SQL Formatter
  208. problem with dbca on Oracle 9i R2 Linux
  209. optimum datatype for primary key column O9i
  210. How to implement 'search' similar to Google
  211. My attempt to read the view creation code stored in the Oracle data dictionary has en
  212. Which Oracle dictionary view gives information about the position of a column in a pr
  213. Does PL/SQL allow cursors to contain subqueries?
  214. What are two components of the Oracle database security model?
  215. In order to set SQL*PLUS session so that NLS_DATE_FORMAT information is altered in a
  216. Having problems running query in Oracle
  217. [Q] oracle spatial functions
  218. Check this correction patch
  219. TEMP Tablespace Question
  220. sql comparison and flag
  221. Creating tables in DB Correctly
  222. "HAVING" problems with query and using 'having' with group by
  223. What is the efficient way to select data from huge database?
  224. simple question about sql*plus
  225. simple question about indexes
  226. db2 vs oracle
  227. Wich newsgroup ?
  228. FWD: Watch the corrective pack
  229. troubles with oracle on a 2k controller domain
  230. Oracle 8.1.7 on Windows 2003 Cluster??
  231. Secure JDBC connection to Oracle 9i
  232. Unable to enlist in a distributed transaction Error in COM+ with Oracle DB
  233. Export dump files and stripe-sets
  234. Forms 9i - LOV icon doesn't show up. Does anyone know why?
  235. How to assign a value to a variable
  236. Oracle Tools - Auto Commit Feature
  238. updating table with two images
  239. Oracle 9i and Connectivity
  240. trouble shooting oracle instance
  241. Page Processing Efficiency
  242. **HELP** Calling Oracle Stored Procedure from vbs script
  243. d2k installation
  244. oracle 8.1.7 + linux .trc dump
  245. How to start an oracle instance
  246. Query optimization
  247. Looking for scenario simulation tools for Oracle
  248. OWB gives ora-00942: table or view does not exist EVEN if the table exist
  249. Are there any contentions in Latchs?
  250. Oracle8i Client 8.1.7 Installation
  251. Oracle vs. SAS numerics - any ideas?
  252. Snapshot from DB2
  253. Oracle Forms XML DTD available?
  254. Query tuning help, please
  255. Oracle 8.1.7 Client Install On Windows 2000 Working
  256. Oracle 8.1.7 Client Install Problem On Windows 2000 - Download, No CDs.
  257. blob dispaly using psp
  258. How to do Media Recovery for System01.dbf????
  259. install orcale 9i in red hat 9
  260. Can Crystal Report access Oracle on Linux ?
  261. does ORACLE support WMI?
  262. Oracle9ias SSO/Infrastructure installation error.
  263. Difference execute immediate within PL SQL
  264. ARCH is FULL
  265. Problems with "IN"
  266. what is the meaning "latch" in the shared pool and library cache?
  267. index stats
  268. stats on indexes
  269. loss of performance when using anonymous pl/sql blocks?!
  270. How to read UNCOMMITED data in Oracle?
  271. Help with sqlplus in Oracle.
  272. Slow Crystal Reports with Oracle
  273. Use SET ROLE in Oracle Forms Builder
  274. Does Oracle + VB is a good combination
  275. Oracle 9i client connectivity to Oracle 7.1.4
  276. remote server access - ORA-01034:
  277. On the subject of Data Warehouses, Data Cubes & OLAP....
  278. what is the meaning of creating database link but omit using clause;
  279. after set db_domain parameter,but can not resolve database link problem.
  280. JDBC with mulitple instances of database
  281. lenth of SQL statement
  282. Oracle 9i database for Solaris 8 intel
  283. Integrating crystal reports with oracle forms
  284. How to enable TNS trace
  285. Why does Windows XP not support Oracle 8i?
  286. Star Transform condition?
  287. "database not open" - Rookie
  288. Oracle Upgrade problem : from 8.1.6 to 8.1.7
  289. Install these package that comes from MS Corp.
  290. sql question
  291. Oracle Applications - Activity Based Management
  292. How to fix? ORA-22990: LOB locators cannot span transactions
  293. oracle plsql & cvs
  294. OG-00637 Unhandled PL/SQL exception 102098
  295. Oracle 9i Installation on RH Linux 9
  296. Oracle takes the wraps off SME database
  297. Create Primary Key on View
  298. REF Cursor returned across db link?
  300. I cannot install Oracle8i client on WindowXP, please help.
  301. DATETIME in Forms 6
  302. sql*loader - partitions - domain index
  303. ORA-01503: Create controlfile failed
  304. Help with DECODE function and crosstab query
  305. oracle applications 11i installation on Linux 9
  306. Check out these security package from the MS Corp.
  307. Basic Sql performance question
  308. Oracle 9i does not install (with a Mandrake 9.1)
  309. Inserting old value into a column
  310. Raw on Linux
  311. Oracle Failsafe Question
  312. Starting database up...
  313. Installing Ora9i on Windows XP
  314. Running Oracle database on Unisys OS2200
  315. [WEIRD] Merge date and char
  316. How to retrieve temporary BLOB value from PLSQL to Java?
  317. Grant Previleges to Objects and Varrays
  318. restore Issue
  319. update using an alternative to correlated subquery
  320. stored procedure, cusor help
  321. Unsigned integer to IP address?
  322. How to improve a simple SQL performance
  323. How do I get an array into a resultset
  324. table name substitution in pl/sql
  325. Seeing double output in SELECT SYSDATE FROM DUAL
  326. Seeing double output in SELECT SYSDATE FROM DUAL
  327. Seeing double output in SELECT SYSDATE FROM DUAL;
  328. Importing specific tables from a full export ?
  329. Oracle Database 10g. When ?
  330. Oracle 8.0 Copy long from 1 table to another
  332. Speeding Intermedia Query
  333. Database Integration Question
  334. RAC - rebuild 2nd Node
  335. global temporary table --> invalid ROWID?
  336. Changing table size
  337. Oracle XML
  338. Move BLOB partitions to a different tablespace
  339. Books on Oracle Insall / Configurations
  340. selecting ROWNUM causes query to take forever
  341. Outer join returns incorrect results when using sub-selects
  342. Difficulty to interpret a TKPROF output
  343. parameters.add in .NET (Bind problems?)
  344. Question about Partitions and Indexes
  345. puzzling deadlock
  346. SIGBUS and SIGSEGV Errors in HP-UX 11 and Oracle 9i
  347. Who spawns a dedicated server process?
  348. Oracle login error from the web
  349. Can I delete some statisitcs table(s) from Oracle to tune it?
  350. Help installing Oracle 9i after installing Discoverer
  351. Oracle home selector
  352. Errors per user session!
  353. Oracle export table to ascii
  354. how to change this query, so that it will not use the correlation?
  355. How to imp from oracle 8.1.7 to 8.1.6 in Unix?
  356. Oracle 8.0 - Can't use function index
  357. Oracle certification exam preparation
  358. Help with MIN field value
  359. Third party indexing solutions
  360. OCI DirPath
  361. trim(' ') problem & ORA-03113
  362. Forms 4.5 login -- cannot type username or password
  363. 9.2.0 migration now cant log into Apps
  364. PUBS Database
  365. Question about deleting table duplicates
  366. Oracle stored proc. from VB in ADO
  367. Need an algorithm to process nodes in a tree recursively
  368. How to find PINNED tables/indexes etc?
  369. query oracle_home in sqlplus
  370. combining rows from 2 tables
  371. one code for two tables
  372. case question
  373. Distributed database question
  374. Partitioning and Tablespaces
  375. Best practices: commit by database layer vs. commit by caller
  376. Unistall Oracle with Faulty Uninstaller
  377. How to display a BLOB/CLOB in Oracle Forms?
  378. OCP is not enough, need extensive experience
  379. Linked Servers
  380. Isolation level on Ora 9i
  382. Oracle DBA: Where do I start?
  383. Oracle Long mapped as CString
  384. 8i to 9i upgrade
  385. Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
  386. Oracle Real Aplication Cluster
  387. Oracle Real Aplication Cluster
  388. Help needed in SQL Query for Hierarchy
  389. Unspecified error when running Oracle 9i package via ASP
  390. saving files as LOB to Db
  391. Oracle JDeveloper 10g Preview is out - includes many PL/SQL features
  392. Oracle 8i on WinXP?
  393. Getting structure of a table in query format
  394. How to create a SIMPLE distributed database in Oracle??
  395. what is the difference to use the password file and normal account to login?
  396. Problem with MERGE and database link
  397. ora-01031 insufficent privileges
  398. How tough can I be for the user PUBLIC?
  399. Diagnosing Transaction Enqueue (TX) Locking Issue
  400. Company thought DB2 will be better than Oracle.
  401. Prcedural replication issue
  402. external table
  403. RMAN restore with Windows
  404. Oracle vs. Informix
  405. question about password file
  406. number defined being truncated in select (sorry double posting ;-( )
  407. ORA-04030 with PGA_AGGREGATE_TARGET
  408. control file not created at the time of installation
  409. SS7 to Oracle 9i Migration Problems
  410. How to query a string containing an apostrophe ?
  411. Default User on Windows
  412. Urgent: LDAP Server
  413. Conditional printing depending on number of returned rows
  414. Cannot connect as Internal....?
  415. How to write the select query on self referencing table.
  416. Integrity constraints with type inheritance
  417. Oracle Recover/Restore
  418. How to disabled all constraints when importing data (urgent)
  419. How to disabled all constraints when importing data (urgent)
  420. ORA-01000 maximum open cursors exceeded
  421. initialized or shutdown in progress
  422. Oracle x SQL
  423. Help query
  424. MS Word to Blob
  425. About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
  426. About Error : ORA-01034 and ORA-27101 ( on Windows XP and Oracle 8.1.7 )
  427. SYSTEM Tablespace is FULL
  428. which SCHEMAS are actually needed?
  429. CHECK Constraint
  430. Insert Order into a table
  431. How fix ORA-01000: maximum open cursors exceeded with out closing Statement.
  432. Anybody Having STUDENT INFO SYSTEM Docomentation
  433. Get the date time from Oracle date time stamp?????
  434. Cursor Value to Delimited String Variable??
  435. oracle on linux and windows on the computer
  436. How to unload data
  437. Teradata DBA in Chantilly, VA
  438. Formatting BRIO Reports
  439. mail merge with Oracle forms and Word
  440. viewing Stored Procedure Definition in SQL prompt
  441. table record distribution query.
  442. SSO error
  443. Oracle , Jdbc & Long Raw field
  444. how to view sample schema
  445. URGENT: VARRAY as Input/Output variable
  446. URGENT: VARRAY as Input/Output variable
  447. SQL*Loader - Commit point reached - logical record count 27
  448. controlled population of 1 million "generated" rows?
  449. How to insert BLOB?
  450. Help!
  451. Commit transaction
  452. Slow slow Pro*C compilation with sqlcheck=semantic
  453. 1
  454. Problem on Viewing SQL in Crystal Report
  456. Big problem with Oracle Portal Migration
  457. Need Query without Union and minus.
  458. 8i to 9i changes
  459. Pfile Question
  460. Cursor parameters - problems with 'FROM [inTablename]' statement
  461. Discoverer inactivity timeout
  462. Oracle Backup
  463. oracle in solaris consume lot of memory
  464. oracle collabration suite experiences
  465. Show long number in Toad
  466. OCA & OCP Certification Books
  467. RTF to Text conversion
  468. select no retrieves varchar datas
  469. Escape sequence
  470. moving a database
  471. Blank line Inserted - I don't like it
  472. Oracle Reports 6 recompilation
  473. Right password -> ORA-12154: TNS:Could not resolve service name
  474. Problem configurating Apache
  475. How do I rename null values found in GROUP BY column?
  476. Oracle/ASP hanging
  477. Updating LOB fields through ODBC, invalid LOB locator
  478. Input mask question
  479. migrate from sql server to oracle
  480. Oracle9iAS + JBuilder9
  481. materialized view. help...
  482. confused about ifs
  483. problem in to_date function
  484. DBMS_SQL.define_column ---- why ????
  485. How to call dynamic remote stored procedure in the dynamic sql
  486. OCI Bind for RAW field, Cannot select a record matching a hexadecimal Key (raw type)
  487. Indexing multiple fields with Oracle TEXT (Intermedia)
  488. URGENT PROBLEM: refresh data in Discoverer
  489. Oracle - Commit Before invoking a trigger
  490. exception
  491. Invitation to Join SV_RFID!
  492. db2 runstats
  493. Korean data load from Excel sheet to Oracle table
  494. P4 Bug and 9iR2
  495. JDeveloper 11i
  496. Strange Utl_File Error on NT
  497. Integrating crystal reports with oracle forms
  498. Query Optimizer does not ignore constant condition?
  499. Oracle password change using the Verify Password function
  500. need a Sample online hot backup script for UNIX..
  501. BLOB and .NET
  502. Un-install Oracle Personal Edition 9i
  503. full outer join question
  504. Problem installing Oracle 9i on XP
  505. Difficulty inserting due to &
  506. help with update sql
  507. PL/SQL Function Help
  509. Compilation unit analysis terminated?
  510. How to handle a long strings in a pl sql stored procedure,
  511. documentation on moving OraHome to different machine
  512. Reserved words with "ROW"
  513. Oracle 9i w2k Client error -Credential retrieval failed.
  514. I have a question with sqlplus...
  515. .NET OLE DB Connection
  516. Oracle ODBC Outer Join Bug?
  517. ODBC Escape {oj} problem w/ ADO
  518. Stored procedure that returns a recordset?
  519. Oracle ODBC error with ENCRYPTION
  520. Downgrading 7.3.4
  521. Java/Oracle thin driver SQL statement limit
  522. Help required with OCI
  523. Statement returing True/False in decode() function
  524. Read Only Transactions
  525. How to Inactivate the Oracle User?
  526. Backup file format
  527. problem of installing oracle on linux
  528. Reports wont print on Citrix server
  529. How to reference table/view that has "slashes" in its name!
  530. Porting database from Oracle7.0 to Oracle8i
  531. Advanced Enterprise Database Planning/Design Books
  532. Oracle tablespace management
  533. Help needed in SQL Query
  534. Apache installation error
  535. using Autonomous transaction
  536. Accessing Oracle from VB
  537. Number of elements in "IN operator"
  538. Designer failing to reverse Engineer
  539. Oracle and Java application
  540. Writing binary data to external file
  541. Backup
  542. User is not allowed to work in a period of time
  543. Calling Operating system command from Database
  544. executeQuery Can't pass variable to SQL. :-( Why?
  545. Unable to compile in TOAD (purchased version)
  546. Groupped count(*) results from a view
  547. ORA-00904
  548. Unknown error in Developer 6i
  549. HELP, conexion Discoverer-Informix
  550. archivelog v/s nonarchivelog