View Full Version : answers

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