View Full Version : answers

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