View Full Version : oracle answers


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

  1. Creating global temporary table on join condition
  2. Queries in Oracle & SQl server.
  3. Auto load SQL on HTML
  4. Able to connect to oracle even with the old expired password
  5. What is @@ means
  6. must a foreign key be a primary key
  7. reg oracle reports
  8. cursor for loop returns o/p as cursor
  9. Lpad and Rpad?
  10. Rollback segment is full
  11. FRM-40922 An Ole error encountered:0x80040154
  12. Virtual Private Database
  13. Retrieve the table names and column names in perticuler schema
  14. problem in join statement
  15. oracle apps
  16. Help in oracle procedure
  17. MSSQL to Oracle Migration Performance issues
  18. Backup in Oracle10g
  19. Stored Procedures - Help
  20. Oracle 11g New Features
  21. trigger
  22. Facing problem in Oracle Report
  23. Inserting 8 lakh records using sqlloader
  24. Please let me know the query for this!
  25. Provide table name dynamically in query
  26. Identity Type in Oracle 10g
  27. SQLPlus substitute?
  28. Good Oracle tutorials - free
  29. How to store and retrieve an image in oracle using java
  30. difference between oracle 9i and 10g
  31. Copying Columns Between Tables
  32. Oracle Problems
  33. UTL_FILE inalid directory path
  34. For Oracle Sql plus
  35. how to tread the primary key and foreign key in fragmentation
  36. Creating Views on base of cursors in Oracle pl/sql
  37. Difference
  38. Bulk copy to text file in Oracle
  39. Rtrim cannot trim certain character
  40. Materialized views log are not getting purged after the completion of related fast re
  41. Oracle basic commands
  42. How can I include Xerces C++ 2.7.0 parser code to Oracle 10g R2 Pro*C's .pc
  43. Converting ip address in decimal to dot notation
  44. oracle connection string in vb.net 2003
  45. Simple Join Statement Help
  46. Urgent - 2147467259: [Microsoft] [ODBC driver for Oracle] [Oracle]
  47. Install Oracle 8i on Vista - Processor :Intel Core2 Duo
  48. Duplicate data
  49. Form Builder Error -ORA - 12154 TNS could not resolve service name.
  50. How to read Harddisk number
  51. Oracle Query - column group
  52. SQL query...decimals
  53. Oracle Error - ORA-04021
  54. spooling data to csv file
  55. init.ora file location.
  56. Difficult in database link
  57. Question on hotbackup for oracle
  58. Error using form designer (Developer 2000)
  59. Urgent : Help to convert string to date
  60. Create another instance from cold backup
  61. Viewing available databases with password and username
  62. Export and purge table
  63. stored procedure in oracle9i
  64. Executing a function declared in Oracle Package from Unix shell script:-
  65. Numbers and Nulls
  66. Count multiple items from the same column
  67. Materialized View in Oracle apps
  68. sql date format problem
  69. Help Needed in formatting output data !!
  70. reg data transfer
  71. stored procedures
  72. How to give privileges of one user to another
  73. schedular prob
  74. Oracle XMLTYPE datatype
  75. TAB delimited data and SQL*LOADER
  76. how to start a distributed database
  77. Cannot able to connect the oracle database
  78. Database Listener Problem
  79. Dblink
  80. Difference Between Oracle 9i And Oracle 10g
  81. Database link
  82. blockig error
  83. Why we used ROWNUM in group by clause
  84. Which one is used to better performance
  85. Export Oracle table data to text file !!
  86. Ora-00907...
  87. Oracle Developer Suite 10.1.2.0.2 installation on Fedora 5
  88. difference between installing oracle 10g R2 software on linux & solaris
  89. Connecting to the DB >> Assertion failed:
  90. backup of one table's data before deleteing its all data
  91. Error occured while saving connectiodefinition
  92. Error occured while saving connectiodefinition
  93. calling a stored procedure from a unix script
  94. user scripts
  95. 'DD-MON-YY' v. 'DD-MON-YYYY' question
  96. Convert LONG format to DATE or CHAR
  97. pl/sql using cursors.
  98. triggers
  99. How to retrieve single column values from table
  100. overview on installicatio oracle database stup
  101. Help urgent Oracle
  102. Import particular field into oracle
  103. What is the best way to store data base source code in Perforce?
  104. Loading XML file content into database
  105. Oracle Connection
  106. triggers
  107. ORA-00907: missing right parenthesis
  108. sql query
  109. Case Insensitive Oracle Query
  110. Joining Same DB Table but want to locate back one record only
  111. ASP-ORACLE-ADODB Performance Issue
  112. Reports Printing
  113. How to connect 2 oracle databases using DBLINK?
  114. Count (*)
  115. single-row subquery returns more than one row
  116. Oracle dateformat
  117. Please help. How can we write SELECT query for this type issue.
  118. how to log in to the oracle db
  119. how to retrieve the image one by one from database
  120. any way to delete commas
  121. Running a PHP script when a new row is added to an Oracle table
  122. password issues
  123. Ora 1033 Error
  124. guidelines for my project
  125. SQLPlus and Special Characters in Oracle
  126. Carriage return at the end of the text line.
  127. Clarify Me
  128. PLS-00307 - Function Overloading Problem
  129. Need a solution.
  130. Pass Through UPDATE Query
  131. NVL Function for Date field
  132. comparision of null values in sql
  133. Oracle Error Codes
  134. updating records ....
  135. Basic Oracle Scripting SQL*Plus
  136. Truncate table inside trigger(Urgent help needed)
  137. Oracle Question - Using Toad (application)
  138. creating raw partition for asm diskgroup
  139. How to extract from LONG RAW data in Oracle.
  140. Update column ERROR to 'Y' on DBA_LOGSTDBY_SKIP view
  141. avoiding indexes on queries
  142. Use of exists when I cannot update to null
  143. how to create trigers
  144. crystal reports returns more rows than expected from an Oracle view
  145. Deleting from an Oracle table when a Where Clause needs to take values from 2 rows
  146. how to use variable with oracle like
  147. ordering of japanese characters in select statements
  148. oracle 9i with developer installation
  149. problem in trigger
  150. Oracle Fianacials And Oracle Projects Upgrade
  151. ORACLE 8i Vs ORACLE 9i
  152. Joins
  153. retrive morethan one value
  154. bitmap index
  155. simple transaction
  156. how to install oracle 8i in win xp sp2
  157. How to connect?
  158. CBO initial parameters - When, What, How to setup them.
  159. What happened if you drop a table and then create it again?
  160. SQLPLUS and Windows Batch Files
  161. %ROWTYPE Insert
  162. Insert data from excel sheet to oracle table periodicaly
  163. how to round off number in oracle!!!??!
  164. Insert data from excel sheet to oracle table periodicaly
  165. Oracle 9i Standby database configuration
  166. Implicit cursor
  167. PL/SQL triggers-how to disable all triggers of a user
  168. doubt in un known block
  169. displaying the date through sql query
  170. ORA-00907: missing right parenthesis
  171. Procedure problem
  172. Tables
  173. diffrence between decode and case
  174. regarding comparison in sql
  175. regarding the data storage in oracle
  176. regarding oracle and sql
  177. Insert duplicate data into UNIQUE index column
  178. ORA-12154: TNS:could not resolve service name
  179. How to write this query
  180. Difference between unique and distinct
  181. drop table
  182. Is any possible function accept three value for one input values
  183. Updating multiple table in one command passing a value through a variables
  184. correct syntax for function/procrdure call in a oracle package
  185. Run Report from Form9i
  186. Creating user in Oracle
  187. Increase The Import Peformance
  188. Is DML statements are cursors?
  189. Difference between Primary and Unique With Notnull constraint
  190. find difficulty in executing this function
  191. Case Statement in WHERE clause
  192. System Analyst
  193. Html And Oracle
  194. (x)HTML & Oracle? Can I create a web based manpower tool?
  195. difference between binary_integer and pls_integer
  196. oracle jdbc connector download
  197. Triggers-Mutating Table
  198. get all hierarchy data
  199. Needed oracle query
  200. about schema
  201. doubt about installation of forms and reports
  202. retrieve data
  203. I am unable to login SQL plus 8.0 in Developer 2000
  204. Getting the FKs established between two or more tables
  205. EXP oracle data
  206. Does ECHO work in SQLPLUS? If not what works?
  207. Tuning The Sql Query
  208. Oracle and Visual basic
  209. Extracting value/selected item from combo box
  210. Determine if Schema exists
  211. Parameter with Range values
  212. [error]: ORA-12516: TNS:listener could not find available........
  213. help with the use of "callfunc" function ?
  214. ORA-04021: timeout occurred while waiting to lock object
  215. ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY
  216. SQL Query using user_tab_columns and user_col_comments
  217. Ora-06550 Problem Urgent
  218. Oracle Server and Client
  219. how to get formated output of sql into a excel file?
  220. SQL command line + Trigger + Oracle
  221. SQL Navigator - how to pass input values
  222. Hi
  223. Alphanumeric string to number
  224. Primary Key
  225. Hi
  226. Materialized view
  227. sqltracefile
  228. Oracle Report 6i Time Difference
  229. oracle 10g RMAN error
  230. Getting ORA-00604 & ORA-06519
  231. How to get partition script for a table ?
  232. error after completing database cloning
  233. How to write output of a SQL statement to a file?
  234. SQL problem
  235. View
  236. how to connect UNIX to ORACLE
  237. Email+triggers+oracle
  238. Oracle10g`
  239. Sequence problem
  240. Unable to display clob data field with more than 32k characters on discover worksheet
  241. Oracle Forms And Reports
  242. ORA-00604 error occured at recursive sql level
  243. Left outer join problem
  244. query needed
  245. oracle ifs
  246. Materialized view
  247. Connection problem using EM Database control
  248. Etl
  249. writing a query to get the second highest value in atable by using select statement
  250. Oracle 10g (rman)
  251. BIGINT Datatype
  252. [pl/sql] Problem of select and display the result
  253. Create Database
  254. sending emails from oracle upon monitoring the database
  255. REPORT Error
  256. Which table space associated with Global Temporary
  257. PL/SQL Script
  258. tns error
  259. sequence
  260. retrieving data from the primary memory in oracle 10g
  261. [pl/sql] Assign a query's value to a variable
  262. ORA-29283: invalid file operation
  263. how to connect c with oracle
  264. Wildcards in Decode function
  265. Session Block
  266. Handling of table with large data
  267. Cursor, months and loop
  268. MOUNT vs. NOMOUNT
  269. Retrieving Columns With Null Values
  270. about queries of oracle9i
  271. Query
  272. Need to get the count of field from the subquery instead of main query
  273. Oracle clarification
  274. Convert usix time to human time
  275. Configure Oracle ODBC for Access
  276. ORA-12545: Connect failed because target host or object does not exist
  277. how connect to java application to oracle
  278. Query i need urgent
  279. query
  280. logoff trigger does n't works
  281. how to check tablespace space ?
  282. Need Help in Forms 6i
  283. Oracle schemas vs PostgreSQL schemas
  284. Clarification regarding "Raise Application Error" and "seq_collision exception"
  285. How can we store whole in database?
  286. exporting an oracle db table to a flat file
  287. Error ORA-12705 & ORA-00604
  288. Oracle Data
  289. External table
  290. Count
  291. Time Function
  292. Removing the first and last records while importing using sql loader
  293. I want to compare some table records vs a string
  294. Distributed database
  295. Partition a table
  296. Alter Database and Alter System Command
  297. oracle d2k reports
  298. Help me out
  299. Help Appreciated
  300. constraint
  301. Selecting the last date from mutiple duplicate records
  302. handling large volume of data
  303. single-row subquery return more than one row
  304. Problem with Inner Join
  305. way to solve
  306. urgent
  307. Urgent: SQL*LOADER ERROR 500 Unable to open file, file not found.
  308. Protocol Adapter Error
  309. import data to oracle 10g from sqlserver
  310. Improve Insertion rate in oracle
  311. Function To get the number of dots in string variable
  312. Ques????
  313. Select column at runtime
  314. Totalling calculation results in Discoverer
  315. Help: Trigger -Not able to delete data from trigger table.
  316. quota
  317. Problem
  318. Inserting Filename Into A Column While Importing
  319. How To Fetch Rows Before Insert In Pl/sql
  320. Oracle 10g with .net
  321. Sql Sub query "any"
  322. how to import a .dmp file in oracle ?
  323. PRO*C Vs PL/SQL
  324. about dblink
  325. how to install developer9i ds
  326. inserting time while importing using sql loader
  327. execute immediate statement
  328. ORA-01732: data manipulation operation not legal on this view
  329. can we retrieve data from oracle in-built tables using oracle forms?
  330. Developer 2000 error in our organization
  331. How to convert a string to an operator
  332. doubt while installing oracle db in linux
  333. Index on Numeric column not being used when using Like operator
  334. list box in oracle forms
  335. General question
  336. oracle database file searching
  337. Index organised Tables
  338. How to select rows from tables
  339. Hi questions about joins
  340. Oracle error
  341. automating export and import
  342. is it possible the import the date data from *.csv file in to a oracel table
  343. Basic questions
  344. ORA-01467:sort key too long i need urgent
  345. How To Approach Error Messages
  346. EXPORT ERROR encountered
  347. Time function - Oracle
  348. SQL Plus - Flexible Where In (List)
  349. How to call SELECT statement in TRIGGER?
  350. Clarification required while using correlated subqueries
  351. swarna plz give me replay any bady,In this code runtime error is coming can you find
  352. How to get the backend error/exception in forms alert at front end?
  353. Schema Copy
  354. Please help me with this
  355. Indexes
  356. query using where,group by,having
  357. procedures package
  358. How can i do in oracle forms developer
  359. how to copy column
  360. Oracle Server Database Backup
  361. In SQL how to subtract the 2 timings
  362. How to implement spell check control in oracle forms?
  363. Confused with oracle username
  364. Help with query...
  365. STAT Gathering
  366. REG:oracle apps
  367. Stored procedure call from Oracle Reports works in 8i and 9i but not in 10g
  368. How Can implement many to many Relationship With oracle object
  369. "create oracle user" using procedure in oracle
  370. doubt in oracle
  371. sound files in oracle10g
  372. Installation procedure for Oracle 9i on Linux 9 OS
  373. oracle rules engine
  374. Merge statement
  375. Convert MS Access SQL statement to Oracle SQL statement
  376. Recursive query
  377. ORA-01152: file 1 was not restored from a sufficiently old backup
  378. Query to delete one of the duplicate rows
  379. Reg::Trigger
  380. What is purpose of 'Tnsping'
  381. Truncate the partition table.
  382. Can i pass any Key after calling any software?
  383. REG: Synonyms
  384. Oserror
  385. How to workwith these functions in SQL?
  386. Doubt in understanding about NON-UNIQUE INDEX
  387. Spilts the dump file
  388. how to use these functions in SQL?
  389. about Serially resuable pragma?
  390. tns protocoladapter error
  391. Cursor: chronological order - guidance needed
  392. Ora-00280..............
  393. how to use procedures in cursor
  394. substitution variable in where clause in pl/sql
  395. need Oracle Help
  396. Where to place the commit?
  397. can't launch OEM console
  398. What is ANALYZE do?
  399. how to creating another user?
  400. Urgent help
  401. Run TKPROF..............
  402. exp utility
  403. missing right parenthesis
  404. How to identify the login name while running a report.
  405. Oracle session termination
  406. checking null values
  407. oracle script
  408. About PRO*C
  409. Sql Vs Pl/sql
  410. About AUTONOMOUS TRANSCATION
  411. directly hit database
  412. wrap
  413. procedure vs function
  414. how to config Oracle Form 10g
  415. Help For Oracle report
  416. Oracle PRAGMA
  417. Oracle 9i upgrade
  418. constraint error when creating table relationships
  419. speed reading records from Table
  420. query problem for two tables
  421. check whether a value is valid year or not in oracle
  422. how to add dynamic data in list item
  423. get the count b/w the time frame for multiple days
  424. Need help Inserting/deleting from a database
  425. Long Raw to Text Format in Oracle
  426. query help required.
  427. Reg Order By
  428. SQL Loader - Packed Fields
  429. Ora-16019...........
  430. SQL Dayname function
  431. Reg Sum Of Time
  432. error in saving
  433. Creating Oracle Database Remotely
  434. Tablespace error:ORA-01536
  435. catch invalid date value
  436. Oracle user ID problem
  437. decode and least function
  438. Oracle ODBC upgrade error
  439. Oracle Database Connection failure
  440. DECODE Function
  441. sql sequence
  442. Customize the Oracle login form
  443. How to find? "Number of Concurrent user"
  444. sub-string comparison with a number field
  445. cursors program
  446. validate year is numeric
  447. Trigger to delete a record
  448. How to load data
  449. Ora-00904
  450. Sample databases
  451. IS PLSQL BLOCK allowed in CASE WHEN when used in SELECT Query
  452. looking for an oracle graphical tool
  453. Reg-time
  454. Oracle multiple select queries
  455. update statement not working....
  456. DATEDIFF function in Oracle
  457. help in query
  458. to update a table with values from another table
  459. to update a table with values from another table
  460. sqlplus & column heading in hebrew
  461. Help In query
  462. Case statement in where clause is hanging!
  463. unique constraints
  464. Treatment of variables ending with blank spaces
  465. How to make a table format in SQL query screen
  466. Oracle 10g charset conversion
  467. How to add not null constraint to existing table?
  468. hi
  469. Oracle Text - creating of the word-frequency histogram from the Oracle Text
  470. Oracle Unix 9.2.0.5 on Sun server
  471. Oracle query
  472. Ora-01092...................
  473. Function to find Special characters in a emailid
  474. Data Uploading
  475. Oracle Reports:Replace blank spaces with zero
  476. Extract data into Excel and enable macros from PL/SQL procedure
  477. Connecting to an Oracle Database using ASP
  478. Index on Substr
  479. want a guideline for Hospital management
  480. how to find the count of employee in the following issue
  481. exec dbms_jobs.run(:jobno) after executing this i got one error message
  482. oracle doubts-arul
  483. Enterprise Manager is not responding
  484. how to install oracle9i
  485. oracle comand to resolve metasql (%join)
  486. Ora-25143................
  487. Connection in views of one of other users of a sid
  488. Email sent from a form
  489. Oracle Interconnect VS Oracle SOA Suite
  490. Commit outside the cursor
  491. Unable to run a Form
  492. Errors ORA-06502 and ORA-01438
  493. Problem while Accessing the data through "Toad"
  494. Error while fetching the data through "Data" tab in Toad.
  495. Rename column name
  496. Dynamic Execution of Stored Procedure
  497. ORA-12224: TNS:no listener
  498. mutating table error by trigger
  499. sir please help me regarding oracle d2k forms doubt
  500. Join two tables of different database
  501. querry a database
  502. copying table from one schema to another
  503. what would to temp and undo tablespace size
  504. Software caused connection abort: socket write error
  505. select_catalog_role
  506. Connecting To Oracle Database From Unix(script)
  507. Can We Update The System Table All_constraints
  508. Hierarchy without "connect by prior"
  509. oracle
  510. Ado And Oracle Stored Procedure Problem Plzz Helpppp
  511. constraints using alter command in oracle 9i
  512. sqlldr and validating data
  513. facing problem while running a form in Oracle Dev suite 10g
  514. Newbie with basic question about formatting
  515. SQL - Oracle (Get second highest date by group)
  516. Getting the second latest date in a group
  517. single-row subquery returns more than one row
  518. About CRM
  519. ORA-01483: invalid length for DATE or NUMBER bind variable
  520. Error in Procedure to Create Users. Duplicate name.
  521. Ora-02097...................
  522. i m having no idea how to do it
  523. Sort_Area_Size
  524. sound wave files in 10g
  525. Mutating Error in Oracle Triggers
  526. Can we commit in the session which is already created by different user rather than m
  527. Mutating trigger Error
  528. Oracle connection problem from vb.net framework
  529. pl/sql block
  530. systime
  531. Simple query
  532. No copy Parameter
  533. No copy Parameter
  534. Universal installer
  535. Procedure with update
  536. frm-40654 - facing problem with oracle 10g
  537. Displays date but not time
  538. Regarding Oracle Developer suite installation
  539. Lag Function in Oracle Discoverer Plus (ODP)
  540. what is the different between ORACLE D2K 6i and 10g
  541. toughest obect
  542. Oracle D2k
  543. Info about compatibility of varous browsers with 11.5.10
  544. how to know pakage DBMS_XMLSave is available or not
  545. How to Insert Bulk amount of Data
  546. how to complete this procedure
  547. update in oracle 10g
  548. Oracle Universal Installer for Windows Vista
  549. stored procedure that can fetch Hierarchical data from a table
  550. Returning dynamic results from a view