View Full Version : oracle answers


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

  1. newbie help with button triggers
  2. How to get the last row in the table
  3. Creat A login Page
  4. sql query
  5. Need help in formating the output into excel
  6. Arranging nos in a serial order
  7. Help required
  8. Problem with 2 Oracle Clients installed on the same machine.
  9. oracle 9i and windows xp media center edition
  10. what is the command to know orcale service name
  11. Alias in Oracle Case function
  12. Help Me Please.........
  13. Basic Tips Needed
  14. Hirak:y and foreign key relationships,among tables in oracle
  15. spool use
  16. insert into a data field
  17. dsn of oracle 10 xe
  18. COMMIT - If so many no. of records?????????
  19. Resolving Replication Errors
  20. .net/oracle multiple select parameter problem
  21. How to insert a Enter Key (a new line) into a string in Oracle 10g?
  22. extract the integer part of a number
  23. Trigger- before insert
  24. oracle report and form 6i
  25. unix command
  26. advantages of shell scripting
  27. Error in Oracle 10g while adding Order by clause
  28. Oracle Basics
  29. SQL ORACLE major utilization
  30. ccokies has been disabled
  31. Problem in deleteing record based
  32. Problem in deleteing record based
  33. listener refused error
  34. Field naming conventions
  35. sqlldr
  36. shell scripting
  37. Oracle Graph Pattern not seen in PDF format
  38. problem in isqlplus
  39. oracle report tool 6i
  40. need some answer for the following question
  41. Has Anyone Used certmagic For Cissp?, CISSP
  42. package disadvantage
  43. Multiple regression within Oracle
  44. TNSListner Troubleshooting
  45. sql query need to retrive the 5th highest salary from a table
  46. RoundUp script
  47. missing paranthesis
  48. what is difference between backup & export
  49. trickey sql query
  50. RCE objects and table
  51. Exclude records from the beginning and end of a table
  52. DBF file insert into oracle table
  53. hello!
  54. Parallel Operation
  55. Idx on Nested table
  56. Installed Oracle ODBC Driver and not able to see in the ODBC Drivers list
  57. INNER JOIN vs Sub-Query (with where clause)
  58. help needed: getting tns-could not resolve service name
  59. Oracle Function
  60. Help Needed : Output is getting wrapped
  61. vtd-xml 1.9 released
  62. Using For...Loop
  63. find mistake... Trigger
  64. 2 Foreign Keys on 1 column
  65. Pls Help: I want to include the date stamp in Subject of mail
  66. solve the query for me please
  67. For.....loop
  68. how can I create Infinite number....
  69. Using DECODE function......
  70. insert into table
  71. please help me to solve the query
  72. please find out mistake.
  73. First n interger
  74. Need Help!!!!!!!!! Using case statement.
  75. No privileges on tablespace 'SYSTEM'
  76. Need an query in Oracle equivalent to SQL
  77. trigger
  78. Similar Query in Oracle to declare a variable table.
  79. Oca(fundamentals 1)
  80. Oem
  81. SPfile Error
  82. Sql* Plus
  83. Developer9i Icon inserting problem
  84. Best Book Name for Oracle9i
  85. Creating the my own account in Oracle9i
  86. Oracle report export xls
  87. Shell Scripting in UNIX environment for Oracle Database
  88. Query on Trigger
  89. What is pragma...
  90. Oracle database access
  91. Materialized View
  92. Delete_DML
  93. ora-00600 [12700]
  94. Data Dictionary for Columns in all Table of a user
  95. Dependencies in plsql
  96. Developer9i Report
  97. Unexpected Resulf
  98. Doubt in sql query
  99. Pass large amounts of text to a stored procedure written in java
  100. Developer 9i Reports
  101. init.ora file
  102. Oracle Reports Down/Across Print Direction
  103. How to Rollback between two different DB in ORACLE?
  104. permanent to temporary
  105. data dictionary views
  106. how to mount datafiles in newely installed oracle
  107. Import and Export of data from Excel to oracle
  108. tablespaces
  109. creating forms in oracle
  110. creating forms in oracle
  111. How to save an MS Word/Excel file in database?
  112. triggers
  113. multiple foreign keys on same column
  114. How to generate osntab.o?
  115. ColdFusion / Oracle 9i Intermedia application errors
  116. updation in object databases
  117. Database fragmentation
  118. Help w/ SQL / Oracle - Building Tables?
  119. New to SQL - Help with Building Tables/Fields!
  120. Upload And Download Pdf Files From Oracle Database Table
  121. new 2 oracle
  122. i want to calculate tax amount
  123. How to write a calendar with pl/sql?
  124. Alignment problem in 10g
  125. clustered and non clustered indexes
  126. can I use a query as a variable?
  127. internet error message (oracle 9i)
  128. Best naming convention in Oracle Development
  129. I want to update a field of a table from other table on Run_time.
  130. time based triggers
  131. Orcle Forms and Reports for a Beginner
  132. write a package in pl/sql that reads a sql query, encrypt each row and write to text
  133. I want to update a field of a table from other table on Run_time.
  134. Database Error
  135. How to select a WHERE condition depending on another cond
  136. want to update records of 2nd table when i insert values in 1st table
  137. How can I list all users using a particular Tablespace
  138. out of memory oracle 9i
  139. migration from Oracle 8i to 9i
  140. Restore DBF files
  141. real challenge!
  142. missing right parenthesis
  143. Oracle installation
  144. got an error message " ORA -12541 :TNS no Listener" while try to log in to Toad
  145. how to find particular char in entire field ?
  146. From Oracle To Word
  147. Change system date with Oracle sql statement
  148. DB2 to Oracle migration
  149. Problem installing Oracle 9i in Windows XP
  150. Transaction Control
  151. Return MIN and Max for a particular subset
  152. Oca
  153. How to update a set of characters from a given number of char ?
  154. problem with 2 not null fileds on one table
  155. Urgent:Problem with Partitioned Tables
  156. bulk collect
  157. bulk collect
  158. Oracle insensitivity
  159. Sql tuning
  160. How to check a grant
  161. Oracle configuration
  162. is oracle a MS Access like software
  163. Help Required in Query
  164. Inserting into Oracle table from MsAccess using VBA
  165. How to pass Collection Types(Table of Object) present in Oracle Procedure.
  166. Install Oracle Discoverer on Web
  167. oracle 8i not functioning on XP
  168. Having problems with printing using triggers
  169. Displyaing Datatypes in SQL query?
  170. Help needed querying data between two dates!!!!
  171. Forum for DB2 related queries
  172. chart wizard (report builder)
  173. Query to eliminate dulicate rows
  174. Query to find the third largest row in a table
  175. Oracle version 9.2 - Discoverer Version ???
  176. List of all views created upon a specific table
  177. help with querying dates
  178. DELETE query in Multi Threads
  179. Graph Problem.
  180. How to connect oracle with php
  181. Help needed Regardig User_constarint tables
  182. getting distinct multipe coloumn list from duplicate row column data
  183. Exporting to Excel
  184. DISTINCT ON function in toad
  185. how to make simple calculation in oracle
  186. Oracle 10g installation problem on SuSE 9.0 linux
  187. Problems in installing Oracle 9i database on Linux
  188. Basics
  189. sqlldr
  190. Purging records
  191. RUN_REPORT_OBJECT_PROC must be declared
  192. Is oracle a platform like a MS Access
  193. SQL SERVER ---- Oracle Migration????/?
  194. Group functions
  195. help regaring the foreign key
  196. how to create new database
  197. Calling scripts in different server from Oracle9i database
  198. send a mail if insert operation fails
  199. Difference between oracle client and oracle server
  200. varchar2
  201. cursors
  202. HELP - SELECT...INTO Variable ---> More than one variable???
  203. worksheet to a table
  204. new user
  205. Oracle: Grouping by all the columns of a table
  206. error when I try to create a type
  207. ora 12541 :no listener
  208. ora:12560
  209. Trigger - Data from Multiple table
  210. HELP!! errors managing. i need help.
  211. regarding sqlplus querry processing
  212. PL/SQL Developer - question about the Editor preferences
  213. How to Initialize Collection Types/Object Types in Oracle
  214. How to determine if the table exist in oracle?
  215. ORA-06531: Reference to uninitialized collection
  216. Win2K and Win XP based POS registers cannot communicate wih server
  217. Help with Date Conversion to Session Timezone
  218. pls help me. i am an new member of this site
  219. ORA-01555: snapshot too old: rollback segment number 24 with name "ROLL24" too small
  220. regarding on delete set null ....
  221. Wrong number or types of arguments
  222. Urgent Requirement For Oracle Crm Consultants
  223. Urgent Requirement For Oracle Crm Consultants
  224. How to change Oracle Port No.
  225. migration of database
  226. query
  227. update from excel file
  228. How to use two tables in view? which is referred in the block of the forms
  229. prompt the user to insert a new customer
  230. Oracle 9i
  231. how to divide a column into two
  232. how manage errors in Unix's scripts for oracle connection and procedure's calls
  233. SQL Update statement for 50,000 entries
  234. How Can implement One to many Relationship With oracle object
  235. Creating Forms List Item
  236. i dont know why it keep coming up missing expression in line 1
  237. Connectivity Problem
  238. 3 Oracle forms developer Questions
  239. Inner Pl/SQL error in Oracle 10Gr FormsBuilder
  240. Sql query help
  241. How Can We Select More Than One Node in a Tree
  242. DIFFERENCE BETWEEN ORACLE 8i & ORACLE 9i
  243. pl/sql(help me please) insert into
  244. problem to call a stored procedure from unix using a script
  245. Recover deleted rows from a table from archive logs?
  246. PL/SQL Developer Editor Preferences
  247. Datbase Level DML Trigger
  248. Need To Create Tablespace,Alter TableSpace,Drop Tablespace
  249. HELP Needed !
  250. Forum enhancement
  251. Oracle Export/Import in XML/ASCII format
  252. TNS-12560: TNS:protocol adapter error
  253. Timezone Conversions - URGENT
  254. unix script ti connect to an oracle database and call a stored procedure
  255. sequence key only be primary key?
  256. Distinct function in TOAD
  257. data block corruption
  258. How can I connect Oracle with C# and OCI!!!
  259. problem in math formula
  260. insert into table
  261. alter table
  262. extract data from dmp file
  263. How do I use count on relationships?
  264. stored procedure
  265. Create a Trigger to retrieve ROWID & pass to a Procedure... Where do I begin ?
  266. IP address of the machine from which INSERT is given
  267. View Creation Syntax Issue?
  268. Install Oracle 8.1.x on P4 Machine
  269. ORA-214 control file mismatch
  270. Migration of Data
  271. Exception in DB2 sql stored procedures.
  272. New line in procedure.
  273. Procedure to load data from XML file to Oracle Table
  274. trnafer date in oracle from text file
  275. display data with Stored procedure
  276. Creating a .bat file
  277. Simple Select Qry
  278. Oracle client software for HPUX 10.20
  279. How to Reduce the size of tablespace?
  280. Costs of databases
  281. Oracle 9i Jobs on Unix Server
  282. Coding for list item in Oracle developer
  283. Machine from which the transaction is initiated???
  284. least currency notes
  285. Errors...Wrong numbers or typed of arguments in call
  286. ERROR :Trigger is mutating, trigger/function may not see it
  287. forms
  288. Error mesage ORA12636
  289. Parameter in a Query???
  290. Cut testing time in half
  291. Error in writing to directory /tmp/Orainstall .....
  292. SELECT from multiple schema's
  293. Creating partioned tables
  294. Calculating age in Oracle sql....
  295. help me to find the Host string for Oracle
  296. Execution time of a Query -- URGENT
  297. Trigger to update System Date after insert
  298. Oracle Http Server
  299. One service missing: OracleHome81TNSListener
  300. Rollback whole procedure
  301. oracle 9i installation on debian linux
  302. Learning to build a natural dynamic cursor in PL/SQL
  303. orapwd file
  304. Substitution variable prob?
  305. Insert statement with related tables.
  306. Open Cursors value in Oracle database running on Windows
  307. Tracking
  308. submitting a job
  309. Vaildating data in PL/SQL
  310. ORA-00600: internal error code
  311. DB2 Isolation level?
  312. Retrive Sys Pwd
  313. starting user and password!
  314. Can any one help me in [displaying the execution time from db2udb CLP]
  315. internal error code: core dump
  316. Sequence Object
  317. a challenging query
  318. checkponit
  319. orapwfile
  320. inserting .xls file into oracle.
  321. deleting from 2 tables in one Query
  322. Oracle 9i on windows 2003 server
  323. Oracle Warehouse Builder
  324. Update Statment - Help wanted
  325. sqlldr
  326. Oracle Installation Problem.
  327. Copy data to another schema
  328. HTMLDB / SQL Question
  329. db2 catalog question
  330. cost of an SQL Query
  331. Error Logging into Oracle
  332. Oracle Reserved Characters
  333. Metalink Id
  334. URGENT help needed!! TNS issue
  335. Compatibility with 8i, VFP 9 and Win XP
  336. OLEDB error with c#
  337. I need to use an Oracle program for administration and book-keeping
  338. Dbms
  339. E Mail Using PL/SQL Procedure
  340. Optimizing the Query
  341. New project
  342. Setting maximu open cursor limit using OCI
  343. Passing String Variable in FOR LOOP
  344. Needed Query for the database
  345. Oracle beta exams - Exam# 1Z1-221:Oracle Inventory Management 11i Fundamentals
  346. connectivity from lotus notes to DB2
  347. how to import data from csv file into oracle9i very very urgent
  348. sqlplus exit statement prematurely terminates unix script
  349. SMS Data base for Tertiary Institutions
  350. Oracle DBA
  351. oracle tables
  352. Loading data into CSV files
  353. PL/SQL How to user "continue" in a FOR LOOP
  354. Problem in Bulk insert over a dblink
  355. Throw out duplicate results.
  356. Concat in a where clause
  357. how to create reports for all the users to see how many user entered dail
  358. plz help me to create username and password for ma oracle software
  359. comp.database.ibm-db2 and comp.databases.oracle
  360. Need to select multiple values from one column
  361. ORA-07445: exception encountered: core dump [] [] [] [] [] []
  362. Insert Select to same table in oracle
  363. Limitting by data type Date
  364. ora-01033 oracle initialization or shutdown in process
  365. ora-01033 oracle initialization or shutdown in process
  366. creation of database manually
  367. QuickTestPro questions related to ORACLE application
  368. Get link
  369. rep-501
  370. unable to access the function of other database
  371. Analytical function with where clause
  372. Stored Procedures and COBOL
  373. Finding all tables with a particular field?
  374. Shell script
  375. need some notes about sql loder
  376. How to access oracle in Nodes for a firewalled XP Server in LAN
  377. Help Scripting?
  378. Exercise... from vb to Oracle
  379. Can Java Store Procedure increase performance?
  380. How to update table in for loop with disturbing existing values
  381. Creating Multiple User
  382. Frm-41213 Unable To Connect Report Server
  383. How to insert null value in date column in oracle using visual basic textbox
  384. error-ora-01304 its very URJENT
  385. How to debug a Store Proc in Oracle using TOAD
  386. Urgent Assistance with SQL Query (Please)
  387. Oracle Portal
  388. Procedure in Oracle10g for Run_Product_Report
  389. reduentency
  390. SQL select help
  391. SQL select help
  392. To get n rows for a given attribute
  393. Transfer database
  394. odbc memory use
  395. Oracle Forms and object relational model
  396. IO Exception
  397. oracle error
  398. scheduling external jobs like shell scripts
  399. Oracle Connection
  400. XML Null Node Updation
  401. URGENT- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  402. Urgent----------------please Give Some Solution On This
  403. URGENT----------------blank field and non blank field
  404. open form from the other form
  405. Disadvantages of using cache in oracle
  406. Upsert operation
  407. Update
  408. Update Query for Object Table
  409. backwards LIKE matching
  410. backwards LIKE matching
  411. Procedure Vs Function
  412. Views and performance
  413. Oracle DBA Studio help
  414. Mark Burris
  415. Mark Burris
  416. Steps to install oracle9i on suse 10,Mandrake 10,fedoracore 4
  417. Check constraint
  418. oracle ocp exams guide ?
  419. Regarding UTL_FILE Package in PLSQL
  420. Installing on Mac Os
  421. current sql
  422. Oracle Standby databse
  423. reading oracle schema(structure)...
  424. converting date field to timestamp or viceversa....
  425. Difference between Varchar and nvarchar
  426. Oracle Performance on multiple joins
  427. update and insert
  428. oracle 11i installation
  429. Oracle guides for exams
  430. Oracle-triggers
  431. Logon info
  432. HOW ORACLE 9i WORK WITH XP?
  433. domain knowledge
  434. Oracle Not Available
  435. Oracle-update table values
  436. how to get present time and date?
  437. How to diagnose inaproppriate Oracle SGA component size?
  438. db link hangs after a while
  439. ORA-12560: TNS: protocol Adapter Error
  440. conversion functions
  441. server configuration
  442. RAC nodes regularly freezes for about 10 seconds
  443. How to create external table with CLOB columns?
  444. How 2 split priority, reports low, transactions fast
  445. 7.3 on 03 server
  446. Determine record number in oracle forms
  447. to find scripts - 'export info party(customer)'
  448. Certification
  449. Missing iamodapp.so ( Oracle 9.20 /Linux)
  450. SELECT ... WHERE column LIKE parameter||'%'
  451. updating a table using other table values
  452. Help for Backup Online
  453. Does Oracle Apllication server is free?
  454. abt mapping table????in migration data
  455. TEMP tablespace
  456. oracle 9i username & password
  457. Oracle PL/SQL question
  458. Oracle lite
  459. Ora-12560
  460. Accpac 5.4 oracle10g connection.
  461. SQL NET Configuration issue
  462. Web Application using Oracle Forms 9i
  463. Trying to write a view using union statement
  464. OBE-15952 Error
  465. Insert
  466. How can i Install Developer6i with Oracle8i?
  467. Oracle dblinks
  468. IBYKUS Omega9 - New Oracle SQL Developertool
  469. ora-01031 insufficient priviledge
  470. External Tables w/ non ASCII chars
  471. convert sql mysql to oracle
  472. oracle object relatedquery
  473. history
  474. load from file doc into table
  475. Trigger to reflect changes
  476. How to set the server of oracle automatically shutdown
  477. Handling expired passwords in Forms v.6.0.5
  478. list box
  479. PL/SQL - Can function have OUT, IN OUT parameter ?
  480. OCI.dll not found !
  481. chem draw structure in orcale
  482. Need some guidance on my situation
  483. Performance Related Clarification.
  484. Oracle CBT
  485. rman
  486. Database configuration Error
  487. import testcases from xls document to Oracle DB
  488. Really REALLY simple question (I think)
  489. Which database design tool
  490. .NET using ODP and the 10g Instant Client
  491. Copy Oracle / Apps installations
  492. Oracle Schema
  493. converting comma separated values into rows in oracle
  494. ORA-00937 not a single group group function
  495. Oracle Group Group error
  496. Access to Oracle Insert solutions
  497. Need help with attendance project in oracle9i
  498. Autogenerate partitions on table
  499. SQL 3 or 4 trial key needed
  500. UNIQUE CONSTRAINT ERROR
  501. Basic Questions
  502. Catching "ORU-10027: buffer overflow" exceptions in PL/SQL
  503. OLEDB and Oracle XE ?
  504. Patience for a Oracle Noobie
  505. How to connect to Oracle database from unix prompt
  506. Procedure
  507. Slow query on date field via views
  508. Complex update query
  509. Crystal report db problem
  510. current sql running
  511. .NET Reporting against and Orcale Database
  512. <REQ> oracle lite info
  513. S: Biomega Mark Newson MN03
  514. Obtaining a Column Which has MAX in Another
  515. CPU skyrockets during contention
  516. writing records while doing select.
  517. Oracle credential retrievial failed error
  518. SQL Update Tables
  519. Multi Master Databases
  520. Constraints on the time stamp column or date
  521. Oracle DB Link issues
  522. spool file: saing to non default location
  523. Request for Resume's - Siebel Production Engineer IV
  524. deducing ranges in SQL
  525. Oracle OLEDb
  526. What is it like to work with Oracle?
  527. Loading Data from SQL-SERVER 2000 To ORACLE 9i
  528. Equivalent of Hierarchy SQL in Oracle
  529. Equivalent of Hierarchy SQL in Oracle
  530. Explain Plan returns only one index usage
  531. Great Job Board
  532. A great onestop spot
  533. Best Job Search Site...
  534. ASP - Reading blob from Oracle to ASP
  535. Generating CREATE TABLE statements
  536. Several question about select.
  537. Oracle 9.2 - c precompile undefined _sqlcxt
  538. c/Oracle on windows-undefines sqlcxt
  539. Instantclient 10 on Solaris 10
  540. Suggest books for beginner, and good as a reference for later use
  541. Remove all tables for user with one SQl statement?
  542. validation testing -- use TPC-C? (or what?)
  543. Oracle Forms - chat tool
  544. Need Media recovery Help
  545. US-VA: Sr.Oracle ATS/Testing LoadRunner QuickTest Pro # 1129R1
  546. Type for COUNT() as VAR ?
  547. Using FORALL with associative arrays
  548. Oracle Driver question
  549. INSTR and string length problem
  550. how to connect to an oracle database from a java source