View Full Version : oracle answers

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

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