View Full Version : oracle answers


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

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