View Full Version : oracle answers


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

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