View Full Version : oracle answers


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

  1. oracle file full error
  2. UTL_SMTP: relay access denied
  3. Analytic functions
  4. Can anybody send mee a copy of Oracle for DOS....!!
  5. Joins
  6. physical and logical backup
  7. help on Oracle10g edition and developer6i
  8. selecting name from a database table
  9. need an oracle PL/SQL standard functions
  10. A procedure can not create a user?
  11. Table relationship
  12. oracle10g and developer6i?
  13. Ref cursor order by
  14. Append data into Target table
  15. creating a user within a function
  16. oracle MFS
  17. Using Decode Function
  18. How shape files loaded into DB
  19. Query Performance
  20. Update
  21. Oracle 9i Sql complex queries with examples
  22. Update statement ignoring 'where' clause
  23. want logic for this
  24. Other ways instead of using Connect By prior
  25. User Exits
  26. How to update existing menu in database
  27. escape ( in column name
  28. Do oracle considers index if decode is used?
  29. Synonyms database link problem
  30. URGENT..!!!!! Can any 1 Give me query for this pls?
  31. Accessing an oracle table from .NET
  32. oracle snmp
  33. CASE statement.........
  34. Session level auto-commit
  35. Query regarding dates
  36. Query regarding dates
  37. PL/SQL Function
  38. PL/SQL Function
  39. How to select only TOP record in a table
  40. Utl_file
  41. Help me to create stored procedure for paging Using oracle
  42. Select Column in Sequence
  43. Explanation with pragma restrict reference
  44. Oracle Query
  45. SQL return more 1 rows of record
  46. Oracle- one REDO file is corrupt out of 3 ?
  47. libclntsh.so in Oracle 9.2.0
  48. Ora-12154
  49. diff between ref cursor and cursor
  50. ..using WITH together with UNION..
  51. Oracle Forms - Checkboxes - When-Checkbox-Changed Trigger
  52. sql
  53. ORA-06531: Reference to uninitialized collection
  54. Oracle10g charset conversion Urgently
  55. Immediate Help............
  56. Dynamic SQL
  57. Pl/sql
  58. Table Partition
  59. Help Error 0922
  60. To remove duplicate lines from the output
  61. Error 30584 & PLS 00201
  62. Alter View.............
  63. Declare variable
  64. oracle
  65. How to do Incremental Load using PL/SQL
  66. oc4j configuration issue
  67. Grant problem
  68. Need help querying a db
  69. Performance tuning...
  70. compiler
  71. rollback in SQL * Loader
  72. varchar2 parameter in stored procedure
  73. relational algebra
  74. could not connect oracle database from remote place - Urgent
  75. ora-04020 deadlock while issuing revoke privilege from public
  76. Running Oracle Reports from a database table
  77. joins
  78. Union or union all...tough task
  79. Stored procedure that accepts multiple values
  80. Need your EXPERTISE and ADVICE on PL/SQL Procedures and FUNCTIONS.
  81. PL/SQL -- 12-month range window count
  82. Which type of argument passes a value from a procedure to the calling environment?
  83. Problem running JSP Page created through Report Builder 10 in web application
  84. assign output of a oracle query to a unix variable
  85. Oracle
  86. convert timestamp to date
  87. form builder to report
  88. FRM 40735:WHEN-BUTTON-PRESSED Trigger Raised unhandled Exception ORA - 305500
  89. To store a text file
  90. about triggers
  91. ORA-00603: ORACLE server session terminated by fatal error
  92. update with left join,from,on
  93. Oracle Forms - Migration
  94. Oracle Forms - Migration
  95. write to a excel file of the text in color using UTL.FILE in PL/SQL
  96. sqlplus/oracle database
  97. TO copy columns from tab1 to tab2
  98. Populating a table using trigger
  99. problem in hierarichal tree
  100. How to connect oracle data base from unix shell script
  101. ORACLE 9i
  102. changing column data
  103. Outer join problem
  104. New PL/SQL Feature in Oracle 11g: CONTINUE keyword
  105. how to include other users in the password file...?
  106. How to run cron tab jobs in sql environment
  107. Store file in database tables
  108. Migration from oracle7 to oracle 9i
  109. Control file could not be located
  110. Global temporary table
  111. NULL values & UNIQUE Key
  112. oracle10g data in ISO-8859-1
  113. oracle
  114. transelate this scripts
  115. Oracle 9i license key -
  116. Create a Funtion to Increment a 7 digit number and call it from a stored proc
  117. com1 data control
  118. Character Report
  119. Row exclusive lock
  120. Getting ORA-01003 error
  121. Parallel Execution
  122. What is the difference between current_date & sysdate function?
  123. Exception In Ref Cursor
  124. Including records in a query result that have no values
  125. Getting Missing Values in the List
  126. stored procedure
  127. data migration
  128. Database doesnot strat automatically
  129. Oracle-Report Writing
  130. Oracle-Query
  131. Procedure explaination
  132. What is the use of command TNSPING?
  133. please help me
  134. ORA-12162 TNS:net service name is incorrectly specified
  135. Trying To Acquire Oracle 8 Enterprise
  136. end of communication channel
  137. Database migration
  138. Help in Query
  139. Handle db events in external programming application
  140. what happened when increasing the size of redologs
  141. alter a co-dependent type
  142. Date and hour in stored procedure
  143. Query
  144. Global Temporary Table
  145. Updating table columns with where exist
  146. how to select rows where column with date is NULL
  147. Procedure
  148. ORA-00917: missing comma error
  149. somi
  150. ORA-00911: invalid character
  151. Trigger on bulk insert
  152. Oracle stored Procedure
  153. About performance tuning
  154. giude me
  155. "NOT IN" performance
  156. write a query row to column
  157. Drop a schema ?
  158. Why The Function cannot be called
  159. Duplicate Removing
  160. How To Find Termination Value
  161. Insert data from pl/sql table in Oracle
  162. Its very very urgent Please....Could you please help.plz help in solving queries
  163. Explain
  164. Charset In Oracle 10g
  165. plz send me aquery about sind months , days between two dates
  166. unload data
  167. report
  168. Grouping sequential numbers with SQL
  169. how populate list item
  170. how can we call the word document by using forms
  171. Trigger giving exception ORA-04091
  172. Report Writing on Oracle
  173. Report Writing
  174. What is error PLW 07204?
  175. Calling functions
  176. how to take hot back up oracle 8i windows 2000 server
  177. PL/SQL - changing one column's value depending another column's value
  178. Help in group by query
  179. revoke permission from another users schema
  180. sqlplus not working
  181. system privileges
  182. SQLplus
  183. tell me about tablespace??????and waht is schemaa???????
  184. REG Apps
  185. how to handle invalid objects
  186. Tns-12560: Tns Protocol Adapter Error
  187. will a primary key change be reflected in the existing records?
  188. Could anyone help me in writing triggers? Plzz
  189. about system privileges
  190. plz help me in dis query...
  191. Triggers
  192. Urgent............Plzzzzzz help me in dis
  193. Data Migration
  194. I m a fresher in oracle plz help me in solving these queries.. plz provide tips also
  195. ORA-06502: PL/SQL: numeric or value error
  196. help needed for litner creation and new username creation!!!!!!!
  197. sql * plus
  198. disconnect from a user
  199. trying to connect to database
  200. How Oracle 10g searching Queries?
  201. Sql Dynamically
  202. Converting Timestamp to date.
  203. Special guidelines for Oracle forum.
  204. Oracle roles
  205. Strings Length Issue
  206. dat
  207. what is listner in oracle?????i want to create it on my pc!!!!!!
  208. About creating user,deleting user and revoke privileges
  209. Need Query.. Help Please...
  210. help needed for developer2000 installation!!!!!!it's urgent
  211. code explaination
  212. deadlock situation
  213. Therminal Printer Does Not Cut Automatically My Character Report
  214. Global Temprary Tables
  215. Difference between sys_user and system_user?
  216. converting German char into english
  217. Partitions
  218. store procedure for birthday
  219. writing text on new lines
  220. if a data field contains acomma in it then how load it using sqlloader
  221. Segment.....
  222. temporary tablespace
  223. Index on multivalue varchar2 field
  224. Oracle Books
  225. Tempfile offline
  226. check decode fuction for ae,ext,gen and check joining
  227. Update time stamp for CLOB Data
  228. Moving Data In Alike Columns From Table To Table
  229. Can some please sort out my query
  230. Oracle 10g
  231. Alter tablespace to temporary!!
  232. Raise_application_error drop the error number when displaying
  233. Administration Oracle Database in C#
  234. Trigger help
  235. Startup Options - view
  236. Oracle9IAS: How to archive the application log
  237. Trigger and table
  238. How to give a grant like select,update,insert on a single table
  239. SQL Developer Result & TOAD Result is different
  240. External tables in Oracle
  241. Avoiding multiple reference to same value in Query
  242. Question
  243. HoW???
  244. update column
  245. Time slow by 30mins
  246. multi row update using sub query
  247. Oracle Reports 6i on RDBMS 8i
  248. Services
  249. i am not able to connect any user
  250. fetch the record with maximun seq number
  251. alter database command in Oracle 9i
  252. SQL UPDATE command for updating DATE
  253. Doubt in Reports 6i
  254. How to get the List of Active Users in a Responsibility (Oracle Apps)
  255. Oracle Connection
  256. Extract the 3 most recent dates
  257. how to select Row from the table
  258. Script that searches and updates/deletes
  259. Update command syntax
  260. Date format in Procedure.
  261. SQL Error: Missing IN or OUT parameter at index:: 1
  262. Autonomous_transaction
  263. error while shutdown the database
  264. Error in parsing XML File
  265. wait events
  266. why datadapter do not fill dataset with all changes in database?
  267. Postgres type conflict
  268. XSU.insertXML() type conflict
  269. Didnt get OCA certificate
  270. Oracle HTTP Server Help!
  271. Prepare Statement Limitiations - URGENT ANSWER NEEDED
  272. Create Table In Oracle Procedures
  273. Oracle doubts.
  274. can we write a procedure inside the function?
  275. Date format
  276. help me regarding TNS PROTOCOL ADAPTER ERROR!!!!!!!!
  277. inserting images
  278. What could this question be asking about?
  279. Report builder-Forms builder bugs?
  280. how to insert a single row
  281. Error parsing xml files - Help urgently needed.
  282. Advantages of function overloading
  283. help needed to drop unnames constraint!!!!!!!!
  284. From cursor to a table
  285. Sid, Pid............
  286. Need help in using Radio Buttons, Check Boxes at run Time
  287. "SQL Statement ignored" and "ORA-01733: virtual column not allowed here" errors
  288. catalog.sql, catproc.sql and pupbld.sql
  289. sqlloader
  290. reading a trace
  291. SQL Server Tables Import into Oracle
  292. Dynamic LOVs in Developer 2000 forms 6i
  293. Max value in select statement
  294. begginer
  295. Error in PL/SQL block
  296. insifficient priviliges problem
  297. Send mail from procedure
  298. Oracle Sql
  299. JAVA to ORACLE Date Problems
  300. JOINS In Oracle
  301. How can Stored procedures be used in oracle reports for creating reports?
  302. How Indexes improve performance?
  303. Connect by In Oracle
  304. Update table from Flat file
  305. Pro*C and nested tables compiler error
  306. Not able to user synonyms based on dictionary tables like
  307. Advantages and Disadvantages of a Stored Procedure
  308. Conversion of date format
  309. Grant
  310. database design.(rehan)
  311. how to execute package
  312. optimizing the query
  313. home instance down
  314. IN OUT parameters in Procedures
  315. Oracle spatial
  316. Outside and Within Campus?
  317. Testing of Counters?
  318. Difference between Implicit Cursor and Explicit Cursor
  319. Rem Serveroutput?
  320. PLZ Help to connect to deffrent databases togther
  321. Oracle ORA-01033 Error & ORA-01031 error
  322. What is precompiler
  323. oracle
  324. Blob
  325. Displaying records using %ROWTYPE
  326. india localization oracle fast formulas help
  327. when and why do we need to use pragma serially reusable?
  328. Suse 9 -php 4 - oci8 connection
  329. trigger on AFTER LOGON DATABASE
  330. Declaring a cursor ROWTYPE%
  331. How to solve the restricted data type attribute violation ?
  332. Create any table
  333. how to connect from unix to oracle
  334. Dirrence between VARRAY and Nested Table in PL/SQL
  335. Simple question on how to insert record?
  336. Query behaving differently in different times
  337. What is the use of tnsnames.ora?
  338. oracle Index
  339. Theory questions
  340. sql loader
  341. Pragma autonomous transaction
  342. oracle error..ORA-01858
  343. Hit Ratio of Database Buffer Cache
  344. oracle to postgresSQL
  345. Dynamic %ROWTYPE
  346. How to Unloack Lock
  347. definition of SID in Oracle
  348. Oracle applications 11i installation on WinXp
  349. simulteneous transactions
  350. WITH cluase in Oracle.
  351. What is the Difference Between Oracle 9i and 10g
  352. select statement
  353. difference between case and decode
  354. problem with row_number()
  355. Cbo Rbo
  356. Creating a sequence
  357. index
  358. Swapping tuples using single, simple query
  359. Date Range Criteria with Single Date Prompt
  360. Uninstall Oracle 8
  361. sql query of duplicate records
  362. about oracle 8i
  363. Long-Running Opretations (V$SESSION_LONG_OPS)
  364. oracle statement
  365. Oracle Cursor Problem
  366. help for creating trigger to control the insert according to salary>1000!!!!
  367. dev6i
  368. ORA-03113: end-of-file on communication channel
  369. Help with a Subquery
  370. ASCII Dump of Oracle Table Data
  371. Regarding pl/sql
  372. Converting rows to clumns (max case)
  373. Database Writer / Database Writer I/O salves
  374. "URGENT" please solve oracle9i installation error
  375. new to this group
  376. Need help to import data from excel sheet to oracle database,front end is asp.net
  377. insertion with quick performence
  378. what difference i and g makes in oracle version
  379. to fetch ist 25 rows
  380. package takes long time to run insert statement
  381. need help for oracle insertion
  382. turkish character problem in report builder
  383. oracle sid
  384. oracle report builder
  385. regarding pl/sql sql%notfound
  386. ORA-07445: exception encountered: core dump [FFFFFFFF7E769708] [SIGSEGV] [Address not
  387. pl/sql procedure
  388. Installing ODB.NET
  389. Calling Oracle Stored Procedure from c#.net 2.0
  390. Oracle Stored Proc - Compilation Error
  391. INST Command and help breaking apart Syntax (SQL/Oracle
  392. Any way to stop asterisk translation in a view?
  393. Help needed with String Operation
  394. How can I show the default value?
  395. cursor using join in 8i
  396. can't see the hebrew character
  397. Want to change color of text item when got focus in forms builber d2k
  398. Oracle database creation
  399. Logical & Physical Structure
  400. Table - Logical structure
  401. problem with oracle 10g
  402. password reset plugin
  403. Statistics error
  404. Indexes & Dates
  405. is this syntax right?
  406. Cursor in PL/SQL Oracle
  407. retreiving multiple rows using procedure
  408. Tablespace
  409. problem in oracle apps report while registering reports
  410. oracle10g install on IMacOSX
  411. Oracle Partition
  412. how to disable the item
  413. [1]: (Error): ORA-00907: missing right parenthesis
  414. Integrity Constraints
  415. can we change toolbar and menu bar from oracle report 6 in preview
  416. Db_link
  417. can we connect developer 6i with oracle 10g
  418. hi guys, It's santhosh here,
  419. tns Problem
  420. To make table data case insensitive
  421. Looking for Oracle 8 disks for Linux
  422. need help with dates in teradata
  423. rman backup - retention policy , archive logs
  424. How to find a strucutre of atable in oracle like desc in mysql
  425. Populating Active Directory with data from an Oracle DB
  426. merge hierarchical trees
  427. use of group by with union all
  428. How to store and retrieve an image in oracle using java
  429. Usage Of View
  430. how to migrate oracle to sql
  431. workaround for admin option
  432. Oracle Contains() function won't return rows when Numbers are part of the search term
  433. Reg DMBS Jobs
  434. simple sequence question
  435. Formatting sysdate
  436. 'ORA-00933: SQL command not properly ended' in oracle dtabase
  437. difference between count(*) and count(1)
  438. Oracle OCI for checking the status of database in VC++
  439. ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
  440. Enabling/Disabling Radio Buttons
  441. tablespacing
  442. Can cursor variables be stored in PL/SQL?
  443. How To Restore A Postgres Database Backup In Oracle
  444. Amending a Startup form of an Oracle 6i Application
  445. Oracle 8i installation problem with Windows XP OS
  446. split out duplicate records in Oracle table
  447. import excel worksheet into oracle table
  448. Terminate the scheduled execution job.
  449. Difference Between Oracle6i And Oracle9i
  450. global_database_name in oracle 8i
  451. need help debugging missing parenthesis
  452. How to select data containing newline characters in them.
  453. Triggers in Oracle
  454. (to_char(myDate,format) < myString) vs (myDate < to_date(myString, format)).
  455. file I/O operations
  456. Query using full table scan
  457. query optimisation
  458. Privilege for AFTER LOGON ON DATABASE
  459. Oracle - Rollup not working when I use Having clause
  460. List items in Oracle Forms 6i
  461. Oracle definitions
  462. import data from oracle to MS-Access using forms6i
  463. unique index and non unique index
  464. How to install forms 6i
  465. oracle import only specific user from a dump
  466. possible to create index on a column which contains NULL values
  467. update and insert within the same trigger
  468. handling Long raw data type tables
  469. to see the contents of a view
  470. need a query to display the row value as a column header
  471. Difference between UNION and UNION ALL
  472. possible for function with DML statement to call other function or procedures
  473. Import .xls file into oracle
  474. Using instr and substr
  475. How to create TRIGGERS for inherited types in Oracle
  476. calculate the avg time of two time stamps like start_time and end_tiem
  477. Microsoft OLE DB Provider for Oracle error '80004005'
  478. Connectivity with Oracle8i and Visual Fox Pro at the same time
  479. preserve links while reconciling Oracle Warehouse Builder Premapping operator
  480. Seeking Suggestions
  481. can you commit inside functions
  482. Oracle Query optimization
  483. Functions
  484. Regarding importing of data
  485. database query to show calculated value
  486. question......
  487. preventing sqlplus output to terminal from UNIX
  488. Function return OUT mode
  489. Update record syntax
  490. alter table syntax
  491. problem in creating database
  492. how to write to get a report like....
  493. Trigger valid/invalid
  494. run dbms_stats for a set of tables through a PL/SQL block
  495. Date and time columns - days, hours mins between in SQL
  496. OCI prefetching with ref cursors
  497. how to give prevalages in oracle 9i
  498. what is a virtual table in plsql
  499. Migration from SQL Server Reporting Services to Oracle Reports 10g
  500. How to drop Not Null constraint (system generated)
  501. Explain Plan and Full Table Scan definition
  502. Displaying null value
  503. function truncate
  504. Use functions
  505. Table using joins.
  506. creation of table in procedure, table name as input
  507. what is a virtual table in oracle?can anyone explain pls..
  508. query to match weekly and daily records
  509. Host credentials
  510. FRM-30087: Unable to create form file
  511. select query
  512. DATA prefix on column names
  513. Fast Formulas
  514. locating a particular table or tables in a complete project
  515. Unable to use loop with user input
  516. Unable to close database, get error ORA-01093
  517. Selection Values From 2 Different Rows Of Same Query For Further Calculations
  518. using a ddl statement in a stored procedure
  519. procedure to copy table
  520. Join query not retrieving records
  521. PL/SQL function to invoke the UNIX command doesn't create file
  522. unable to update database
  523. Query
  524. about odbc from forms 6i with micro soft sql server
  525. Find Product Key
  526. Counting number of records in a form
  527. Oracle & ProC
  528. Converting Data to flat file.
  529. Validate a Field in 2 seperate DB ??
  530. Update Query Doubt
  531. Oracle certification
  532. normalization concept with example
  533. Export Oracle Table
  534. Using Parametarized cursor in Execute Immediate
  535. BPEL for integration of web apps
  536. Cant Connect Database
  537. Borland Delphi 6 and Oracle 9i
  538. ORA-01841: (full) year must be between -4713 and +9999, and not be 0
  539. Creation of calender in forms 6i
  540. Installation Problem
  541. To_char(to_date(1234567,'j'),'jsp
  542. How to make column autoincrement in Oracle 9i
  543. Get the Recent Record
  544. function to convert numbers to characters i forms
  545. Left Outer Join with subqueries?
  546. Database error
  547. oracle procedure
  548. Indexes
  549. Back up contents in table data
  550. Oracle table Maintainance.