View Full Version : oracle answers

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

  1. Reuse Connect dialog box on forms 6i run time to connect to another database
  2. SQL Commands to interact with Windows Files in 9iR2
  3. Oracle 9IR2 OLAP and BI Beans - How to get it working
  4. PL/SQL Compile Problem
  5. SQL question
  6. Help: need avg(timestamp1 - timestamp2), get type error
  7. I found the answer
  8. Open cursors
  9. Cannot read from sys.v_$session
  10. Oracle Warehouse Builder and Workflow 2.6.2 on linux
  11. Oracle DB Type List
  12. A SQL Question
  13. Oracle vs. MS SQL Server
  14. upgrade 8.1.6 clients to 8.17
  15. Oracle Client software for HPUX 10.20
  16. restrict user's view
  17. copy a role
  18. what is the most difficult situation u faced & how did u solved it . . i need some best answers for this question as an oracle (DBA)
  19. assotiating SQL text from the V$%SQL% views with sessions
  20. EMC SAN and refreshing snapshots
  21. oracle database for academic
  22. Urgent Query
  23. Perf. degradation due to TIMESTAMP WITH TZ
  24. How to prevent modifying oracle data through MS access or VC++ sql screen.
  25. Minimum Installation for 8.1.7 Client for W2K for ODBC Connection
  26. Help requested..Missing Protocols Oracle 9i.
  27. URGENT ---------> SQLLDR ERROR
  28. what is SQL*Net
  29. Power Objects
  30. Format sqltext from v$sqltext
  31. Executing SQL via MDAC ODBC multiple statements?
  32. PL/SQL package gets invalidated seemingly at random
  33. Know whether oracle is installed or not
  34. meaning of TNS (Transparent Network Substrate)
  35. user authorazation
  36. check who delete the role
  37. Wot, me worried?
  38. How to sign up
  39. A simple newbie question with select
  40. Run SQL Script under SYS for other Schema
  41. help Jobs not running on OEM console
  42. INSERT Through Pro*C in UTF 8 DB
  43. SQL to retrieve min value of the combination
  44. libobk source code?
  45. regarding oracle 9i installation
  46. oracle listener
  47. oracle Performance decrease when number of connections increase
  48. DBCA fails on Windows ME
  49. Password question
  50. Regarding ORacle 9i installation
  51. Analyzing queries
  52. newby question
  53. basic PL/SQL questions
  54. HELP: create user
  55. ORA03113: end-of-file on communication channel
  56. Adding Index to Table may reduce performance of Some Select Statements ?
  57. Loader and dbf files
  58. PLS-00201 and ORA-00942 when creating a package
  59. Query from the Aggregated Query with different projection
  60. How can I check the Users who are online ?
  61. TNS:protocol adapter error
  62. TNS:protocol adapter error
  63. Check out this critical package for Microsoft Internet Explorer
  64. Watch this patch from the M$
  65. Information Needed Regarding Oracle Forms 6i
  66. TAF without RAC or OPS
  67. Oracle Security conversion..
  68. Granting sysdba to a user
  69. Problem with date
  70. How to rellocate Sun Solaris disk space where oracle installed
  71. Test Case02:: Asynchronous Replication on Oracle 9i Release 2
  72. Error in starting Oracle agent and ORA:01031 on SQLPLUS
  73. Newbie jdbc question on URL error
  74. What privilege needs to be granted?
  75. Creating a DTS package programaticaly
  76. Replication Test case 01 on Oracle 9i
  77. Standby Database.. Error in password file..
  78. SQL
  79. Help Needed Regarding Oracle Migration
  80. Connecting Windows Clients to Oracle
  81. How can I combine three tables in a View or a Procedure?
  82. term 'Bulk Connects'
  83. 9i oracle oracle enterprise manager
  84. Linked Server to Oracle
  85. how to install Perl DBI and DBD-Oracle Modules ?
  87. Help requested ! Protocol Adapters Missing oracle 9i...
  88. how to use plsql to calculate compond growth
  90. ERROR in Standby database setup with RH9
  91. Oracle9i standby database setup in RH9 .. a minor error pls help
  92. Listener cannot read SERVICE_NAME in TNS-Descriptor
  93. Need utility to update one db (Sybase) from another (Oracle)
  94. Strategy and simple Listener Problem Xplained once more..
  95. Long time to log in
  96. Nested Tables in Oracle
  97. CFV: Periodic FAQ Post
  98. Documenting Oracle procedures
  99. Windows 2003 and Oracle 9i with shared storage.
  100. A simple Listener problem while installing Oracle by copying Ora Home
  101. combining several SQL statements to run sequentially??????
  102. CGI and Oracle 9i
  103. How to improve the deletion rate.
  104. Disable Rollback
  105. windows 2003 and oracle
  106. WTD: Oracle DBA Cert classes w/ Cert pass guarantee - OCP test prep class?
  107. Numeric overflow
  108. bulk execute procedure using odbc
  109. Oracle workaround to the STUFF() MSSQL Function?
  110. Bulk-bind input and output host arrays to index-by tables
  111. Oracle Help System
  112. Will copying Oracle home directory install Oracle 9i on RH linux 9 system ?
  113. Installation of Oraclewarehouse Builder
  114. Shared Physical Storage .. in Windows Server systems
  115. ODBC produces logoff event?
  116. Index and foreign key
  117. Loading xerces parser in oracle 9i
  118. get default funtion of a column
  119. ODBC drivers, .NET providers, OLE DB providers, JDBC drivers: updated lists
  120. Sample to pull data from Oracle proc into an html table
  121. NullPointerException freeing temporary CLOB
  122. Anybody using OEM to monitor MS SQLServer?? Need some tips!
  123. JDBC driver problem
  124. Help me, i m unable to install oracle 9i on redhat 9.0
  125. Spool
  126. Database link: Wrong column length from cursor
  127. Where do SQL/PL programs execute from ?
  128. re-numbering pimary-key
  129. Where to find Demo database with gnarly PL/SQL?
  130. OCI bug - ofetch hangs
  132. SQL Batch Script from MSSQL to Oracle 8i
  133. Moving a table from one tablespace to another tablespace
  134. Bulk Inserts
  135. Oracle 9i OEM login NullPointerException to OMS
  136. How to create a descending index on the primary key.
  137. SQL Loader
  138. its a basic SQL command but require help ?
  139. Basic idea od Crystal reports
  140. 9.2 init.ora file on XP
  141. validate password within PL/SQL?
  142. External Tables binding to Access?
  143. changing date format in update statement
  144. procedures and table scope... PLS-00201
  145. XSU insert into view with object type
  146. Update Problem
  147. UTF-8 and Pro*C
  148. Bulk Updates in Oracle from XML File
  149. RAID
  150. Oracle 9i personal on Windows ME
  151. running utl_file
  152. running utl_file
  153. Storing/retrieving BLOBs with JSPs
  154. /usr/lib/ Unresolved symbol error
  155. Solaris expert needs to break into as entry-level Oracle dba
  156. SQL statement monitor/logger
  157. oo40 - number type and ODynaset
  158. dbms_alert_info table access from a schema
  159. How to know in a unix script if oracle procedure executed or failed?
  160. help needed to write a oracle function that can do this...
  161. Pass variable to Oracle Query form Crystal Reports
  162. CREATE TRIGGER odditiy
  163. Oracle 8.1.7 hsodbc agent on Tru64 UNIX 5.1B
  164. Where is OUI
  165. need help with PL/SQL Procedure
  166. TNSLSNR.exe - Application Error
  167. how to write a function to call this VB script
  168. case, nvl and datetime fields
  169. Strange TNS problem
  170. LDAP attribute list
  171. XMLType insert
  172. Full Time Database Consultants Needed
  173. can I remove jdk directory from C:\orant?
  174. Try on these security package
  175. Oracle Query
  176. DiskSuite RAID5 performace
  177. Loading from XML to Database
  178. Install this corrective update from the Microsoft
  179. Oracle's Mission Statement
  180. Designer Forms: Linking update module component / stand-alone list of values
  181. JDBC driver setup in UNIX
  182. Looking for OAS SW
  183. 9ias, fully qualified host name?
  184. Cursor, Fetch, and while...
  185. Need help to understand difference, and contrast between Relational database model and the Object-Oriented model
  186. 2nd CFV: comp.databases.etl
  187. Oracle 9i problem
  188. SQL_TRACE Output Location
  189. ORA-01026: multiple buffers of size > 4000 in the bind list
  190. OMWB
  191. Listener Configuration in Oracle 9i
  192. ORACLE 9 and Solaris 5.6
  193. Dynamic SQL with PROC/C++ problem
  194. Lock table only allow INSERT
  195. Max number of records can be fetched in oracle in one call
  196. 8i and SuSE 9 Pro
  197. More Help Required.. in Replication of Oracle 9i in Rh9 (if the query is repeated by me sorry)
  198. How to emulate WRITETEXT / Writing to LONG fields
  199. Oracle upgrade advice
  200. WinPure .. List Cleaner .. Opinions/Recommendations?
  201. redirect SQL Trace output
  202. Index on Number & Varchar2
  203. Index on Number & Varchar2
  204. SYSRESV Utilitity for Windohs??
  205. select next highest salary or last login date ...
  206. Standby database on Standard Edition
  207. keyword override
  208. Install problem on Redhat
  209. how to install oracle 9iR2 on windows 2003?
  210. Question on debugging TNS-12560
  211. Beginners problem with assigning object methods.
  212. ORA-06530 - Uninitialized composite on dbms_fetch for pipelined table function
  213. No Data found error
  214. establish oracle connectiviy with oracle
  215. will Oracle 8i run on Novell Netware 5.0
  216. Addition of constraint during creation of table
  217. RFD: Periodic FAQ & Charter post
  218. Static to Dynamic linking
  219. Passing Java object as parameter to the java stored procedure
  220. Bug of function-based index
  221. new to reports 6i
  222. How to say it in SQL?
  223. Monitor SQL queries
  224. Fatal NI connect error 12560, connecting to:
  225. 816 proC on debian linux; mathcalls.h issue?
  226. Error changing Character Set
  227. ODBC for 8i Single user version
  228. TNS 12545 urgent !!
  229. [beginner] sequence
  231. Statistics information
  232. cursor problem
  233. Q: Oracle Forms on WinCE
  234. Help: Forms 6 Template
  235. trigger problem
  236. Oracle 9i Database Server on Windows 2003 Server
  237. how to use select clause in assignment
  238. migration from oracle 8i to 9i
  239. CLOB/NCLOB help needed please.
  240. Connecting to default oracle instance
  241. Hot Backup Question
  242. VARCHAR variable in where clause
  243. Sql select question
  244. thanks
  245. Help with returning XML from Oracle function to JSP
  246. regarding some databse design rules
  247. sql*loader utillity for importing text file into oracle
  248. Remote Function Call: Internal Error
  249. MERGE over db-links
  250. OFFSET function in oracle
  251. WTB: Oracle 8i CBT training CDS
  252. PLS-00201: identifier 'P_TEST_DEL_VAL_ERR' must be declared
  253. How to backup a 2 Tb Oracle data warehouse ?
  254. automatic shutdown/startup
  255. Updating LONG columns
  256. Using Veritas Netbackup with Oracle Export/Import
  257. OCI LOBS and AQ, help needed
  258. MINUS operator - How it works.!!??
  259. Complex Searches
  260. RE: Upgrade from 8i to 9204
  261. ORA-01840: input value not long enough for date format
  262. Oracle9i Forms Class
  263. Oracle Java Certification
  264. Error: ORA-01704: string literal too long
  265. Fast retrieval and display of results to web browser
  266. Migrating Oracle 7.3.2 to 9.0.1
  267. Refcursor value is invalid
  268. Session Defaults
  269. Traversing, while keeping a constant
  270. Conceptual modeling like in the book
  271. Reading flat files from pl/sql
  272. XML DB Repository Update Contents
  273. Take a look at that important package from the MS Corp.
  274. SQL Formatter
  275. minus and intersect functionality
  276. recomendations for web-based application functional design & project tracking tool?
  277. insert and select in one statement
  278. Seeking or
  279. Oracle Financials - security
  280. Ora-942 in stored procedure
  281. oracle designer
  282. Re: Check that important patch from the MS Corp.
  283. Oracle 7, Indexes
  284. Can sqlldr append to bad file?
  285. not available for install on Oracle 9i Client for openVMS
  286. idle time
  287. variable datatype returning
  288. Materialized views are not getting refreshed
  289. Newbie Question: CLOBs, LONG and text fields
  290. Extract the beginning of a string
  291. Client 8.0.6 doesn't work on win XP
  292. where is tkprof in 9.1
  293. connectivity - integration Oracle - SQL server
  294. How to prevent "Oracle8 ODBC Driver Connect" dialog from appearing?
  295. Take a look at that corrective update
  296. connecting c,c++ to oracle in windows or dos
  297. Re: Oracle 9i software- for DBA exam
  298. How to use index
  299. SQL question / Multiple rows output in one line
  300. Privileges On Procedures/Functions/Packages
  301. Seeking Patch 3006854 ( to install Oracle 9i under Red Hat Enterprise Linux 3 ES/AS
  302. ODP.Net vs OO4O
  303. Citrix Metaframe and Oracle 7 Client
  304. can't login to oracle dba studio as sysdba
  305. Oracle and Windows Server 2003
  306. Red Hat personal roadmap on the skids. Whither my dev box?
  307. Limit the levels for a query with CONNECT BY
  308. Stored Procedure Syntax to Copy data from Server to Server
  309. New Oracle monitoring tool ... Sorry :-) here is the webpage
  310. New Oracle monitoring tool ...
  311. discontinued XCOFF64 file
  312. SQLMENU50 :: user not authorized to use SQLMENU
  313. Procedure builder 1.5.8 (forms 6.0.8)
  314. Data mining/Data Warehouse on Web services
  315. moving items between databases
  316. Re: error opening oracle*terminal file frmweb
  317. Choosing DBMS and architecture for ecommerce website
  318. Transaction hangs
  319. After a few minutes of querying the database my session disconnects abruptly. Can som
  320. What is the maximum number of tablespaces that contain data for a table containing tw
  321. To use C sort routines in the server side packages which file must contain support fo
  322. Which clause in a create user statement restricts the number of tables a user can add
  323. Into which file do records rejected by Oracle due to primary key constraint violation
  324. How can I improve performance of queries on tables containing all words in the dictio
  325. In which database memory areas is SQL and PL/SQL parse information is stored?
  326. I am attempting to take tablespace offline and receiving the following error: ORA-
  327. In which table is Oracle database audit information stored?
  328. 1. Do you know in which tablespace the tables that store information about the Oracle
  329. Why length()/dump() return different substring length values ??
  330. Open twice (or more) the same cursor
  331. Newbie could use some help on a simple(?) recursive query.
  332. Third party utility for encryption and full text search
  333. oracle on OS X 10.2.8
  334. Newbie question on ORA-12560
  335. query tuning
  336. Boss doesn't understand Oracle ...
  337. Re: oracle JDBC - how to detect uncommitted work on an open Connection?
  338. sql using full table scan instead of an index
  339. Removing Leading Zeros Using SQL
  340. Oracle JMS problem
  341. Enterprise Manager 2.2 on NT4 gathering from HP/UX11 and
  342. procedure compilable over db link?
  343. Re: Uploading file
  344. Oracle Sql Optimalization
  345. Errors after creating FBI
  346. Oracle Visual Basic Connectivity
  347. bdp or odbc?
  348. Oracle 8i Cursors via JDBC
  349. OODB References
  350. count (1) and count (*)
  351. Parsing form fields using pl/sql - not a newbie, but this one has me stumped.
  352. Re: utl_file.fopen and Oracle v9
  353. DBA role
  354. UTL_FILE.OPEN problems
  355. Looking for a Gig Consulting or Full-Time
  356. Passing a space as an argument to SQL*Plus
  357. Keyword delimiters
  358. Re: ORA-06508 on Citrix Metaframe XP with Oracle 8.1.7
  359. load file to clob using loadfromfile(oracle8.1.7),but the length of file and clob is not equal
  360. Refer to block item using string
  361. how to select all rows where a colums has null
  362. reg oracle 9ids report printing
  363. Remove Duplicate Rows without a Primary Key
  364. Re: CLOB.createTemporary throws ClassCastException...
  365. optimum datatype for primary key column O9i
  366. problem with dbca on Oracle 9i R2 Linux
  367. How to implement 'search' similar to Google
  368. My attempt to read the view creation code stored in the Oracle data dictionary has en
  369. Which Oracle dictionary view gives information about the position of a column in a pr
  370. Does PL/SQL allow cursors to contain subqueries?
  371. What are two components of the Oracle database security model?
  372. Having problems running query in Oracle
  373. [Q] oracle spatial functions
  374. Check this correction patch
  375. TEMP Tablespace Question
  376. sql comparison and flag
  377. "HAVING" problems with query and using 'having' with group by
  378. What is the efficient way to select data from huge database?
  379. Take a look at this pack for Windows
  380. simple question about sql*plus
  381. simple question about indexes
  382. db2 vs oracle
  383. Wich newsgroup ?
  384. FWD: Watch the corrective pack
  385. Install this update from the M$ Corp.
  386. troubles with oracle on a 2k controller domain
  387. Re: ORA-06508 on Citrix Metaframe XP with Oracle 8.1.7
  388. Oracle 8.1.7 on Windows 2003 Cluster??
  389. Secure JDBC connection to Oracle 9i
  390. Unable to enlist in a distributed transaction Error in COM+ with Oracle DB
  391. Export dump files and stripe-sets
  392. Forms 9i - LOV icon doesn't show up. Does anyone know why?
  393. How to assign a value to a variable
  394. Oracle Tools - Auto Commit Feature
  396. updating table with two images
  397. Oracle 9i and Connectivity
  398. trouble shooting oracle instance
  399. Re: Oracle on Solaris-Intelx86?
  400. Page Processing Efficiency
  401. **HELP** Calling Oracle Stored Procedure from vbs script
  402. d2k installation
  403. oracle 8.1.7 + linux .trc dump
  404. How to start an oracle instance
  405. Re: Oracle on Solaris-Intelx86?
  406. Looking for scenario simulation tools for Oracle
  407. OWB gives ora-00942: table or view does not exist EVEN if the table exist
  408. Are there any contentions in Latchs?
  409. Oracle8i Client 8.1.7 Installation
  410. Oracle vs. SAS numerics - any ideas?
  411. Snapshot from DB2
  412. Re: issue of connecting oracle forms with sql2000
  413. Oracle Forms XML DTD available?
  414. Query tuning help, please
  415. Oracle 8.1.7 Client Install On Windows 2000 Working
  416. Oracle 8.1.7 Client Install Problem On Windows 2000 - Download, No CDs.
  417. blob dispaly using psp
  418. How to do Media Recovery for System01.dbf????
  419. install orcale 9i in red hat 9
  420. Can Crystal Report access Oracle on Linux ?
  421. does ORACLE support WMI?
  422. Oracle9ias SSO/Infrastructure installation error.
  423. Difference execute immediate within PL SQL
  424. ARCH is FULL
  425. Problems with "IN"
  426. what is the meaning "latch" in the shared pool and library cache?
  427. index stats
  428. stats on indexes
  429. loss of performance when using anonymous pl/sql blocks?!
  430. How to read UNCOMMITED data in Oracle?
  431. Help with sqlplus in Oracle.
  432. Slow Crystal Reports with Oracle
  433. Use SET ROLE in Oracle Forms Builder
  434. Does Oracle + VB is a good combination
  435. Oracle 9i client connectivity to Oracle 7.1.4
  436. remote server access - ORA-01034:
  437. On the subject of Data Warehouses, Data Cubes & OLAP....
  438. what is the meaning of creating database link but omit using clause;
  439. after set db_domain parameter,but can not resolve database link problem.
  440. Re: Error While changing the session parameter NLS_LANG
  441. JDBC with mulitple instances of database
  442. lenth of SQL statement
  443. Re: Error While changing the session parameter NLS_LANG
  444. Integrating crystal reports with oracle forms
  445. Oracle 9i database for Solaris 8 intel
  446. How to enable TNS trace
  447. Why does Windows XP not support Oracle 8i?
  448. Star Transform condition?
  449. "database not open" - Rookie
  450. Oracle Upgrade problem : from 8.1.6 to 8.1.7
  451. Install these package that comes from MS Corp.
  452. sql question
  453. Oracle Applications - Activity Based Management
  454. How to fix? ORA-22990: LOB locators cannot span transactions
  455. oracle plsql & cvs
  456. OG-00637 Unhandled PL/SQL exception 102098
  457. Oracle 9i Installation on RH Linux 9
  458. Oracle takes the wraps off SME database
  459. Create Primary Key on View
  460. REF Cursor returned across db link?
  462. I cannot install Oracle8i client on WindowXP, please help.
  463. sql*loader - partitions - domain index
  464. ORA-01503: Create controlfile failed
  465. Help with DECODE function and crosstab query
  466. oracle applications 11i installation on Linux 9
  467. Check out these security package from the MS Corp.
  468. Basic Sql performance question
  469. Oracle 9i does not install (with a Mandrake 9.1)
  470. Inserting old value into a column
  471. Raw on Linux
  472. Oracle Failsafe Question
  473. Starting database up...
  474. Installing Ora9i on Windows XP
  475. Running Oracle database on Unisys OS2200
  476. [WEIRD] Merge date and char
  477. How to retrieve temporary BLOB value from PLSQL to Java?
  478. Grant Previleges to Objects and Varrays
  479. restore Issue
  480. update using an alternative to correlated subquery
  481. stored procedure, cusor help
  482. Unsigned integer to IP address?
  483. How do I get an array into a resultset
  484. table name substitution in pl/sql
  485. Oracle readies CRM and supply chain upgrades
  486. Seeing double output in SELECT SYSDATE FROM DUAL
  487. Seeing double output in SELECT SYSDATE FROM DUAL
  488. Seeing double output in SELECT SYSDATE FROM DUAL;
  489. Oracle Database 10g. When ?
  490. Importing specific tables from a full export ?
  491. Oracle 8.0 Copy long from 1 table to another
  493. Database Integration Question
  494. RAC - rebuild 2nd Node
  495. global temporary table --> invalid ROWID?
  496. Changing table size
  497. Oracle XML
  498. Re: Taste this critical pack
  499. Move BLOB partitions to a different tablespace
  500. Books on Oracle Insall / Configurations
  501. selecting ROWNUM causes query to take forever
  502. Difficulty to interpret a TKPROF output
  503. parameters.add in .NET (Bind problems?)
  504. Question about Partitions and Indexes
  505. puzzling deadlock
  506. Instant legal US University Bachelors & Masters in Database $100. Accredited and Verifiable
  507. SIGBUS and SIGSEGV Errors in HP-UX 11 and Oracle 9i
  508. Who spawns a dedicated server process?
  509. Oracle login error from the web
  510. Can I delete some statisitcs table(s) from Oracle to tune it?
  511. Oracle DBA Opportunity
  512. Help installing Oracle 9i after installing Discoverer
  513. Oracle home selector
  514. Errors per user session!
  515. Oracle export table to ascii
  516. how to change this query, so that it will not use the correlation?
  517. Re: Import Error Code IMP-00069, Please help.
  518. How to imp from oracle 8.1.7 to 8.1.6 in Unix?
  519. Oracle 8.0 - Can't use function index
  520. Oracle certification exam preparation
  521. Help with MIN field value
  522. Third party indexing solutions
  523. OCI DirPath
  524. trim(' ') problem & ORA-03113
  525. Forms 4.5 login -- cannot type username or password
  526. 9.2.0 migration now cant log into Apps
  527. PUBS Database
  528. Question about deleting table duplicates
  529. Oracle stored proc. from VB in ADO
  530. Need an algorithm to process nodes in a tree recursively
  531. How to find PINNED tables/indexes etc?
  532. query oracle_home in sqlplus
  533. combining rows from 2 tables
  534. one code for two tables
  535. case question
  536. Distributed database question
  537. Partitioning and Tablespaces
  538. Best practices: commit by database layer vs. commit by caller
  539. Unistall Oracle with Faulty Uninstaller
  540. How to display a BLOB/CLOB in Oracle Forms?
  541. OCP is not enough, need extensive experience
  542. Re: Company thought DB2 will be better than Oracle.
  543. Linked Servers
  544. Isolation level on Ora 9i
  546. Oracle DBA: Where do I start?
  547. Oracle Long mapped as CString
  548. 8i to 9i upgrade
  549. Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
  550. Oracle Real Aplication Cluster