View Full Version : oracle answers


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

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