View Full Version : oracle answers


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

  1. Pro*C vs Oracle Java Stored Procedure
  2. Query Tuning for a single select statement
  3. Restore the database backup in Oracle9i
  4. how to update columns in oracle forms
  5. Improper result from query
  6. Loading Multiple CSV Files into Oracle DB
  7. FRM -41039: Invalid alert ID 0
  8. error 00214
  9. oracle error
  10. oracle 9i reports
  11. how to declare a global variable in report builder?
  12. Call Javacode from Pl/SQL
  13. case when gone wrong
  14. Workflow
  15. how to change search conditions dynamically in where clause using pl/sql
  16. SELECT WHERE SettingKey = N'Logon' FAILS
  17. insert into a table with selected columns.
  18. Oracle does not exist and shared memory realm does not exist error
  19. VBA Oracle DB Connection String
  20. can anyone pls help me to join tis 2 query statement
  21. How to add a sum up column to a table
  22. ORA-27101 problem
  23. Loading Excel File into Oracle Table
  24. How to drop and then create a table during runtime in oracle9i
  25. Nested Cursor
  26. Sequence.nextval incrementing itself over time
  27. Not able to open test.fmx in oracle application server 10gR2
  28. oracle report 6i
  29. Bulk Import of Data into an Oracle Database
  30. Loading XML data to Oracle Database
  31. Joining of 2 SQL queries
  32. how to compare two columns and return the value which is not matched
  33. Mutation of triggers
  34. Traversing a tree - using a little recursion in SQL
  35. how to get colunms displacement for a table in Oracle?
  36. i'm trying to load data from uploaded file in php by using sql loader
  37. error questions
  38. How to connect oracle 9i database & developer suite ?
  39. how to use a list item in oracle forums
  40. rowid
  41. how to enter only time in the field of table and sum the time
  42. Query
  43. Equivalent to SQL Server Integration Services
  44. Drop by to ask for help
  45. how to execute query without having to declare schema all the time
  46. File Dis51usr.ini Of Oracle Discoverer 10g
  47. i'm having trouble in defining primary key... HELP ME guySSSS
  48. Arbitrary order in SQL query
  49. load data
  50. oracle sql
  51. How i can use "IN CLUASE" with block fields.
  52. Add Field To parameter form
  53. Best practice for inserting many to many records
  54. dynamic :NEW
  55. How to recreate Foreign Key constraint
  56. Multiple Counts in 1 query
  57. RecordSet inside procedure
  58. What is a dblink ?
  59. orace 6.0 designer
  60. like %
  61. Connection pooling
  62. import .lst files
  63. I got a error when i am establish the connection between oracle and sql server
  64. SQL Select statement as a keyword search
  65. Iterative function in sql
  66. Table Output
  67. Oracle XML and XPath
  68. REFCURSORS over dblinks
  69. oracle error 10034
  70. Sql
  71. Oracle reports 6i and asp.net
  72. Report 10g Vs Discoveror
  73. Query Takes time to execute
  74. Generate DDL of Schema
  75. Easy question from MS SQL to ORACLE
  76. Integration of two databases into one Database
  77. Maximum size of Linesize
  78. grant access to remote user
  79. Recover deleted rows from a table from archive logs?
  80. Error in writing to directory /tmp/Orainstall .....
  81. Finding all tables with a particular field?
  82. Views and performance
  83. Installing on Mac Os
  84. How to diagnose inaproppriate Oracle SGA component size?
  85. server configuration
  86. RAC nodes regularly freezes for about 10 seconds
  87. How 2 split priority, reports low, transactions fast
  88. 7.3 on 03 server
  89. SELECT ... WHERE column LIKE parameter||'%'
  90. Re: Installing Oracle 11.5.8 on Mandrake
  91. history
  92. Oracle CBT
  93. Which database design tool
  94. Oracle Schema
  95. SQL 3 or 4 trial key needed
  96. UNIQUE CONSTRAINT ERROR
  97. Basic Questions
  98. Catching "ORU-10027: buffer overflow" exceptions in PL/SQL
  99. OLEDB and Oracle XE ?
  100. Patience for a Oracle Noobie
  101. Slow query on date field via views
  102. Crystal report db problem
  103. current sql running
  104. .NET Reporting against and Orcale Database
  105. <REQ> oracle lite info
  106. S: Biomega Mark Newson MN03
  107. Obtaining a Column Which has MAX in Another
  108. writing records while doing select.
  109. Multi Master Databases
  110. spool file: saing to non default location
  111. Request for Resume's - Siebel Production Engineer IV
  112. deducing ranges in SQL
  113. Oracle OLEDb
  114. What is it like to work with Oracle?
  115. Great Job Board
  116. A great onestop spot
  117. Generating CREATE TABLE statements
  118. Instantclient 10 on Solaris 10
  119. Suggest books for beginner, and good as a reference for later use
  120. Remove all tables for user with one SQl statement?
  121. validation testing -- use TPC-C? (or what?)
  122. US-VA: Sr.Oracle ATS/Testing LoadRunner QuickTest Pro # 1129R1
  123. Re: Does any one know where i can get oracle 8i
  124. Type for COUNT() as VAR ?
  125. Using FORALL with associative arrays
  126. Oracle Driver question
  127. INSTR and string length problem
  128. Oracle Application Server webcached leaking file handles
  129. Connecting mobile application to database
  130. Empty string behaviour...
  131. Upgrade from 10.1 to 10.2
  132. Sqlplus (set verify command)
  133. Oracle Rac
  134. SQL re-parsing on query executed against a remote database usingdatabase links
  135. Questions regarding materialized view logs ...
  136. Wanted:Oracle Portal Course Material
  137. Joins vs nested selects
  138. Virtual Indexes
  139. question about internal
  140. Inpersonate a user
  141. I cannot install emca anymore on oradb10g which runs o.k. after upgrade mac osX 10.4.2
  142. Question about init file
  143. Binding an array to an input variable in OCI
  144. Very basic question
  145. Help needed to connect DB2k on PC to v7.3 on VMS
  146. SELECTing multiple rows to a single output line
  147. Oracle 10G RAC stability problems
  148. oracle designer-timestamp-date
  149. PowerPoint Slides Available for Intro & Advanced DB Course
  150. ORACLE 10G R1 on SLES 9SP1
  151. JDeveloper and Oracle 7.3.4
  152. Captaris RightFax and Oracle 11i help needed
  153. partitioning advice?
  154. Oracle and DB2
  155. Row values changing back to old values randomly???
  156. Unload data
  157. install oracle client on Debian
  158. 8.1.7 on Redhat Enterprise 3
  159. Oracle Text: Indexing UTF8 or UTF16
  160. ORA-12170 Connect Timeout
  161. Erdish programing language
  162. does oracle support more than one CPU for SuSE Linux 9.1 or 9.2 or 9.3 Professional Linux
  163. Not a group by expression
  164. Speed up Select distinct
  165. Migrating Oracle from AIX to W2K3
  166. Multi-statements SQL and stored_procedure calls
  167. grant SYSDBA to user With remote_login_passwordfile=NONE?
  168. PL/SQL developer Oracle9i
  169. Convert between Charsets in a plsql stored procedure (ora10g)
  170. Connectivity for XP
  171. Re: How can I show the values from column 1 in "Select ??? from tabel" ?
  172. PL/SQL newbie question
  173. PL/SQL newbie question
  174. PL/SQL newbie question
  175. Mysterious 9.2.0.4 (on HP-UX) problem
  176. PL/SQL Object Question
  177. Help with JDBC
  178. PL/SQL newbie question
  179. ff
  180. why to migrate from infromix to oracle
  181. How to do UPDATE with GROUP BY
  182. "No size set for variable length data" Oracle update error with empty string in .NET
  183. tnsnames.ora
  184. with clause for subquery factoring
  185. UTL_FILE(HELP)
  186. DW + Oracle: see tbls w/ recordset but not insert
  187. Rules Engine
  188. Convert timestamp to date
  189. Oracle Reports JDBCPDS
  190. Changing db_block_size
  191. The Greatest News Ever!
  192. The Greatest News Ever!
  193. The Greatest News Ever!
  194. Great News Blog!
  195. (",) Do You Want To Know For Sure You Are Going To Heaven?
  196. (",) Do You Want To Know For Sure You Are Going To Heaven?
  197. Fast bulk load with API?
  198. Is it possible to delete parts of a table without using rollback??
  199. Help needed for Database Replication
  200. (",) Do You Want To Know For Sure You Are Going To Heaven?
  201. Why you don't usually get answers here ...
  202. Why you don't usually get answers here ...
  203. SQL - Select and filtering whereby a date is not null.
  204. Forms Builder speed
  205. Performance difference between Windows and Solaris 10g
  206. (",) Do You Want To Know For Sure You Are Going To Heaven?
  207. Sequence Error ORA-02287
  208. How to build database to support user-specified entities and attributes?
  209. Pivot query in oracle- Please help!!
  210. Pivot query in oracle- Please help!!
  211. Read Text file into Oracle Reports
  212. OCI library for Oracle 8.1.7.4.0 on OpenVMS
  213. Follow up to previous post
  214. SQL Query
  215. AVG and SUM in subquery return wrong values
  216. Invalid attribute/identifier error
  217. XML joining Nested resultsets
  218. How to build database to support user-specified attributes?
  219. port/protocol for sqlplus connectivity
  220. Problems: Oracle 9 Installation and Windows XP SP2
  221. Oracle 9 Installation Problems under Windows XP SP2
  222. install oracle 8.1.7 and developer 6i under same oracle home.
  223. Installing Oracle on Linux Redhat
  224. Converting a bare number to an interval and back
  225. ORA-29531 - And the method is declared both PUBLIC and STATIC
  226. External SQL functions exported by DLLs
  227. Oracle Discoverer Newbie...
  228. How to debug .pc file instead of debug generated .c file?
  229. Aarrrgh - this is NOT the place to ask!!
  230. Flashback over database link
  231. Pro*c for Windows
  232. how to do dbms_application_info.set_module from JDBC code
  233. Pro*c for Windows
  234. Open help file through forms 6
  235. Oracle Software Updates fees
  236. PL/SQL Examples
  237. Export of data
  238. Calling an Oracle stored procedure
  239. how can I connect to oracle in C language?
  240. How to pass an Integer Array to a Stored Procedure?
  241. Version control of Oracle Stored Objects.
  242. Oracle Text for searchengine across multiple columns/tables with different datastore
  243. UTL_SMTP Stripping MIME-Version header information
  244. UTL_SMTP Stripping MIME-Version header information
  245. UTL_SMTP Stripping MIME-Version header information
  246. Pro*COBOL and (possible) NULL host variabe in WHERE condition
  247. object_id vs data_object_id in user_objects
  248. DB2 User Group Italy - next meetings March 2005
  249. Oracle to SQL Server using JDBC
  250. format date with Oracle Dynamic SQL
  251. Oracl Lite 10g and ADO.NET problem :(
  252. Need latest patch for 6i Tools
  253. Printing Bitmap instead of Character
  254. Does Oracle JDBC driver support data compression
  255. What is the best (freeware) SQL GUI CLient?
  256. Pls help,oracle error
  257. How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer
  258. iSQLPlusTimeOutInterval in 10g
  259. sqlplus 10g and OS X
  260. Alternatives to SQL *Plus
  261. Converting a type (e.g. Decimal) BEFORE writing to ResultSet ?
  262. Comparing DATE with TIMESTAMP fields possible ?
  263. serious problem in advanced replication
  264. Inner join with where
  265. Trigger insert on parent table question
  266. moving oracle DBs & 9ias from system A to system B
  267. OBE error
  268. Spotlight For Oracle
  269. Can you help me with JDBC getDate() error?
  270. Retrieving database record with the lowest value in field aaa?
  271. Converting NUMBER, DATE and VARCHAR2 database fields from Resultset to variables?
  272. Getting MetaData for JDBC tables with getTables() does not work?
  273. Detecting the INSERT format for DATE database fields?
  274. Training in Oracle Interconnect/BPEL
  275. DB2 Crushes Oracle RAC on TPC-C benchmark
  276. CLOB: Why are they so slow (compared with VARCHAR2)
  277. Instant Client 10g
  278. replication and primary key
  279. Looking for authoritative reference on PL/SQL grammar
  280. acceptable way to program
  281. Re: Working with U.S. Zip Codes
  282. Ocp Certificate Question
  283. Minimal Install Config?
  284. What (dev) tools does Oracle use (internally) to create applications of the E-Business suite 11i or older version?
  285. A possible breakthrough in analyzing 500GB+ data bases
  286. design of application / schema / multiple development schemas
  287. configuration management
  288. table API
  289. DLookup uses twice the SEQUENCE numbers
  290. Which oracle server ?
  291. ora-04021 - how to analyze
  292. Breaking News: MySQL beats Oracle in Benchmark
  293. Unhandled Exception on Oracle Form Builder
  294. website hosting
  295. Trip to Disney
  296. common UPDATE syntax for SqlServer and Oracle
  297. to oracle or to ms sql server 03
  298. Avoiding automatically starting Oracle
  299. MOLAP info
  300. Inserting a value for a BLOB field using an SQL script
  301. Debugging "Table Mutating" errors... 8.1.6
  302. I found this great little site
  303. Function called for row not in query result
  304. [q] Designers
  305. DBA Needed
  306. Cross: Molio bih preporuku...
  307. Oracle DST Setting in OpenVMS Version.
  308. Native Delphi driver
  309. Oracle Download Fails (Disk Full)
  310. HELP: ORA-12571: Packet writer failure
  311. Linked Server (Oracle 9i)
  312. barcode function
  313. Dynamically execute PL/SQL statement
  314. insert into returns 0 rows
  315. 9i DBA Fundamentals I CDROM
  316. Why would explicit system privileges work and inherited through a role fail?
  317. Unique constraint and NULL values
  318. Oracle Forms Developer error on Oracle9i Developer Suite
  319. membership operator with pattern matching
  320. selecting a column according to a minimum
  321. RMAN
  322. Comparison of DB2 and Oracle?
  323. how to sql query this?
  324. How to Fail at Software Development
  325. Uninstalling Oracle9i Personal Edition
  326. How to specify column header titles in a SQL CREATE TABLE statement?
  327. MSAccess and Oracle
  328. Oracle Frontend / Backend Protocol
  329. Server Data on Insert property
  330. Oracle 10g & EM
  331. Number of Quarters
  332. Good tutorial or book on Oracle db?
  333. How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?
  334. Distributed transactions and Oracle RAC load balancing problems - advice needed!
  335. ADO Addnew and identity columns
  336. cursor select/delete where current of not working
  337. Missing from one table
  338. Data not importing correctly
  339. Oracle programs - no source, only executable?
  340. Using the NEW_TIME function
  341. Newbie question
  342. Calling COM or DLL's from triggers ?
  343. Implementing complicated constraints
  344. Service Temporarily Unavailable (Help)
  345. Failing to connect to Oracle Server in ASP Session_OnEnd
  346. hi
  347. Selecting a column twice
  348. 10g timestamp
  349. GLOBAL TEMPORARY table - serious join performance problem
  350. Desperation Post JDev/Applets
  351. REF CURSOR returned from Java -- How to use?
  352. Oracle ODBC connection problem
  353. problems with export
  354. Retrieve the DBMS_OUTPUT buffer from ASP/ADO
  355. Question about commit
  356. Optimization advice
  357. Anybody used the Universal Table Browser?
  358. Can we delete files from cdump folder
  359. Oracle9i: very big problem with precition of SYSTIMESTAMP !
  360. Granting privileges on table owned by different owner
  361. Granting the privileges of existing objects within a schema to a new role
  362. Oracle 9i: Problems with SQL parameters
  363. dead.letter in my RMAN backuppiece
  364. accessing a view from another user
  365. Oracle Data Server
  366. Oracle 11i position/Ottawa/Canada
  367. test
  368. Caompaq fire wire usb 2.0 PCI cards and Redhat Linux / Oracle RAC10g
  369. Administration script to check DB
  370. Schema changes on on large tables
  371. Creating an EUL Gateway for Discoverer
  372. Creating a table in Oracle DB if it does not exist, using SQL
  373. user_tab_columns
  374. Migrating tablespace from dictionary managed to locally managed
  375. Index Organize Tables
  376. [q] How To Create Rpository
  377. how to identify 2 different session on same machine
  378. can I audit a truncate on a specific table in Oracle8?
  379. when to merge two databases
  380. Configuring 10g OEM for USER DEFINED ALERTS
  381. Configuring 10g OEM for USER DEFINED ALERTS
  382. Bring over Oracle 9i db to Oracle 10g
  383. SQL Loader
  384. Oracle_sid
  385. Easy end user reporting and graphing tool for Oracle standard edition.
  386. New install of 10g
  387. SELECTION CRITERIA
  388. Openning/Shutting down Oracle database from the Client's SQL*Plus
  389. Tables without primary key
  390. 10g job scheduler errors
  391. Red Hat Professional Workstation
  392. Poor performance after oracle 8i upgrade
  393. Bakbone Software
  394. Help with Import ORACLE
  395. Installing 9i or 10G on Linux RedHat x86 - errors.
  396. test
  397. database structure problem - advice please?
  398. Start 10g Infrastructure and AS
  399. Again about Oracle 8i on Win XP Pro
  400. Create trigger on view with long raw column
  401. Java Tree In Oracle Forms
  402. Regarding query
  403. error linking oci7 with oracle9i on AIX 4.3
  404. Reorder Primary Key - any problem?
  405. Oracle Database performance on Windows 2003 with IIS 6
  406. Oracle error
  407. Create ResultSet "from scratch" in Oracle Java Stored Procedure?
  408. $85/hour - Oracle Advanced Benefits Analyst / Lead
  409. can you intergrate oracl REPORTS with version constrol software LIKE.....
  410. oracle
  411. PLS-00306: wrong number or types of arguments in call to '||'
  412. Migrating from HP-UX to AIX
  413. Installing Oracle 9.2 without using OUI (Alpha OpenVMS 7.3-1)
  414. Subject: Oracle Analysts, Designers, Developers needed. Oracle 9i, 11i, PL/SQL, tools knowledge etc
  415. AIX CIO with Oracle
  416. For Billy Verreynne
  417. import dmp into SQL Server
  418. ORACLE/ PORTAL/ CONTRACT/ IMMEDIATE
  419. ORACLE/ PORTAL/ CONTRACT/ IMMEDIATE
  420. ORACLE/ PORTAL/ CONTRACT/ IMMEDIATE
  421. basic plsql question
  422. SQL optimizations in Oracle
  423. Killing oracle sessions
  424. Oracle (6i) application crashes in Citrix farm with error ORA-06508.
  425. Oracle (6i) application crashes in Citrix farm with error ORA-06508.
  426. Application Development Framwork for 10g and BC4J for 9i
  427. send a table of records from pro C to Oracle pl/sql stored procedure
  428. DBFlash for Oracle - looking for beta testers (modified post)
  429. DBFlash for Oracle - looking for beta testers
  430. db2 vs oracle
  431. O8 reorganization or O9 upgrade - which first?
  432. Show/Hide column name
  433. Oracle administration and Performance - Linux Cluster vs Windows Cluster
  434. ORA-06502 PL/SQL character string buffer too small
  435. JDEVELOPER/ CONTRACT/ FL
  436. JDEVELOPER/ CONTRACT/ FL
  437. dbms_job polling interval
  438. table relationships
  439. Oracle Forms Reference
  440. PROC Problem : Select for update
  441. [9i] Not enough large pool during export
  442. Oracle 11i with AIX 5.2
  443. TNSPING works SQLPLUS fails whsn connecting to remote server
  444. connections differences between 8i and 9i
  445. Large Table Update/Merge problem
  446. FETCH arbitrary columns from a ref_cursor
  447. ORA-12154: TNS:could not resolve service name
  448. Understanding "lsnrctl status"
  449. [q] IMAGE
  450. Question on select count()
  451. RMAN resynchonize question
  452. How to call a private package level function
  453. Convert Long to Varchar
  454. direct path insert
  455. Oracle Training Question
  456. how to increase processes?
  457. How to return a status from sqlplus to .ksh unix script ?
  458. change port number
  459. PL/SQL error !
  460. Resizing the SGA
  461. How to bulk insert an array to Binary data using OCI.
  462. question about Oracle certification
  463. problem w/ creating view to show previous year's data...
  464. ingres odbc driver
  465. Select query for sum of hours
  466. Unable to install Oracle 9i on IBM R51 notebook
  467. Oracle 9i: Keep multiple servers in sync
  468. Insert multiple rows via XML?
  469. Transactions on remote databases
  470. SQL Update with a Join Syntax
  471. HOW to USE 'LONG RAW' in Bulk Insertion using OCI
  472. SQL 9i OUTER JOIN QUERY
  473. PL/SQL problem with Updates that specify varchar
  474. ORA-00054: resource busy... - what on Earth?
  475. Calculating Average on columns with zeros.
  476. Report Generator for Oracle and other RDBMS - beta testers needed
  477. Oracle Forms
  478. How to insert an Array to Oracle?
  479. Conversion UTF-8 -> CL8MSWIN1251
  480. encapsulate/embed pl/sql in DAO
  481. sql - statement: building differences between data-sets
  482. View-Concept Data Mining Oracle
  483. Enterprise OpenSource Project using Java Stored Procedures of Oracle
  484. tablespace
  485. Dynamic SGA and pinned
  486. Error message on ODBC Connection
  487. Problem with Oracle
  488. Corrupt Primary Key index on table causing ORA-600 internal error
  489. Java Stored Procedure extraction from Oracle database.
  490. [newbie] select records, update with procedure
  491. Fastest for Inserting into Oracle?
  492. Invalid attribute in connection string. Nuby needs HELP!
  493. low cardinality and highly concurrent db
  494. Oracle SQL query by date
  495. dynamic sql substr length strange value (aix/hp differences?)
  496. Law for ORACLE administrators
  497. Database design
  498. [NEWBIE] Help with a simple query
  499. Report Generator for Oracle and other RDBMS - beta testers needed
  500. Oracle JDBC connection string : how to hide password ?
  501. rowid ?
  502. Oracle Noob need help with function
  503. Conference Announcement
  504. How to lock a row over a SELECT followed by an UPDATE
  505. SQL*Plus Parameters
  506. Query Performance
  507. is Oracle technically better than Ingres ?
  508. PL/SQL - ref cursor
  509. Oracle10g on Solaris10
  510. query help
  511. Report Generator for Oracle and other RDBMS - beta testers needed
  512. Oracle Data Warehousing Consultant - Toronto - urgent contract
  513. PL/SQL online programming courses
  514. getting server name and db name
  515. Recovery From Loss Of Control File
  516. DB Logoff vs. Schema Logoff
  517. Cisco Access Control Server and Oracle Internet Directory
  518. Couple of Days Oracle Work Available in Surrey
  519. Ahhhhhhhh
  520. INFORMIX equivalent of DBSERVERNAME in ORACLE
  521. Load Balancing in Oracle 9i Forms Application
  522. CBO bug?
  523. Output parameter and dynamic sql
  524. Oracle Slowing Down Each turn - Newbie
  525. PL/SQL code
  526. Ordinal Function
  527. Good Looking? Want to Make Cash Fast? 9041
  528. Oracle 10G Net Config fails to start - installation issue on Windows in a domain
  529. Misterious Error in Pro*C
  530. Pass variable into View?
  531. optimizing sql joins?
  532. Oracel database consolidation criteria
  533. Manually convert data from ZHS16GBK to UTF8 on ORACLE 8(Character Set US7ASCII)
  534. accessing multiple instances
  535. sql corrector
  536. My Silicon Tits 5957
  537. Optimizing Sql - unable to use index
  538. Wrapping up of Views in Oracle DB
  539. Return multiple queries from stored procedures
  540. Return multiple queries from stored procedures
  541. archived active redo logfile group corrupted
  542. Transform Cursor to Bulk
  543. Oracle DB with Pro/5
  544. Oracle ETL consultant (discoverer & warehouse builder exp.) - canada
  545. SQL Problem
  546. update table a.fkid from table b.pkid
  547. Pro*COBOL Precompiler - Generic Make File
  548. Oracle column default value
  549. Oracle column default value
  550. Optimising Oracle 9i for million-record JDBC read-only access