View Full Version : oracle answers


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

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