View Full Version : oracle answers


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

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