View Full Version : oracle answers


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

  1. cursor is open or not?
  2. How to Run Oracle Sequence to MS Access
  3. Problem with query
  4. procedure
  5. Problem with joining two tables
  6. triggers to monitor stock options backdating
  7. choosing index for inner join
  8. choosing index for inner join
  9. woking BLOBS with OLEDB
  10. Persian date on oracle form6i
  11. Oracle and XML
  12. How can i insert thousand records using single query?
  13. update query problem
  14. Accesing another user's Table
  15. Query Help in Teradata
  16. hierarchical tree
  17. How to grant privileges automatically to newly created user?
  18. SQL Query doubt
  19. Rollup and Cube..
  20. REDO Log file corrupted
  21. Use of hierarchical tree in Oracle9i forms
  22. Find growth rate of a table
  23. return a variable value in a cursor
  24. SELECT query syntax
  25. Error while trying to load jar file using loadjava
  26. Explain SID and TNS names
  27. extract data from the partitioned table
  28. Oracle9i Form Report connection
  29. Grouping By a To_Char
  30. PL/SQL equivalent of Select 0, Select 1 etc
  31. Query to find Primary and Foreign keys
  32. Could not create an environment: OCIEnvCreate returned -1.
  33. declaration and scope of variable in procedure
  34. Cascade deleting
  35. What is connect by prior?
  36. to_timestamp fomatting of Dates
  37. ORA-01033 : Oracle Initialization or shutdown in process
  38. "PLS-00201:identifier' <User>.<Procedure Name> ' must be declared"
  39. To_Date in query returns date only
  40. How to update all columns in a table
  41. Sql Date and Time doubt
  42. Tables
  43. Datatype Problem
  44. cx_Oracle.NotSupportedError
  45. Return data from stored procedure
  46. Overloading
  47. Function Overloading
  48. Packages
  49. Some questions..
  50. SQL Query
  51. Dept wise max sal
  52. SELECT query on joined tables
  53. PL/SQL Sorting Function
  54. hOW TO DEVELOP CUSTOMIZE FIELD VARIABLE IN SELECT
  55. D2K problems
  56. usage of Dual table in oracle
  57. SELECT query to find max
  58. Stored Procedures & Oracle
  59. Max(Date) in select query
  60. UNIX script for EXPDP/IMPDP IN Oracle 10g
  61. Mutation table
  62. Records in hirarchial
  63. ORA-01092: ORACLE instance terminated. Disconnection forced
  64. Some questions
  65. the status field value
  66. SELECT query on joined tables
  67. trigger a particular date
  68. How to compare the contents of two tables of identical structure?
  69. UPDATE query
  70. List of tables on which a trigger is used
  71. Joined date
  72. maximum date and not zero records..
  73. the name of a table inside a function
  74. Code Comprehension Exercise
  75. This is the query somebody ask me to do in my first interview of a career.
  76. Need Help for the following Query
  77. update and case clause
  78. Update through join
  79. Problem with MERGE statement
  80. Import Problem
  81. Query Formating In Sql-need help
  82. dynamic cursor?
  83. Duplicates only
  84. Needed Query ..
  85. Oracle Scripts
  86. Dynamic datastructure of objects
  87. query output in CSV
  88. to find top 10 salaries of employees with their names
  89. sql related questions
  90. inserting data into oracle database using perl script
  91. results of left outer join and =(+) in oracle are different
  92. global temporary table.
  93. How to import dBase data to oracle in Linux?
  94. Oracle Errors
  95. siebel
  96. Need help in Update statements with Set for Oracle
  97. oracle pro*C problem:varchar variable is truncated after calling C function
  98. Whenever OSError Exit gives error, O/s Message : No such file or directory
  99. oracle9i -- installation hangs
  100. ORACLE Report Builder 6i parameter form problem
  101. Fatal: Stack size too small., when installing oracle - plz help
  102. Need Query..
  103. error in oracle: maximum number of processes () exceeded
  104. Delete query is slow
  105. create temporary table
  106. call function to function in pl\sql?
  107. pl/sql problem, please help!!!
  108. Sequence at run time
  109. Dependent User Parameters in Oracle Reports
  110. temporary tables
  111. Parameter Store procedure
  112. Change the Sort order of the columns in the table structure.
  113. Need Help with Database Trigger
  114. Do we have GOTO statement in Oracle 9i
  115. Cursor problem
  116. Procedure, to get the Used space in Oracle
  117. PL/SQL theoretical questions
  118. Stored Procedure return
  119. ORACLE Report Builder 6i parameter form problem
  120. Tricky LEFT OUTER JOIN with possible union???
  121. DECODE function
  122. Import Problem.
  123. get record count with out using count function
  124. How to refine the catsearch
  125. Case with greater than/less than
  126. How to use group by?
  127. changing column type from Varchar2 to BLOB
  128. Data Transfer between InterSystems Cache & Oracle.
  129. date 3 month
  130. .sql file to Oracle tables.
  131. how to insert
  132. Data Type
  133. Oracle Query questions
  134. Export-Import
  135. About Execution Plan
  136. oracle quary
  137. Run Action Queries in VBA-TERADATA
  138. Marthi font Issue with Oracle 9i / D2k 9i with Application Server 9i
  139. Reading xml file and writing it to a text file using PL/SQL
  140. ODBC Driver migration from vers 8 to 10
  141. case statment in oracle
  142. User Privileges Problem.
  143. How to use for loop
  144. using for loop
  145. stored procedure
  146. Login Credential (Oracle9i Form Developer)
  147. Report Parameter (Oracle9i form developer)
  148. how to run oracle9i server with JSP connectivity
  149. DELETING Millions of rows from a table
  150. Like '&'
  151. Sometimes an error come out "Could not connect to database"..Why??
  152. to find diff b/w time
  153. To Find The Diff between time
  154. Top 10 Rows
  155. null value in joins
  156. need help in update statement
  157. Connect by Clause
  158. Connect by Clause
  159. Decode grouping error
  160. Full outer join issue
  161. problem to write connect user command inside the procedure any other option is there
  162. problem to write connect user command inside the procedure
  163. ORA-01427: single-row subquery returns more than one row
  164. Performing Bulk Inserts
  165. Fga
  166. create menu in Oracle 9i Forms
  167. how can you populate a textbox with a parameter being passed?
  168. What is snapshots in Orcale?
  169. Lab Scripts
  170. DB connection
  171. Creating Temporaory Dynamic Table in Oracle 8i
  172. How to find last row and last column of table?
  173. using :NEW and :OLD in Dynamic SQL URGENT!!
  174. i have problem with store procedure
  175. Batch Command to Switch between two Oracle Homes
  176. Required Query help
  177. Problem of trigger
  178. To retrive data in two tables
  179. Random function
  180. nearest and previous date
  181. search for a string in the entire database
  182. Array of ref curosr
  183. import database 9 to 10i
  184. trigger
  185. Need Dynamic PL/SQL block
  186. top bottom query
  187. functions in oracle
  188. Want to Pull "x" number of records.
  189. separate numeric and non-numeric values from alphanumeric
  190. Exporting data from Oracle to Excel
  191. Problem selecting distinct record
  192. C#.net-oracle procedure problem
  193. output of dynamic query
  194. Can we convert rows into columns in oracle
  195. MS-access to oracle migration
  196. column updation
  197. defragment a database.
  198. issue with group by
  199. Sharing
  200. spotlight on oracle
  201. ftp file transfer of datafile problem
  202. storing image in database...
  203. Fetching records based on two dates and with a certain time frame from a table two
  204. Help needed in SQL query
  205. i want 2 create a trigger.Plz help as soon as possible
  206. i want to know rate of total salary for each department
  207. i want to know rate of total salary for each department
  208. How can we make disable a Field of a FORM at run-time?
  209. SQL Trigger
  210. Turning this select statement into a delete statement
  211. schema in oracle
  212. Need oracle help
  213. Dynamic queries
  214. display the records 10 by 10.
  215. oracle 9i installation
  216. Outer Join _ SQL
  217. Prasing the column names
  218. installation of oracle 9i working with VC++
  219. Update Procedure.. for two tables
  220. How can I copy a Sequence objects of Database for other whith script??
  221. Regarding insertion of records
  222. if i lost installation of oracle how to retreive tables i created?
  223. btree to bitmap conversion
  224. SQL Project to make music playlists HELP!!!
  225. Deinstall of Oracle 9i from C and D drive
  226. how to coonect java program to oracle database
  227. Prevent update to column in a table
  228. Oracle date formatting problem
  229. Oracle 10g Sequence Help please?
  230. Configuration assistants failed
  231. Building a View (basic SQL ?)
  232. Oracle error
  233. export porblem
  234. Oracle Update based on multiple table syntax
  235. creating physical standby database
  236. How to call Oracle report in oracle form?
  237. How to disable a Field (FORMS 6i) in runtime?
  238. oracle 8i can not auto start in MS server 2003
  239. oracle 8i can not auto start in MS server 2003
  240. Please help me to figure out my error.
  241. Information about tables in database.
  242. Oracle 10g Form glitch
  243. how to copy table in access to oracle?
  244. how to make table importing ?
  245. Performance problem with 10G Application Server via internet
  246. Conversion of SAS date format into Oracle date format
  247. dynamic sql
  248. cursor
  249. Oracle10G Sql loader
  250. having clause
  251. DIFFERENCE BETWEEN NVARCHAR2(n) AND VARCHAR2(CHAR n)
  252. Linux Web Server access Oracle 6i with Jinitiator 1.7.31
  253. SQL Optimization
  254. dealing with composite primary keys
  255. Using XML as a table?
  256. Package Execution and Error PLS-00306
  257. Correlated Update
  258. protocol adapter error
  259. Passing arguments to Cursor
  260. Extract tables from several databases
  261. is there any driver level difference between oracle 8i and 9i
  262. Oracle Logging
  263. How to update the xml data using plsql
  264. MS ODBC driver for oracle
  265. Index
  266. Can anyone say that the difference between oracle and informix
  267. how to use the following sybase function in oracle
  268. updating one table based on select from two tables
  269. Column Offset problem using sqlplus from Command Prompt
  270. to update multiple values in a single query
  271. Oracle :import database from linux sever on local system windows
  272. scope in oracle for B.E(I.T) graduate
  273. DBMS_RANDOM Package
  274. Oracle 10g Optimization
  275. Conversion of csv to Oracle Form with examples
  276. avoid "no changes to save" error in module
  277. oracle
  278. How do i setup a join query for this?
  279. how to store data from oracle to sql
  280. error message:no changes to save
  281. missing right parenthesis - new to SQL need help
  282. VB and Oracle connectivity
  283. merging two tables
  284. max value from a string
  285. what's the problem with query
  286. Ora92 Install Path
  287. Exporting a table from Access to Oracle
  288. What the diff
  289. Oracle assistance in Triggers, Procedure and Cursors
  290. how to reteive blob data through java
  291. oracle connection error
  292. how to run reports in forms9i
  293. Unique constraint Help
  294. Constraint
  295. Procedure to backup/restore Oracle 9 to Oracle 10
  296. Using Max In Subquery.
  297. D2k and oracle 8i in same machine
  298. Creating table
  299. Oracle9i connect with jdk1.4
  300. DBMS Job
  301. date and timestamp storage problems
  302. How do i get clob data using java and assign to a variable
  303. How to delete particular column by keeping primary key
  304. ORA-12514 listener does not currently know of service requested
  305. Oracle and SQL Server on the same machine?
  306. identifier must be declared
  307. TNS:protocol adapter error
  308. Unix Cron Job Schedule
  309. One Stored Proc for 2 db owners
  310. convert a dbf database to any oracle version
  311. run_product
  312. host name and password for oracle
  313. oledb in oracle
  314. Droping the table
  315. Need OCP latest question
  316. Oracle Discoverer
  317. Dynamic Pl/sql
  318. how get the size of long raw data?
  319. Display fields
  320. What is Different Between Empty String and Null value in Oracle?
  321. Minimizing The Buffer Gets
  322. problem with dates
  323. Set user name and password
  324. problem on installing oracle 9i on windows XP
  325. Problems with decode function in Oracle ... Turning me mad
  326. Hierarchical View
  327. Parsing the last name (from full name field) into temp table
  328. code to connect jsp page to oracle 9i
  329. XML file to oracle table
  330. Help!!! Non-RAC database on AIX HACMP cluster
  331. from XML to ORACLE
  332. Login Problem OEM 9i
  333. unable to add foriegn key constaint
  334. Make Pyramid in PL/SQL
  335. Ora Error 12560
  336. Hi,it 's Me Again!
  337. Using Oracle Proxy User feature
  338. help me with update
  339. Tables on which view is made
  340. PLS-00306: wrong number or types of arguments in call ?????
  341. Oracle Wrong number or types of arguments error
  342. restricting a user to access his own tables
  343. Begginer , Problem In Keys
  344. Runing package script for Oracle Database in .net installer
  345. Migrating from Access to Oracle
  346. compare data between tables in test and production
  347. Upgrading Oracle from 8.1.7.1.1 to 9.2.0.8.0
  348. self join error
  349. Starter
  350. PL/SQL Fix Record Length file
  351. ODBC connetion from Access to Oracle 10g...
  352. Solve this
  353. insert record from inside a catch block
  354. merge statement
  355. How can I extract the output to excel sheet with the heading
  356. insert into from where order by ?
  357. insert into from order by
  358. oracle 10g
  359. oracle
  360. oracle
  361. Multiple table join issue (Oracle)
  362. Problem in Installing ORACLE REPORTS 6i
  363. Pro*C doubts clarifications required
  364. Use Of Between Operator In Teradata
  365. accessing sql * plus instant client on my local machine
  366. I need a help in TERADATA
  367. Oracle Discussions
  368. Hi,How to list only user created schemas in oracle
  369. Tell me the diff.
  370. Procedure Help
  371. Table join from different servers
  372. Oracle 10g and XP
  373. Retriving Last ten modified Records
  374. Log On Database Trigger :ora-00406 :
  375. How to single numeric values from a field in a table which has multiple numeric value
  376. sql query to csv file
  377. comparing 2 tables
  378. Loop thru columns in a Trigger
  379. Oracle Error -12538
  380. error while using loadjava
  381. Client Oracle 7.3.4
  382. oracle client 7.3.4
  383. Migration to Oracle from MS-Acess
  384. VBA codes for oracle database
  385. retrieve row to encrypt witth dbms_sql
  386. Grant Privileges
  387. time without date
  388. Oracle Migration from SQL Server 2000
  389. Pass a variable into a Oracle View
  390. Slowly Changing Dimension
  391. Full outer join in oracle
  392. Optimization of delete query
  393. Teredata
  394. Query to create a total
  395. iASDemos.htm
  396. find default user
  397. Using Case Expression-----tuning
  398. Difference Between Oracle 8i And Oracle 9i
  399. How can i get learning material for Oracle 8i?
  400. UAC & Bind UACs
  401. Relating TableID to multiple instances of itself
  402. Oracle 8 with Win2k3
  403. Oracle CD Required Chennai
  404. Forms 6i
  405. removing time from date format
  406. How to add picture in oracle database table
  407. Need to get the numeric value alone in a alphanumeric string
  408. update to lower
  409. Insert
  410. change data
  411. Alter Command
  412. Sql query help
  413. Opening a file in Append mode
  414. pls help me
  415. duplicate records
  416. Comma-delimited File PL/SQL
  417. Convert from Number to binary
  418. inserting values into table
  419. Insert script
  420. Renaming user in oracle 9i
  421. what is schema
  422. UAC & Bind UACs
  423. adding row at run time
  424. displaying xml tables in oracle
  425. Group by on Nested Query ??
  426. SQL Script
  427. oracle 9i post installaton information
  428. Oracle 9i first use
  429. Asynchronous Replication
  430. error in cursor
  431. Load Balancing
  432. Crystal in Oracle forms
  433. external table
  434. wat is a cursor
  435. query to get list of tables
  436. Manipulating long data type fields in query
  437. Japanese Character on SI Browser...
  438. rollback after commit
  439. MS Access Table
  440. How to Oracle shutdown
  441. Oracle update statement help
  442. Greatest Function Problem
  443. writing output from Pl/SQL o txt file
  444. for oracle
  445. How to Get the Column name using entered Data
  446. how use variable more than one time in a same query?
  447. how i store o/p values in excel sheet....
  448. Temp Tablespace in Oracle9i
  449. Time taken for insertion into a table
  450. Can I create and drop a function from inside a stored procedure in Oracle ?
  451. Accessing Oracle DB with C Program
  452. How to execute more than one database query in a JSP page
  453. Update from Select - can I get there from here?
  454. query based on another query
  455. Sqlloader
  456. copying oracle database file from one computer to another computer
  457. Give a look here
  458. Unable to migrate data from Access source to Oracle destination
  459. installation problem
  460. error message
  461. add an '
  462. Problem with Oracle 9i
  463. Oracle 11i apps on web
  464. dual
  465. inserts and select
  466. Logging of an UPDATE
  467. Problem in Update with Order By clause
  468. my application server stopped automatically....
  469. how to know the nos of unnecessary open cursors
  470. In Search Of Job Opertunities
  471. Getting the first row of columns with same values
  472. oracle form got error -- ora-12560
  473. Outer join or sum function?
  474. LGWR and ARCH
  475. convert rows to columns
  476. Triggers on user_objects and user_constraints
  477. Changing multiple sequence values using SQL Query
  478. Problem in using Connection By in inserting hierarchical data using Oracle 10g.
  479. data ware housing
  480. Sequential search then update record
  481. image in oracle
  482. Self Join?
  483. Unable to migrate data from Access source to Oracle destination
  484. Rman Book
  485. Oracle Backup using Netbackup
  486. Loading emails into a table using ORACLE PL/SQL
  487. Convert Date
  488. update diff datatype in same table
  489. Stored Procedure
  490. Cannot Store Chinese Characters In Oracle 9.2 Database
  491. Multiple IP on Listener.ora & Tnsnames.ora
  492. Online booking system problem
  493. Getting Error while opening database
  494. Changeing the user name in oracle 9i
  495. Errors in Oracle
  496. converting amount to text
  497. Oracle Sequences
  498. TOP Command
  499. How to Handle Exception in ORACLE. Please
  500. Oracle Enterprise manager for oracle 8i on sco unix platform
  501. Placing oracle Database over web
  502. Replace certain portions of data tied to an ID.
  503. Help with connecting JSP to Oracle
  504. Removing Oracle especially Listener
  505. Does checkpoint queue have RBA (Redo Byte Address)??
  506. Problem Update
  507. another oracle_home to install report builder 6i
  508. What is difference between datatype Time and TimeStamp?
  509. Group By Function
  510. Oracle
  511. Procedures in batche.
  512. Ref Cursor Out Parameter in Procedure.
  513. How to export and import oracle DB using toad?
  514. Oracle SQL Developer Connection Error
  515. Problem to run forms under developer suite 10g
  516. Heterogeneous Services-not able to connect access database from oracle
  517. formatting output in oracle
  518. Maximum number of tables in Join
  519. Which fields are changed on update - History tracking
  520. Identifying Value Sets Against A Specific Table
  521. reriving records from multiple tables.
  522. Table Mutating Error
  523. query for selecting lastday of the previous month
  524. Calling word application from oracle forms 10g
  525. Need books "oracle-Banner"
  526. To find a cut off date based on the working days setup
  527. How to install Report Builder 6i
  528. How to use VARRAY and NESTED TABLES in Oracle Stored procedures / packages
  529. difference between decode and case expression
  530. Spooling Techniques.....
  531. unique constraint when value = 1
  532. how to check if the database is created
  533. Help Required: To run the attached UNIX script
  534. Great thread on normalization in db2 forum...
  535. User_constraint
  536. Convert MS Transact-SQL to Oracle SQL
  537. Problem in Oracle 9i installation on XP
  538. how i create a delete trigger that will save the deleted row into another table, like
  539. case sensitivity in 9i & 10g
  540. Two tables....
  541. Count total columns
  542. Temporary Table..
  543. I want every 100 th record in total of 1000 recors in a table.
  544. Primary and Composite keys
  545. difference between primary key and not null constraints?
  546. Query data from one table to another
  547. difference between time and timestamp in oracle 9i
  548. how can save text item value in table
  549. HELP - Export/Import with version 8.05
  550. newbie help with button triggers