View Full Version : answers

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