View Full Version : oracle answers


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

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