View Full Version : oracle answers


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

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