How to sort a resultset from a ‘group by’ statement
I have written a query like this: select to_char(order_date,’mon-yyyy’) “months”, sum(nob) “number of bags” from p_in where order_date between ’1-apr-11 and ’31-mar-12′ group by to_char(order_date,’mon-yyyy’) The above query returns me a resultset which gives me number of bags sold in every month, but it does not sort the month in their chronological order.I want to [...]

Answer Question   |  March 11, 2013  4:20 AM
Oracle 11g, Oracle 11g Database, Oracle Query

Problem connecting D2K 6i with database Oracle 11g
Steps to connect D2K 6i, with oracle database 11g.

Answer Question   |  January 11, 2013  10:19 AM
D2K, Oracle 11g, Oracle 11g Database

Oracle Enterprise Manager Console
Pls. can anyone help me with this error masage,whenever i try to start OracleDBConsole from the services. iam using oracle 11g database, windows 7 the error masage is “Oracle could not start OracleDBConsole on the local computer for more information review the Service Event Log. if this is a non-microsoft services, contact the service vendor, [...]

Answer Question   |  June 9, 2011  11:37 AM
Oracle 11g, Oracle 11g Database, Oracle Enterprise Edition, Oracle Enterprise Manager

Need to save dates in Oracle Forms 10g without modifying data values
I am trying to save date and time as entered by the users example: In the insert and update triggers of my block my statement is: :MAIN_BLOCK.USER_DATE := TO_DATE(TO_CHAR(:MAIN_BLOCK.USER_DATE,’DD-MON-YYYY’)||’ ‘||:MAIN_BLOCK.HOUR||’:'||:MAIN_BLOCK.MIN||’:00 ‘||:MAIN_BLOCK.MERIDIAN,’DD-MON-YYYY HH:MI:SS AM’).  I am trying to save :MAIN_BLOCK.USER_DATE as “25-MAY-2010 11:00:00 AM” as the user entered in the form textboxes and is saving “25-MAY-2010 [...]

Answer Question   |  July 15, 2010  3:12 PM
Database management, Oracle 10g Database, Oracle 11g Database, Oracle Forms 10g

Error – FRM-18103:
Hi, I have installed Oracle 11g Database and installed Oracle Developer suite 10g .. Error – FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes. When I try to open Oracle form builder I am receiving ‘FRM-18103:Failed to initialize the Development Environment’ error. Can [...]

Answer Question   |  July 1, 2010  10:29 AM
Forms 10g, Oracle 11g, Oracle 11g Database, Oracle Developer Suite, Oracle Forms Error Messages

what is different from MSSQL, MYSQL and Oracle 11g?
what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

Answer Question   |  January 17, 2010  2:55 PM
MSSQL, MySQL, Oracle 11g Database

ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Answer Question   |  February 3, 2009  3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades