View Full Version : answers

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14
  1. How do I transfer data from Oracle Forms into MS Excel?
  2. ora-01110:datafile 1: '/usr5/system/system/01.dbf
  3. need Department details
  4. image from db to local drive
  5. how to export oracle database to a flat file
  6. Join columns
  7. How can we Check if Oracle stored procedure already running
  8. ERROR: You do not have SELECT priviledges on sys.V_$PARAMETER view.
  9. How do I create a Data Dictionary using Oracle Designer
  10. loading xml file into oracle with dtd validation on,
  11. portint database from oracle to postgres
  12. convert number to date
  13. oracle error. Ora 01033 orcle instalation or sutdown in progress
  14. jasper and IReport against Oracle
  15. Discoverer Query
  16. Form 5 and db10g
  17. update based on subqueries
  18. Scheduling concurrent Program
  19. usage of AFTER LOGON DATABASE trigger
  20. Oracle Report 6i and Oracle 11g database
  21. Oracle exp tool
  22. Potential regression with Oracle 11g in Select Sum
  23. Oracle 8i express edition work in windows Xp sp2?
  24. Sequences
  25. pls anybody tell me wether oracle 8i can be installed in windows xp sevice pack 2?
  26. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater in
  27. which command is used to grant all the privileges to hr user......
  28. data manipulation operation not legal on this view - in a cursor
  29. need query hw to select last 3month,3 week, only friday only sysdate using dual table
  30. Call a package function from C#: PLS-00306
  31. Compute Time Difference in Teradata
  32. ORA-31001: Invalid Resource-Handle or Path name
  33. oracle to pg
  34. Can I create an online application that feeds into PeopleSoft Financials 7.5?
  35. Filters in Teradata
  36. what happens when a sql query get executed containing joins in it.explain in details
  37. mail server with oracle
  38. invalid file operation
  39. how to create a view inside a stored procedure
  40. Materialized view Refresh
  41. Count Results for multiple choice
  42. Oracle query help urgent !!
  43. Apache Installation (https service) issue
  44. how to create .mtw file in oracle transalationhub.
  45. can u help me plz
  46. Joining 2 Queries in Teradata
  47. joining 3 tables-using oracle 10g
  48. How to reduce and avoid spool space error in Teradata
  49. Deleting BG_ABSENCE_DURATION
  50. Count in teradata
  51. trigger error
  52. add constrain in exsiting table
  53. Hyperlink in Oracle Reports6i
  54. TERADATA Equivalent of ROWCOUNT
  55. Scheduled Concurrent Programs
  56. Grants asssigned via roles not works in PL/SQL
  57. Help need in Encryption/Decryption Concepts
  58. How to find the clear text data in an encrypted column?
  59. What kind of a code is this?
  60. Need Table's Alter History
  61. Need logic
  62. to join two tables which has records in columns format
  63. where table is stored in oracle
  64. Oracle Query problem...
  65. Need help with basic sql oracle queries?
  66. Adding Adjustment element
  67. Oracle Application Server Portal Forms
  68. Help in this SQL
  69. Discoverer, Detailed aggregate data warning
  70. oc4j-island:default_island, ajp-host:-missing-, ajp-port:-missing-
  71. date wise report by using oracle form?
  72. Using PL/SQL code in Excel Macro
  73. convert access sql to oracle sql
  74. capturing user id
  75. Excel to oracle
  76. Need dumps for IZO-146
  77. Discoverer Problem
  78. adding a menu to responsibility
  79. Schema level session idle time out in oracle
  80. Business days calc
  81. Getting error 'Root transaction falied to Commit'
  82. Help with a query to copy files (new to oracle)
  83. registering a function in discoverer
  84. between operator in oracle
  85. check constraint
  86. Create chart
  87. set number of decimal in avg() query
  88. oracle help
  89. Oracle 9i
  90. Ora-01403
  91. Fourth,Fifth Normal Form
  92. newb question about sql+ script for appending to end of table
  93. Replication Issue in Oracle 10G
  94. how can we display particular record by using oracle report
  95. oracle - program around ora-02068 error ??
  96. Limit on the length of query
  97. How to get rid of duplicate value
  98. Oracle Error: Unable to cast object of type
  99. Performance Issue with Alphanumeric Column
  100. Create Procedure Oracle Errors
  101. Oracle error returning value from database
  102. Update table with multiple joins
  103. CREATE Table gives ORA-00904 error
  104. Character Set Question?
  105. php and oracle
  106. Oracle Forms: Disable invoking buttton
  107. oracle sub query issue
  108. Returning an Oracle generated GUID through an out parameter
  109. display dates in a month
  110. User parameters and links -Oracle Portal:discoverer
  111. Registering a disceverer report
  112. iSQL *PLUS variable
  113. Oracle Forms or Java/JSP
  114. I fail to understand this..!!!
  115. File Cabinet
  116. wrong number or types of arguments in call to 'GET_DNAME_FOR_ID1.
  117. Rows To Columns--urgent!!
  118. Organizing Categories
  119. Calender in Disoverer Report
  120. sql with regex
  121. submit request with parameters
  122. Disconnecting from database automatically
  123. Oracle text procedure?
  124. Variables in SQL Loader
  125. Converting report to excel or pdf format
  126. How to design a report
  127. Generate SQL from SQL
  128. Display paremeter in the report
  129. case statements in oracle
  130. HRMS Photo upload
  131. Killing a process and a session
  132. Execute Immediate VS Dynamic SQL (DBMS_SQL)
  133. Triggers commit and rollback through a proc.
  134. Concurrent request from procedure
  135. Paramter Form Builder in Oracle Report Builder 6i
  136. Partitioned Index on a non partitioned table ?
  137. Which cursor to use to execute a DML ?
  138. How to PIVOT in Oracle 8i
  139. what is the error in following query
  140. what is the error in query
  141. Why do I have to manually make sequences and triggers for primary keys?
  142. Reg Reports Builder
  143. Procedure or Function terminates with failure without being handled
  144. problem to find record between perticular value
  145. Mutating Error in Triggers
  146. Oracle Cursor Creation in Reporting Services
  147. Tns name Not Found
  148. Wf_routing_rules
  149. Update Query with a JOIN
  150. Discoverer Automatic Refresh ?
  151. How to load CLOB using sqlloader
  152. How to disable trigger as soon as it got triggered.
  153. Delegation of Responsibility
  154. Insert Statement Within A Case Statement
  155. SQL Loader
  156. OCILogon Fails But OCIError Returns False.
  157. delete and truncate
  158. Problem to use FOR loop to fetch record from a ref cursor
  159. Discoverer Parameter
  160. Implementing Manager Self Service
  161. Problem with the varray...
  162. Error message comming during import the file in oracle.
  163. Access Denied to create view in disoverer
  164. Slow return in Oracle stored procedure
  165. Oracle 9i installation failed
  166. Passing large value to Oracle stored procedure
  167. Getting a MAX() with an upper boundary
  168. Idenfying LOGS in Oracle - Please Reply
  169. Offline Database management
  170. Perl Database SQL query variable passing
  171. How to avoid DeadLock ORA-04020 error (on views)
  172. can u tell me this sql querry
  173. host string
  174. Apps Scripts
  175. Oracle apps Fast formula error
  176. Looking for Trados Multiterm's Glossary
  177. How to implement log file concept in oracle
  178. Discoverer Error
  179. Application that I can paste a query into & extract column/table names
  180. how to join 2 tables
  181. How to export/import the excel file in oracle database using sql promt
  182. Work Flow installation
  183. Loading images into Oracle
  184. Parameterized query for schema name?
  185. Problem with REFCURSOR
  186. Multiple INTO in stored procedure
  187. slipt a string into 2 word in Oracle PL?SQL
  188. How will data of schema will reflect in another schema of same network
  189. How Fast is ULT_SMTP
  190. Installing PHP Oracle Extension on SUSE linux
  191. Date Between Problem
  192. Cursor that is supposed to return one value Returns duplicated values of same row
  193. How to search all columns of all tables in a database for a keyword?
  194. max(orderdate)not working in subquery
  195. seed data base
  196. free ebooks
  197. fetched results not separating
  198. view constraints on table
  199. Return first occurance of record
  200. VB Oracle Connection Data Retrieval
  201. How to implement LIKE Clause in Query?
  202. Sqlplus ora-12154
  203. Long datatype
  204. group by works, order by gives error msg
  205. 'java.sql.SQLException: ORA-01401: inserted value to large for column' in Oracle 9i
  206. top-n queries
  207. oracle and c++
  208. help with "execute immediate" in oracle
  209. Help!!!
  210. For sql and pl/sql
  211. How do you call an external script using DBI
  212. Numeric field in desired format.
  213. UTL_SMTP PAckage problem
  214. How do you spool to txt file?
  215. what is "(+)" in pl/sql
  216. Need help writing sql to check for records that invalidate a foreign key
  217. Nested Sum in Multiple groups
  218. some tips to become an Oracle Proffessional
  219. how to update few records thru join
  220. Does an "IF Exists" clause exist in Oracle?
  221. Is Oracle dead or is everyone talking somewhere else? [eom]
  222. Microsoft .NET vs Open Source (vs Oracle) - when to use each of them ?
  223. To find no of records in a particular time span
  224. pasted sqlplus script no longer running
  225. Counting Parent Child Level
  226. subquery
  227. Oracle question.
  228. I want a query to find all entries on table1 without a corresponding entry on table2
  229. how i select columns names from any table
  230. Linking of Schemas
  231. Set Nocount On/OFF equivalent in Oracle
  232. from informix Database to Oracle
  233. ERROR [STDERR] java.sql.SQLException: Data size bigger than max size forthis type: 40
  234. how can run PL/SQL from oracle FORMS trigger or procedure/funcktion.
  235. Sql
  236. Sql
  237. run executable program from oracle trigger ( or procedure)
  238. Database Administrator question
  239. select query
  240. query slow intesting
  241. Oracle Discoverer Query
  242. Load balancer not working properly Oracle Rac environment 10g
  243. Tables not seen
  244. Oracle Query
  245. PLSQL related query
  246. sqlplus copy
  247. CSV file enclosed by "
  248. Column Settings
  249. How to get the report name before running ?
  250. Query to fetch name with mixed case
  251. database path in oracle8i
  252. Simple update Table query based on 2 tables joined
  253. Oracle - Input Buffer
  254. Error in report
  255. Different answer sql*plus and oracle forms
  256. doubt in query
  257. Error invoking target install of makefile - installing Oracle 9.2.0.1.0 on AIX 5.3
  258. Creating a new Database and New Schema
  259. External Table with only one column
  260. sql command error
  261. Oracle Vs Teradata
  262. exporting data from oracle to excel
  263. Deleting large amounts of data
  264. how to change the column name to an already existing table
  265. rows of consecutive dates if the value is same everyday
  266. Oracle 10 g Client with perl Help
  267. Uploading JPEG images to Oracle
  268. Group consecutive records
  269. How to access new value Statement Level Trigger
  270. Why Rollback?
  271. Decoding a date & time format
  272. Setting Tab Accessibility
  273. Help with creating a SQL Query
  274. Cursor update
  275. How to delete constant no. of records
  276. Inserting XML into Oracle Table
  277. oracle batch file
  278. hours,minutes,seconds not showing in the database
  279. Simple Update Query using select statement....but why isn't it working??
  280. Oracle crashes on ESX server
  281. selecting tables
  282. how can i get time only in date data type
  283. Archive Logs
  284. Pl/sql
  285. What is a Mutating Trigger and How To OverCome To It
  286. How to find the total number of records updated in a table when a procedure is run.
  287. concatination of data in a column into a single row
  288. like operator for digits
  289. Multiple Join Query
  290. DBMS Jobs V's user scheduler Job
  291. how i can select the latest order for a customer in oracle forms
  292. site map
  293. changing line in display
  294. how to loop in oracle forms
  295. 'Not Connected Message'
  296. Storing image in table.
  297. Sql/oracle format
  298. How to put IF conditions on COLUMN NAMES...
  299. Dynamic Sql
  300. Data Being Populated
  301. Retrieving org id through unix shell
  302. Discoverer Apps Registration
  303. reading text using client_text_io utility
  304. Search for tablename and column name for one value across 1 database
  305. oracle functions
  306. Auto Increment
  307. concatenation of rows
  308. oracle versions
  309. difference
  310. New Member
  311. Procedure - Dates Between
  312. Oracle 10g on Windows Server 2003 (32-bit)
  313. performance issue on report
  314. Subtraction of dates
  315. Oracle Forms Migration 2.4 to 10g
  316. how to change the initialization parameters in oracle 10g
  317. Need to download Oracle 7.3
  318. Oracle Connection String
  319. group by total breaks in sqlplus
  320. Executing API with a Select?
  321. need output without using dbms_output package
  322. Any oracle formatter or beautifier?
  323. sample projects
  324. reg Oracle reports builder
  325. Performance bottleneck in bulk updates/inserts
  326. Where clause problem
  327. how to find the seventh largest number in a column
  328. oracle 10g installation
  329. Delete Duplicate rows without using ROWID
  330. purging data in mviews not in mview logs
  331. Package used in the oracle form
  332. How to find who is eldest from date of birth
  333. how to count no of times a letter occurs in oracle
  334. oracle
  335. Reg Oracle reports builder passing parameters
  336. Er Model
  337. spool old and new values in SQL
  338. Mviews
  339. what does count(1) do?
  340. Oracle query.
  341. reg oracle reports builder bar graph
  342. Comparison of character and number
  343. Stored procedure
  344. Problems with outer joint
  345. Will I able to get a job in software testing industry
  346. Listener/tnsnames.ora issue ORA-12514
  347. PSB ORA error DE_id and Position_id
  348. Reg Database
  349. Total Number of Employees hired in a certain year
  350. What is bitmap and
  351. SQL Plus
  352. Sql%rowcount
  353. calculate business days in a year(excluding holidays and weekends)
  354. Update
  355. creating materlized view in another schema using dblinks
  356. Semi Join with 3 tables
  357. Reg AFTER INSERT
  358. Book or online documentation?
  359. How to sort columns and rows in oracle
  360. number of records
  361. how to sort days in oracle
  362. Schema Files
  363. How to check an jdbc version in classes12.jar ??
  364. ORA-00604 when connect to database
  365. Oracle error: ORA-01401:inserted value too large for column
  366. Deleting large number of tuples from Oracle 10g Db.
  367. PSQUery with conditional rows
  368. on_commit trigger
  369. discoverer installation
  370. using visual source safe for oracle 10 g database
  371. Oracle vs MySQL vs DB2 please help decide
  372. Oracle Internal Error Code(Oracle Version:10.2)
  373. System freezes
  374. spilit one column into two columns
  375. Migration from DB2 database to Oracle 10g.
  376. Converting a DATE with time stamp to a DATE without timestamp
  377. Delete Duplicate Records from a large table
  378. Please help to achieve this output
  379. open form with parameters
  380. Linking MS Access to Oracle
  381. Can I select from a dual table ?
  382. What is B-Tree is index ?
  383. what are the variables used in sql & pl/sql ?
  384. Query to get the output horizontally?
  385. dba exams
  386. updating using SubQuery Problen
  387. Problem in Materialized view
  388. mutating
  389. Error (C++ does not support `long long' ) while compiling ORATYPES.H
  390. problem to disable a perticular item in oracle forms
  391. open form with parameters
  392. Hanging of select statements/Forms & Procedures
  393. fmcus.msb
  394. Archiving the data
  395. SQL : nth highest salary from emp table
  396. 10 g Installation problem
  397. Normalization
  398. connection string
  399. Copy schema without data
  400. Copy schema without data
  401. Selecting Max Daterecord from Many Records
  402. Sshr-ame
  403. oracle10g production license
  404. important sites
  405. Adding primary constraint on a table if you have duplicated records already .
  406. Running two applications at the same time , having common components
  407. Maximum number of Columns
  408. SWITCH error
  409. DeCode in Column List
  410. Siebel Calendar Issue.
  411. Oracle Installation
  412. where to use ref cursor ?
  413. knowing jusT the lasT row
  414. how to do a realtimeproject
  415. how to connect 9i to 10g forms
  416. Display a field in margin of Oracle Report only on page 1
  417. Hi friends........
  418. simple SQL ELSE IF statement help
  419. insert into primary froeigon key relationship
  420. Connection String for Remote Server
  421. reg hyperlink in oracle report built by oracle reports builder
  422. Sql Plus Utility
  423. Parameter in Discoverer
  424. How to specify person type in table creation
  425. how to create a txt file from PL/SQL procedure
  426. using a join and field concatenation
  427. Exporting whole database from oracle 9.0 to 9.2 (windows)
  428. network adapter
  429. connect database
  430. Update statment with Exists and inner join, need tuning or alternative
  431. TNS Writter Failure
  432. How to increment more than one or to some othe rnumber with Oracle for loop
  433. Export Database tables to a dump file under windows
  434. Use variables in several different places in a big SELECT query
  435. long sql query
  436. Comma seperated column
  437. To check space in varchar2 column
  438. Pro*C vs Oracle Java Stored Procedure
  439. Query Tuning for a single select statement
  440. Restore the database backup in Oracle9i
  441. how to update columns in oracle forms
  442. Improper result from query
  443. Loading Multiple CSV Files into Oracle DB
  444. FRM -41039: Invalid alert ID 0
  445. error 00214
  446. oracle error
  447. oracle 9i reports
  448. how to declare a global variable in report builder?
  449. Call Javacode from Pl/SQL
  450. case when gone wrong
  451. Workflow
  452. how to change search conditions dynamically in where clause using pl/sql
  453. SELECT WHERE SettingKey = N'Logon' FAILS
  454. insert into a table with selected columns.
  455. Oracle does not exist and shared memory realm does not exist error
  456. VBA Oracle DB Connection String
  457. can anyone pls help me to join tis 2 query statement
  458. How to add a sum up column to a table
  459. ORA-27101 problem
  460. Loading Excel File into Oracle Table
  461. How to drop and then create a table during runtime in oracle9i
  462. Nested Cursor
  463. Sequence.nextval incrementing itself over time
  464. Not able to open test.fmx in oracle application server 10gR2
  465. oracle report 6i
  466. Bulk Import of Data into an Oracle Database
  467. Loading XML data to Oracle Database
  468. Joining of 2 SQL queries
  469. how to compare two columns and return the value which is not matched
  470. Mutation of triggers
  471. Traversing a tree - using a little recursion in SQL
  472. how to get colunms displacement for a table in Oracle?
  473. i'm trying to load data from uploaded file in php by using sql loader
  474. error questions
  475. How to connect oracle 9i database & developer suite ?
  476. how to use a list item in oracle forums
  477. rowid
  478. how to enter only time in the field of table and sum the time
  479. Query
  480. Equivalent to SQL Server Integration Services
  481. Drop by to ask for help
  482. how to execute query without having to declare schema all the time
  483. File Dis51usr.ini Of Oracle Discoverer 10g
  484. i'm having trouble in defining primary key... HELP ME guySSSS
  485. Arbitrary order in SQL query
  486. load data
  487. oracle sql
  488. How i can use "IN CLUASE" with block fields.
  489. Add Field To parameter form
  490. Best practice for inserting many to many records
  491. dynamic :NEW
  492. How to recreate Foreign Key constraint
  493. Multiple Counts in 1 query
  494. RecordSet inside procedure
  495. What is a dblink ?
  496. orace 6.0 designer
  497. like %
  498. Connection pooling
  499. import .lst files
  500. I got a error when i am establish the connection between oracle and sql server
  501. SQL Select statement as a keyword search
  502. Iterative function in sql
  503. Table Output
  504. Oracle XML and XPath
  505. REFCURSORS over dblinks
  506. oracle error 10034
  507. Sql
  508. Oracle reports 6i and asp.net
  509. Report 10g Vs Discoveror
  510. Query Takes time to execute
  511. Generate DDL of Schema
  512. Easy question from MS SQL to ORACLE
  513. Integration of two databases into one Database
  514. Maximum size of Linesize
  515. grant access to remote user
  516. Recover deleted rows from a table from archive logs?
  517. Error in writing to directory /tmp/Orainstall .....
  518. Finding all tables with a particular field?
  519. Views and performance
  520. Installing on Mac Os
  521. How to diagnose inaproppriate Oracle SGA component size?
  522. server configuration
  523. RAC nodes regularly freezes for about 10 seconds
  524. How 2 split priority, reports low, transactions fast
  525. 7.3 on 03 server
  526. SELECT ... WHERE column LIKE parameter||'%'
  527. Re: Installing Oracle 11.5.8 on Mandrake
  528. ENOVIA/ MULTIPLE OPENINGS/ NO RELO REQUIRED
  529. history
  530. Oracle CBT
  531. Which database design tool
  532. Oracle Schema
  533. SQL 3 or 4 trial key needed
  534. UNIQUE CONSTRAINT ERROR
  535. Basic Questions
  536. Catching "ORU-10027: buffer overflow" exceptions in PL/SQL
  537. OLEDB and Oracle XE ?
  538. Patience for a Oracle Noobie
  539. Slow query on date field via views
  540. Crystal report db problem
  541. current sql running
  542. .NET Reporting against and Orcale Database
  543. <REQ> oracle lite info
  544. S: Biomega Mark Newson MN03
  545. Obtaining a Column Which has MAX in Another
  546. writing records while doing select.
  547. Multi Master Databases
  548. spool file: saing to non default location
  549. Mercury ITG developer wanted (nashville, tn)
  550. Request for Resume's - Siebel Production Engineer IV