Oracle (PL/SQL) fuction won’t work
Problem solved!!! All I needed to do was to (using the Oracle sqlDeveloper) stick my code to the left margin of the window that had the code!!! I really don’t understand why, maybe a compiler error??? For all I care, it works now….
View Answer
| June 6, 2011 8:55 AM
APEX, Oracle, Oracle Apex, PL/SQL
Problem solved!!! All I needed to do was to (using the Oracle sqlDeveloper) stick my code to the left margin of the window that had the code!!! I really don’t understand why, maybe a compiler error??? For all I care, it works now….
View Answer
| June 6, 2011 8:55 AM
APEX, Oracle, Oracle Apex, PL/SQL
Free IT Book: Building Applications in the Cloud
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Running a query in Oracle 10g
In Sql Developer, there is a “Connections” tab on the left hand side. You need to create a new connection there by right-clicking on “Connections”, selecting “New Connection” and filling in the server name/address, port, and database SID. You can also use your TNS configuration and avoid entering the above details which are already included [...]
View Answer
| June 1, 2011 2:59 PM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer
In Sql Developer, there is a “Connections” tab on the left hand side. You need to create a new connection there by right-clicking on “Connections”, selecting “New Connection” and filling in the server name/address, port, and database SID. You can also use your TNS configuration and avoid entering the above details which are already included [...]
View Answer
| June 1, 2011 2:59 PM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer
Oracle 6i parameter value
Your LOV record group should include a condition (WHERE CLAUSE) to include only records matching the desired date range.
View Answer
| May 30, 2011 3:15 PM
D2K, D2K 6i, D2K Forms, Oracle 6i, Oracle Forms 6i
Your LOV record group should include a condition (WHERE CLAUSE) to include only records matching the desired date range.
View Answer
| May 30, 2011 3:15 PM
D2K, D2K 6i, D2K Forms, Oracle 6i, Oracle Forms 6i
Oracle fails due to disk partition is full. Data now is corrupted.
I’ve been lucky and not hit that error. I would take a look at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm
View Answer
| May 25, 2011 11:19 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
I’ve been lucky and not hit that error. I would take a look at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm
View Answer
| May 25, 2011 11:19 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
Free IT Book: Governing Shared Services On-Premise and in the Cloud
Spam removed.
View Answer
| May 23, 2011 1:26 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Spam removed.
View Answer
| May 23, 2011 1:26 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Oracle Forms 6i application to web based application
In summary, you will have to move to at least Forms 9i (well, you can move your forms to the web with 6i as well), and you will need an application server. Depending on the type of operations the form performs, it could be as easy as re-compiling it, but most of the times some [...]
View Answer
| May 19, 2011 1:27 PM
Forms Creation, Oracle applications, Oracle Forms 6i, Web-base apps
In summary, you will have to move to at least Forms 9i (well, you can move your forms to the web with 6i as well), and you will need an application server. Depending on the type of operations the form performs, it could be as easy as re-compiling it, but most of the times some [...]
View Answer
| May 19, 2011 1:27 PM
Forms Creation, Oracle applications, Oracle Forms 6i, Web-base apps
Completed IT Knowledge Exchange Profile? Earn points!
http://itknowledgeexchange.techtarget.com/profile/Batye/
View Answer
| May 18, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
http://itknowledgeexchange.techtarget.com/profile/Batye/
View Answer
| May 18, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL Oracle for rolling the period return
Depending on the database version, you could use an ugly query like this: <pre>WITH temp AS (SELECT entered,ADD_MONTHS(entered,DECODE(MOD(TO_CHAR(entered,’mm’),3),0,0,3-MOD(TO_CHAR(entered,’mm’),3))) next FROM (SELECT TO_DATE(’01′||’&per’,'ddmonyyyy’) entered FROM dual) t) SELECT TO_CHAR(ADD_MONTHS(next,-12),’monyyyy’) period,1 FROM temp UNION SELECT TO_CHAR(add_months(next,-9),’monyyyy’),2 FROM temp UNION SELECT TO_CHAR(add_months(next,-6),’monyyyy’),3 FROM temp UNION SELECT TO_CHAR(add_months(next,-3),’monyyyy’),4 FROM temp UNION SELECT TO_CHAR(entered,’monyyyy’),5 FROM temp ORDER BY 2;</pre> Maybe [...]
View Answer
| May 16, 2011 4:59 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Depending on the database version, you could use an ugly query like this: <pre>WITH temp AS (SELECT entered,ADD_MONTHS(entered,DECODE(MOD(TO_CHAR(entered,’mm’),3),0,0,3-MOD(TO_CHAR(entered,’mm’),3))) next FROM (SELECT TO_DATE(’01′||’&per’,'ddmonyyyy’) entered FROM dual) t) SELECT TO_CHAR(ADD_MONTHS(next,-12),’monyyyy’) period,1 FROM temp UNION SELECT TO_CHAR(add_months(next,-9),’monyyyy’),2 FROM temp UNION SELECT TO_CHAR(add_months(next,-6),’monyyyy’),3 FROM temp UNION SELECT TO_CHAR(add_months(next,-3),’monyyyy’),4 FROM temp UNION SELECT TO_CHAR(entered,’monyyyy’),5 FROM temp ORDER BY 2;</pre> Maybe [...]
View Answer
| May 16, 2011 4:59 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Free IT Book: The RAILS 3 Way
Don’t know, link won’t open
View Answer
| May 12, 2011 5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Don’t know, link won’t open
View Answer
| May 12, 2011 5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Process Execution error – CD
This is not an IBM message file, so it belongs with some software package you have on your system. You need to determine what that is and then look into their manuals or contact their help desk to get more information. I’m guessing NDM is Network Data Movers. Good luck
View Answer
| May 10, 2011 12:53 PM
Business Process Execution Language, Process Manager, V6R1
This is not an IBM message file, so it belongs with some software package you have on your system. You need to determine what that is and then look into their manuals or contact their help desk to get more information. I’m guessing NDM is Network Data Movers. Good luck
View Answer
| May 10, 2011 12:53 PM
Business Process Execution Language, Process Manager, V6R1
Open IT Forum: Share networking resources, earn knowledge points!
A little more information: We’re looking to do a roundup of recommended reading for networking professionals. If you have books or other resources you’ve found helpful, either as a general “cookbook,” getting up to speed on a particular topic, or even prepping for a certification exam, it would be great if you could share the [...]
View Answer
| May 5, 2011 3:16 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
A little more information: We’re looking to do a roundup of recommended reading for networking professionals. If you have books or other resources you’ve found helpful, either as a general “cookbook,” getting up to speed on a particular topic, or even prepping for a certification exam, it would be great if you could share the [...]
View Answer
| May 5, 2011 3:16 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Spring Cleaning: Free IT Book(s) Giveaway!
some of the Apple Itunes account got hacked I just find out my itunes account got hacked on the 05/01/11 when I did quick search online http://thenextweb.com/apple/2010/07/04/appstore-hack-itunes/ anyway I change my password and report this problem to apple but I would suggest to all members on itknowledgeexchange.techtarget to check the itunes account for unauthorized purchases [...]
View Answer
| May 3, 2011 2:57 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
some of the Apple Itunes account got hacked I just find out my itunes account got hacked on the 05/01/11 when I did quick search online http://thenextweb.com/apple/2010/07/04/appstore-hack-itunes/ anyway I change my password and report this problem to apple but I would suggest to all members on itknowledgeexchange.techtarget to check the itunes account for unauthorized purchases [...]
View Answer
| May 3, 2011 2:57 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
sql statement…..
Hello, Please write to my email address box: (khalifamorin@yahoo.com) My name is Morin, a good looking girl. I became interested in you after going through your profile today and i wish to continue relationship with you which if nature will permit we have a long way to go. I have a special reason of contacting [...]
View Answer
| May 2, 2011 11:16 PM
Oracle 11g, SQL Server, SQL statement
Hello, Please write to my email address box: (khalifamorin@yahoo.com) My name is Morin, a good looking girl. I became interested in you after going through your profile today and i wish to continue relationship with you which if nature will permit we have a long way to go. I have a special reason of contacting [...]
View Answer
| May 2, 2011 11:16 PM
Oracle 11g, SQL Server, SQL statement
Oracle 10g form not running
Take a look at this similar question: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/oracle-10-g-developer/”>oracle 10 g developer </a> ————— By Orangehat: Assuming you are running Win7 x64. In Oracle Forms Designer it will by default load the x64 IE, you need to pick the x32 version. Edit, Preferences, Runtime, Change Web Browser location to the one in C:program files (x86)Internet [...]
View Answer
| May 2, 2011 8:18 PM
IE8, Oracle 10g, Oracle 10g forms, Oracle Forms
Take a look at this similar question: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/oracle-10-g-developer/”>oracle 10 g developer </a> ————— By Orangehat: Assuming you are running Win7 x64. In Oracle Forms Designer it will by default load the x64 IE, you need to pick the x32 version. Edit, Preferences, Runtime, Change Web Browser location to the one in C:program files (x86)Internet [...]
View Answer
| May 2, 2011 8:18 PM
IE8, Oracle 10g, Oracle 10g forms, Oracle Forms
Best Integration options for Linux membership in Active Directory
Hello, Please write to my email address box: (khalifamorin@yahoo.com) My name is Morin, a good looking girl. I became interested in you after going through your profile today and i wish to continue relationship with you which if nature will permit we have a long way to go. I have a special reason of contacting [...]
View Answer
| May 2, 2011 1:32 AM
Active Directory, Active Directory 2008, Linux, Linux servers, Oracle, RedHat, RHEL
Hello, Please write to my email address box: (khalifamorin@yahoo.com) My name is Morin, a good looking girl. I became interested in you after going through your profile today and i wish to continue relationship with you which if nature will permit we have a long way to go. I have a special reason of contacting [...]
View Answer
| May 2, 2011 1:32 AM
Active Directory, Active Directory 2008, Linux, Linux servers, Oracle, RedHat, RHEL
Free IT Book: Dynamic Tracing
Cool
View Answer
| April 28, 2011 6:02 AM
Desktop virtualization, FreeBSD, Giveaways, IT answers, IT Books, Mac OS X, Oracle, Solaris, Storage virtualization
Cool
View Answer
| April 28, 2011 6:02 AM
Desktop virtualization, FreeBSD, Giveaways, IT answers, IT Books, Mac OS X, Oracle, Solaris, Storage virtualization
Tell your friends about IT Knowledge Exchange, earn 100 points!
tweeted IT Knowledge Exchange on Twiter and Facebook.
View Answer
| April 27, 2011 8:32 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
tweeted IT Knowledge Exchange on Twiter and Facebook.
View Answer
| April 27, 2011 8:32 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
10 Chances to Win $100
The race is on!!!
View Answer
| April 26, 2011 5:51 PM
Amazon.com, AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Community, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The race is on!!!
View Answer
| April 26, 2011 5:51 PM
Amazon.com, AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Community, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Oracle 10g to SQL Server 2008
Yes, you can use SQL Server Integration Services to do this. The designer can be found in the start menu under “SQL Server Business Intelligence Development Studio” in the same folder that the SQL Server Management Studio can be found in. You’ll want a data pump task and within it just a OLEDB source and [...]
View Answer
| April 21, 2011 4:50 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix
Yes, you can use SQL Server Integration Services to do this. The designer can be found in the start menu under “SQL Server Business Intelligence Development Studio” in the same folder that the SQL Server Management Studio can be found in. You’ll want a data pump task and within it just a OLEDB source and [...]
View Answer
| April 21, 2011 4:50 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix
