View Full Version : oracle answers


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

  1. SQL command not properly ended?
  2. Query Help
  3. Oracle 9i driver
  4. OrderBy question
  5. Oracle Reports
  6. Report not running in web layout
  7. flush shared pool
  8. Adding minutes to a date field
  9. The same signature of Stored procedure
  10. Failed to load the following object in oracle forms
  11. urgent help needed regarding arrays insertion
  12. Displaying specific data from the database
  13. Spooling more than one file
  14. count(*)
  15. no data found error in an "execute immediate" statement
  16. Creating Customer Address
  17. inser the row
  18. Concat used by optimizer in where clause
  19. Date conversion problem
  20. sql query tuning
  21. LIKE Operator
  22. It's urgent (Oracle running slow)
  23. PLS-00201 error from PHP
  24. Calling a Stored Procedure via a trigger
  25. Lookups
  26. report error
  27. PL/SQL:PLS-00410 duplicate fields in RECORDTABLE or argument list are not permitted
  28. Cannot avoid duplicate results
  29. size of image file..
  30. Update and Insert trigger definition
  31. Amend and udate data using 10G EM ?
  32. hi amit..newbie oracle help me please!!
  33. In correct date format
  34. ORA-00907-passing blank space inside a parenthisis pair
  35. Tracing users by after logon trigger
  36. Urgent Help Needed
  37. PL/SQL Trigger Restrictions
  38. autonomous trans with EXCEPTION fails - why?
  39. need to know about oracle
  40. Use Duration and booking date to stop bookings during this time
  41. procedure
  42. merge
  43. current user
  44. import a .dmp file
  45. Function..help!
  46. need some docs regarding Sql tunning
  47. How do i Optimize this Query
  48. inserting unixtime in database
  49. Counting Commented lines in code
  50. Listener error
  51. Creating A Text File
  52. How to restore the path variable to get OracleDevSuite working?
  53. How to Connect Forms using VPN / DSL
  54. help! i need a solution pleas..cn i use subquery..
  55. Ora-01092 Errror
  56. Need help on using analytical function
  57. Deduplication in 11g works only in alter/modify?
  58. To update a record using rowid in duplicate row.
  59. correlated subquery in oracle
  60. Problem in wirting data in Excel sheet using owa_util package
  61. Stored Procedure Coding Problem
  62. Rewrite query using bulk collect to improve performance
  63. how to write a query to make its execution time better .And the standards.
  64. latest row inserted
  65. how to see all the inserted rows of a particular date
  66. function
  67. Use Serial Port In Oracle
  68. Problem with inserting dates
  69. Access violation at address 00000364. Read of address 00000364
  70. trigger types
  71. Composite primary key
  72. Table type parameter to a procedure
  73. hetrogenious database connectivity error from oracle to sql server
  74. pl/sql coding problem
  75. Calling a Package
  76. resolve this sql query urgent
  77. hi for all
  78. RMAN Duplicate
  79. which oracle version and forms can install on xp2
  80. Copy all values of a column from one table to another
  81. Isnull Problem
  82. Connecting Oracle Forms and DB using VPN connection
  83. Current Opening Balance from the table AR_PAYMENT_SCHEDULES
  84. sql temt table error
  85. Updating a column based on value in another table
  86. Query to find all transactions for a particular user
  87. database is giving data block corruption
  88. Reliability & Efficiency of Database links for far located remote databases
  89. OWS-05101: Execution failed due to Oracle error -6564
  90. Basic oracle quries
  91. Select query for Ageing Report 30,60,90 days
  92. Data limit of Oracle for DataWarehouse application
  93. what is this exactly FND_CLIENT_INFO
  94. problem regarding retrieving image from database
  95. Dynamic sql generation using oracle 10g stored procedures
  96. select query is taking some time to return values
  97. Procedure Return two values
  98. My Stored proc is not able to fetch output in crystal reports
  99. Issue in invoking procedure
  100. B* tree
  101. Use a specific database & find it's tables.
  102. REG PO- INTERFACE in apps
  103. PL/SQL Trying to update a table through trigger on the same table
  104. change in sysdate
  105. how to run this coding
  106. converting Date to Date or Char
  107. Dependent CASE function of another CASE function in a SELECT statement
  108. Trapping system exceptions
  109. how to manipulate indexes?
  110. Oracle 10g r2 setup required
  111. ORA-00922 Missing or Invalid Option
  112. Inserting a record for every value from a query
  113. PL/SQL to Dynamic Method 2 conversion of 3 files (Convert.zip) Pro*COBOL Oracle 10g
  114. Loading unloading data oracle 10g tables
  115. Sizing Of Table
  116. join
  117. REG Conversions
  118. Dynamic Report parameter
  119. Unknown Query Engine error
  120. Oracle Dba
  121. Creating a TAPI Dial button in Oracle
  122. help optimizing transpose query
  123. problem with mutiple row insert in a table using pl/sql
  124. Proecdure/Function with conditional inputs
  125. how to insert data into tables from flat files.
  126. Looping over broken range
  127. Writing data to file using UTL_FILE package
  128. comparing string values
  129. Newbie Question about dynamic table name references
  130. Bulk Data insert excluding the duplicates
  131. Oracle 10g error
  132. Query required to display a row from table
  133. How to update column with data from other tables?
  134. Indexes not being used when using bind variables
  135. importing .dmp oracle 9i file in the database using Forms Developer
  136. basic doubt
  137. I need help below this Query Urgent Please help me..
  138. DBMS.OUTPUT Group Functions from a Cursor?
  139. project consultation
  140. oracle
  141. oracle jsp connectivity
  142. Oracle Report In Word ?
  143. replication: fails to replicate automatically have to manually refresh
  144. ORA:00933 sql command not properly ended
  145. ODBC to Oracle Question
  146. Create a flat file from a repeating table
  147. oracle payables
  148. account payables
  149. oracle financials
  150. Query to return single record from multiple like records
  151. Setting up Oracle ODBC Link
  152. Help
  153. non-duplicate data from 2 seperate tables help
  154. query
  155. in report formula trigger how we use the nvl function with date
  156. time conversion
  157. pro*c information
  158. how to connect vb and orcle database
  159. ASP.NET and Oracle
  160. Running asynchronous processes in Oracle
  161. Urgent Help Needed!
  162. problem with string concatenation in auto-incremented field
  163. Create database error.
  164. ORA-01843: not a valid month
  165. using clob
  166. Help with Complex Query
  167. Mutuation Trigger
  168. Can't Edit inithsodbc.ora in Notepad
  169. Stored procedure input...
  170. bulk collect and for all..........
  171. Creating trigger
  172. Why people recommend oracle rather access?
  173. Oracle Update Statement using Concatenate
  174. Oracle 10g and ASP under Encryption mode
  175. SQL query not using index and explain plan gives very high cost
  176. Difference in Time in SQL
  177. Report Error
  178. Data Import
  179. IN condition and variable
  180. specifying storage parameters
  181. How to transfer data from oracle dump file to Excel Sheet
  182. ORA-02068: severe error from ORAMVS
  183. a doubt in sql please help me
  184. port in linux
  185. problem regarding database and jsp
  186. Number of Weekends in a month
  187. Query to get number of saturdays in any month
  188. retieve the data
  189. Execution plan
  190. Regarding Forms Parameters
  191. CSV to Oracle table
  192. Oracle reports 6i blank lines in output
  193. [C#] Import data from one server to another
  194. Stroing xls in oracle
  195. Range by Partition
  196. DBlink to DBLink
  197. reg apps
  198. How to handle "select a,b where c=' 1 & 2' in a 'hard coded' odbc query
  199. SQL command not properly ended?
  200. Help Needed
  201. selecting records with "%"
  202. ORA-03113: end-of-file on communication channel
  203. Trigger with insert
  204. ORA-12560: TNS:protocol adapter error
  205. Query to Get Primary and Foreing Key.
  206. Query to get Primary and Foreing Key
  207. How to extract data from oracle using C??
  208. how to specify package body in toad
  209. SQL Query with Self Join
  210. Isnull Problem
  211. How to remove primary key from table ?
  212. Result set is forward array.but iwant reverse array
  213. Oracle Application Server
  214. Select a random time
  215. Logical and physical Structure
  216. Microsot Linked Server & Oracle10 Performance Issues
  217. Database Instance
  218. How to retrive value for 12 hours
  219. PLS-00306 .Getting Problems with OUT parameter
  220. Explanation needed
  221. Query in teradata taking long time
  222. materializd view
  223. How to retrinve the first top salary hoder
  224. script by last analyzed database
  225. Sub : Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g.
  226. Frm-10095
  227. Selecting the Same Coloumn Twice
  228. how can select
  229. Using Oracle 10g with Oracle 8 drivers
  230. Difference
  231. Show in one line
  232. I Want Know How I Can Attach Bar Code Device With Oracle Form Bulider Using Developer
  233. Tuning SQL statements
  234. how to use join query
  235. How to insert an image into DataBase? and also retrieving
  236. Change Number
  237. Space constant
  238. send report by email
  239. Help with Trigger Updating same row?
  240. Problem with INT when creating a table.
  241. how to create running clock in oracle forms 6i
  242. Get weired table row reflections. How do I get rid of it?
  243. How to retrive odd number of rows in my table
  244. I want to learn Oracle
  245. Modification of the length of a field in a database
  246. oracle upgradation
  247. selecting duplicate record with one different field
  248. How to get business days between two dates?
  249. how to create control files
  250. let i am using varray in procedure .then how to call it.
  251. oracle reports
  252. Getting the table name which is using a sequence
  253. exceptional handling
  254. procedure????????
  255. how to display the retrieved data from database in a dropdown menu
  256. convert number to float
  257. Stored Procedure processing
  258. GUI tool for Oracle
  259. Connection Problem Oracle7.3 to Oracle8i
  260. convert from 0 to 1
  261. Illegal datatype equivalencing operation using Pro C compiler
  262. problem in writing a Query
  263. Need Help for the error "SQL command not properly ended"
  264. Top 10 salaries
  265. How to add $ sign to number data type?
  266. how do you display the name of a SQLPLUS script that is running
  267. connection with .net
  268. Import
  269. Credentially retrieval failed
  270. is it possible
  271. ORA-12500: error
  272. ORACLE FORMS 9i WITH MDI
  273. collection as out prameter
  274. help with pl/sql
  275. i am not getting correct return values :cp_4,plz help me
  276. data transfer
  277. connecting to oracle
  278. finding Difference in pl/sql
  279. upload text file to a database
  280. Plzzz help regarding this......
  281. SQLPlus SELECT Headers
  282. problem installing WITH ORACLE
  283. Read-only DBLink !
  284. Python and calling Oracle Procedures
  285. cursor error1
  286. ORA-00933:SQL command not properly ended
  287. SQL Math Function Help
  288. Heterogeneous Database connections - Oracle to SQL Server
  289. connect Oracle9i on Unix to MS Sql Server
  290. Updating Multile rows in a table
  291. Getting wrong error message when running a command
  292. Clarify Me
  293. error while creating database
  294. A trigger to output to a text file
  295. Concat variable to form Table name inside Select statement
  296. need explainantion about sql quries..
  297. Ora-01795
  298. recently inserted rows
  299. Looking for DBA who knows DATABASE XML
  300. Need help to start learning oracle
  301. ORA-07445: exception encountered: core dump
  302. Pipe delimitating function
  303. configuration for *isql
  304. calling Java from Oracle
  305. Oracle DBA
  306. Utl file
  307. Difference between PL/SQL table and Record Type
  308. problem installation
  309. can't install Oracle 8i Client
  310. Insert email into Oracle
  311. FRM-92100 on refresh data in a screen
  312. How to understand this query??
  313. How VB script will retrive the data from Oracle Database
  314. Getting Invalid user ID and Password before the applications starts
  315. Oracle Translation Hub - Using the Trados Glossary
  316. update two columns at time
  317. How to call oracle tables from MSDOS?
  318. How to move backwards
  319. oracle download
  320. otn for oracle 9i...
  321. server problem
  322. PS/SQL script needed to update and prompt user to commit or rollback
  323. Insert into a table with sequence and a value from other table
  324. help with dates
  325. Count of table column
  326. Finding the database culture
  327. Needed DB Query optomized?
  328. How can I use variable value as a table name?
  329. performance tuning in 10g
  330. Random Number Based on another Cell in Row
  331. import to oracle 9i
  332. Reference a package in a script
  333. schema designing
  334. finding a day that had maximum total amount..using sql
  335. regarding dynamic SQL
  336. regarding sql query
  337. reg Oracle Apps
  338. I want formatted output
  339. problem in importing a .dmp file
  340. Storing images in Oracle
  341. REG Layout In Report
  342. help with Perl code to insert a long string (> 32512 chars) via stored procedure
  343. Augmenting a table sorted grouped by month to one grouped by day
  344. reg Reports
  345. Desing and Implement a Data warehouse in Oracle
  346. Frm-10095
  347. Query
  348. ORACLE 9i DATABASE
  349. Anyone has Oracle 7.3 client for Window XP
  350. Currency field with 2 decimal
  351. Pl/sql
  352. Triggers
  353. distinct BEHAVIOR
  354. problem with UTIL_FILE
  355. null data from bind variable on table insert
  356. ecryption of user-id/password to pass to sql loader
  357. how to insert data into different views through oracle forms
  358. Oracle possible to share schema between users
  359. Migrating From Access to Oracle
  360. Storing scanned documents in 10g
  361. how to view schedular by using oracle enterprise manager in 9i
  362. Performing fast search in huge oracle database
  363. Between operator
  364. instalation of dev 6i and oracle 9i: database connection problem
  365. Pl/sql
  366. Pl/sql
  367. Oracle Apps
  368. plz solve my query i have my exam on monday.
  369. First Function In Plsql
  370. oracle auto incerement
  371. Multiple rows insertion in single insert query.
  372. not null constraint
  373. How To See The Procedure Script In Sql Plus
  374. trigger error
  375. Unique Constraint Violation
  376. How to pass a variable from one form to another in Form 6i
  377. How to copy data from one table to another table with where condition
  378. one server with two different database
  379. ORA-01578: ORACLE data block corrupted
  380. Query Performance
  381. deletion issue
  382. Oracle Connect Error - Please Help - Urgent...
  383. Executing multiple scripts using UNIX command
  384. executing Process-flows manually from SQLPLUS
  385. Converting Rows into Columns without affecting the data in the table.
  386. disable system given name constraint
  387. Oracle is installed or not.... Urgent
  388. execute immediate problum
  389. plz solve this query as soon as possible
  390. Execution details in email notification
  391. Major differences between oracle 9iand 10g.
  392. Decimal data creation Number datatype
  393. ORA-29902 - ODCIndexstart() error for the word "about"
  394. how to use decode?case function in where clause
  395. Plz solve this query
  396. Partition Creation Automation -- Best Methods
  397. ' not in ' function syntax.
  398. Oracle Error -either eof or bof is true-connecting with vb thru adoddb
  399. Please solve this query
  400. Convert MSSQL syntax to Oracle - variable declaration
  401. Basic Oracle Connection Question
  402. views & indexs
  403. data base error
  404. analytical functions
  405. Missing right parenthesis
  406. fetchin limited number of records from resultset
  407. Ref Curser
  408. how to handle data beneath the tabular report in rep 6.0 when rep expand vertically
  409. Need to modify stored proc for crystal report. Important.
  410. Showing Database in Oracle
  411. indexing
  412. external table into Oracle8i
  413. Primary Key Constraint
  414. Jft
  415. bind variable
  416. query problum
  417. address query
  418. how to get the last row inserted into a table.
  419. INSTEAD OF trigger (FOR EACH ROW)
  420. bad bind variable trigger
  421. ALL and ANY
  422. Migrate oracle 8.0.6 hp ux database on oracle 9i linux
  423. inserting into table - object view
  424. how retrive table values from two oracle databases
  425. Connecting to oracle DB through UNIX
  426. Want to call oracle statement in client connection
  427. Please provide me a SQL script for the problem described below:
  428. IMP-00028: partial import of previous table rolled back
  429. How to retrive my data...
  430. oracle
  431. Oracle 9i Startup and Shutdown
  432. Adding parameters to a filter for a report
  433. oracle form
  434. Oracle(tm)client and networking components were not found
  435. Having a problem with the TO_DATE function in Oracle.
  436. inner join outer join query
  437. Create a new instance wif of a database
  438. Query Tuning...
  439. Creating Discoverer ELU's
  440. question
  441. Access to Oracle 9i
  442. Test script to test functions in a package
  443. varchar to_num catching exception as zero
  444. Need to know what are all the alerts enabled in my database.
  445. Working out 6 month prior to the first day of the month
  446. Data migration from SQL Server to Oracle + Identity Column
  447. oracle
  448. stored procedures out parameter
  449. Materialize View
  450. error PLS-00201:
  451. count
  452. Materialized Views in Oracle
  453. Join the result of two different queries
  454. Join the resul of two different queries
  455. Function contained in an Oracle Package
  456. Oracle 8i does not supports Common features
  457. ODBC vs Oracle PreCompiler
  458. Cerating Table In Procedure
  459. Help with COUNT Query :)
  460. Real time Data warehousing- Example
  461. 3 queries into 1
  462. query to convert column into rows in oracle9i
  463. Loop problem, Cursor could not read the next record
  464. problem with Spool ..
  465. How to Create a Table Name from a value in an Existing Table?
  466. Oracle Error-TNS no Listner in TOAD
  467. Multiple Pages
  468. Regarding Forms in D2k..
  469. Tally 7.2 with Oracle Databse
  470. need to compile a file
  471. oracle stored procedure
  472. Problem trying to write a PL/SQL routine that will generate a CREATE TABLE statement
  473. Equivalent of MS Access Sql (first or last function) in oracle9i
  474. SQL...duplicate data identification
  475. TNS Protocol Adapter Error
  476. Oracle 10 g Installation Problem
  477. Opening a Web Page Inside a 10g Form
  478. How to Insert the Special Copyright Character in an Oracle Table
  479. problem in Order By
  480. How to continue processing if an error occur into plsql block
  481. SQL PRoblem with GROUP BY
  482. Oracle 9i forms developer
  483. integrity constraints problem
  484. what are wild cards incase of sql
  485. frm-92100:your connection to the server was interrupted.
  486. no output for to_date function
  487. ORA-06502: PL/SQL: numeric or value error
  488. copy data from fielld_1 (long ) to field_2(varchar
  489. Where V1 In (select Fun(1)
  490. Working of ROWNUM in Oracle
  491. Help -- Oracle Forms does not support multi-page TIFF.
  492. reg temp table
  493. Most preferred database
  494. Oracle database
  495. execute query for every month of beginning
  496. Adding a barcode field
  497. Aggregate query problem
  498. ORA-29740 in a RAC databases
  499. DBA in Linux and Windows
  500. Sub-Query returns more than one row
  501. nested tables
  502. SQL Case statement
  503. Cursor Error
  504. Why Oracle Counting is so slow?
  505. To change number format from floating point format
  506. connection between windows CE and oracle
  507. Connectivity
  508. Updating and Deleting data with one statement
  509. Oracle 8i and Developer 2000 on Win XP
  510. example of procedures.
  511. Sqlloder
  512. Fetching max in "Page 1 of max" in minimum Time
  513. forall operator
  514. My statment takes too long to run.
  515. reg apps
  516. how to combine multiple sql query into one
  517. Querying data between two datetimes from previous day
  518. isqlplus service randomly goes down
  519. DSN ERROR: ORA -1857 not a valid time zone
  520. utl_file
  521. Bulk copy in Oracle
  522. connecting developer 2000 to existing database
  523. spool data
  524. Oracle Reprots
  525. Please give your scripts
  526. Inserting Clobs In Java
  527. REPORTS 6i
  528. Oracle with window registry
  529. Recursion in PL/SQL
  530. exe plan
  531. C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time
  532. creating physical standby database
  533. message only
  534. specific user login
  535. there is a problem with oracle connectivity
  536. Assertion in SQL
  537. oracle
  538. Return ref cursor from oracle procedure
  539. Equivalent of Oracle's "TYPE" in PHP or PostgreSQL.
  540. exchange partition across databases
  541. Oracle database connectionstring problem
  542. reports 6i
  543. Difference between %type and %rowid
  544. Edit Record in DataBase Control Oracle 10g
  545. import .dmp file into oracle
  546. Storing the bill into tables
  547. Storing text fields with imbedded punctuation
  548. [07/11] Ora-7445 [kssadf_stage:1003[kss.c]] From Create Table As Select ...
  549. Creating global temporary table on join condition
  550. Queries in Oracle & SQl server.