SQL Oracle for rolling the period return
Hi , i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query . return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]
Answer Question
| May 16, 2011 5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Hi , i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query . return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]
Answer Question
| May 16, 2011 5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Completed IT Knowledge Exchange Profile? Earn points!
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]
Answer Question
| May 18, 2011 2:26 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
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]
Answer Question
| May 18, 2011 2:26 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
Process Execution error – CD
Receive the below CD error: from one of the process when tried NDM CD error CDE0200 Escape 40 Message . . . . : Process execution not allowed. The Process Manager is not allowing execution of processes at this time. Session limits may have been met, or process execution may have been explicitly [...]
Answer Question
| May 13, 2011 1:25 PM
Business Process Execution Language, Process Manager, V6R1
Receive the below CD error: from one of the process when tried NDM CD error CDE0200 Escape 40 Message . . . . : Process execution not allowed. The Process Manager is not allowing execution of processes at this time. Session limits may have been met, or process execution may have been explicitly [...]
Answer Question
| May 13, 2011 1:25 PM
Business Process Execution Language, Process Manager, V6R1
Will you be at Interop Las Vegas next week?
Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you’re thinking of the show and the direction of networking in general! Let him know if you’ll be [...]
Answer Question
| May 6, 2011 7:57 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Interop, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you’re thinking of the show and the direction of networking in general! Let him know if you’ll be [...]
Answer Question
| May 6, 2011 7:57 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Interop, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: Share networking resources, earn knowledge points!
It’s Networking month at IT Knowledge Exchange, and we’re looking for your best resources on the subject. Share networking guides, blogs, tips, books, and great Twitter pros to follow! For each category you contribute to, we’ll give you 25 knowledge points, good toward our latest contest.
Answer Question
| May 5, 2011 3:52 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
It’s Networking month at IT Knowledge Exchange, and we’re looking for your best resources on the subject. Share networking guides, blogs, tips, books, and great Twitter pros to follow! For each category you contribute to, we’ll give you 25 knowledge points, good toward our latest contest.
Answer Question
| May 5, 2011 3:52 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
Contest Bounty: Earn 500 knowledge points!
You could earn 500 knowledge points for sharing your story. Simply read this blog post and then share your story of survival. If we publish your story, we will first ask permission and compensate you with 500 knowledge points to go toward our current IT Knowledge Exchange contest . Good luck!
Answer Question
| May 26, 2011 1:31 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, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
You could earn 500 knowledge points for sharing your story. Simply read this blog post and then share your story of survival. If we publish your story, we will first ask permission and compensate you with 500 knowledge points to go toward our current IT Knowledge Exchange contest . Good luck!
Answer Question
| May 26, 2011 1:31 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, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Spring Cleaning: Free IT Book(s) Giveaway!
This week’s IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three answers [...]
Answer Question
| May 3, 2011 2:24 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
This week’s IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three answers [...]
Answer Question
| May 3, 2011 2:24 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
Oracle 10g form not running
when I design the form in 10g and try to run on browser IE8, it is not responding. only Oracle Forms caption is disply on browser.
Answer Question
| May 2, 2011 6:53 AM
IE8, Oracle 10g, Oracle 10g forms, Oracle Forms
when I design the form in 10g and try to run on browser IE8, it is not responding. only Oracle Forms caption is disply on browser.
Answer Question
| May 2, 2011 6:53 AM
IE8, Oracle 10g, Oracle 10g forms, Oracle Forms
Best Integration options for Linux membership in Active Directory
We’re a heavy Microsoft shop and I’m standing up our first Linux servers and wish to intergrate them into Active Directory. We’re using Red Hat and the Oracle Unbreakable Linux (Oracle sponsered RHEL) and I want to intergrate the systems into AD for ease of control and to ensure our existing IT policies can be [...]
Answer Question
| May 3, 2011 5:45 PM
Active Directory, Active Directory 2008, Linux, Linux servers, Oracle, RedHat, RHEL
We’re a heavy Microsoft shop and I’m standing up our first Linux servers and wish to intergrate them into Active Directory. We’re using Red Hat and the Oracle Unbreakable Linux (Oracle sponsered RHEL) and I want to intergrate the systems into AD for ease of control and to ensure our existing IT policies can be [...]
Answer Question
| May 3, 2011 5:45 PM
Active Directory, Active Directory 2008, Linux, Linux servers, Oracle, RedHat, RHEL
Tell your friends about IT Knowledge Exchange, earn 100 points!
Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!
Answer Question
| May 27, 2011 7:55 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
Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!
Answer Question
| May 27, 2011 7:55 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
Free IT Book: Dynamic Tracing
This week’s free IT book, DTrace, covers dynamic tracing in Oracle Solaris, Mac OS X, and FreeBSD. What can you learn from DTrace? Learn by example, with ample commands and “easy-to-adapt, downloadable D scripts. These concise examples generate answers to real and useful questions, and serve as a starting point for building more complex scripts. [...]
Answer Question
| April 28, 2011 2:54 PM
Desktop virtualization, FreeBSD, Giveaways, IT answers, IT Books, Mac OS X, Oracle, Solaris, Storage virtualization
This week’s free IT book, DTrace, covers dynamic tracing in Oracle Solaris, Mac OS X, and FreeBSD. What can you learn from DTrace? Learn by example, with ample commands and “easy-to-adapt, downloadable D scripts. These concise examples generate answers to real and useful questions, and serve as a starting point for building more complex scripts. [...]
Answer Question
| April 28, 2011 2:54 PM
Desktop virtualization, FreeBSD, Giveaways, IT answers, IT Books, Mac OS X, Oracle, Solaris, Storage virtualization
10 Chances to Win $100
Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering questions and earning points.
Answer Question
| May 2, 2011 1:30 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
Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering questions and earning points.
Answer Question
| May 2, 2011 1:30 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
Temporary Table in Oracle 10g
create global temporary table transaction_tab –on commit delete rows as SELECT * FROM CUSTOMERTELEPHONYSERVICE WHERE 0=1; commit; insert into transaction_tab SELECT * FROM CUSTOMERTELEPHONYSERVICE WHERE CUSTOMERTELEPHONYSERVICEID = 1; select * from transaction_tab; No any row inserted. someone can elaborate how to use temporary table.
Answer Question
| May 2, 2011 5:23 AM
Oracle, Oracle 10g, Oracle Tables
create global temporary table transaction_tab –on commit delete rows as SELECT * FROM CUSTOMERTELEPHONYSERVICE WHERE 0=1; commit; insert into transaction_tab SELECT * FROM CUSTOMERTELEPHONYSERVICE WHERE CUSTOMERTELEPHONYSERVICEID = 1; select * from transaction_tab; No any row inserted. someone can elaborate how to use temporary table.
Answer Question
| May 2, 2011 5:23 AM
Oracle, Oracle 10g, Oracle Tables
Oracle 10g to SQL Server 2008
Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under [...]
Answer Question
| May 2, 2011 9:01 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix
Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under [...]
Answer Question
| May 2, 2011 9:01 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix
Oracle and form
i made a project in oracle backend and frontend both; how can i install fmx file on others pc and access to oracle?
Answer Question
| May 2, 2011 11:01 AM
FMX, Oracle Database, Oracle Forms, Oracle projects
i made a project in oracle backend and frontend both; how can i install fmx file on others pc and access to oracle?
Answer Question
| May 2, 2011 11:01 AM
FMX, Oracle Database, Oracle Forms, Oracle projects
Activating Oracle Save Button when data is inserted in the text box
i created a form, on the form there are multiple text box and buttons, on the save button i disabled it in the property pallet. i need a code where any text that is being entered in the text box then the save button will be active.
Answer Question
| May 3, 2011 10:15 AM
Oracle, Oracle Forms, Oracle Forms 6i
i created a form, on the form there are multiple text box and buttons, on the save button i disabled it in the property pallet. i need a code where any text that is being entered in the text box then the save button will be active.
Answer Question
| May 3, 2011 10:15 AM
Oracle, Oracle Forms, Oracle Forms 6i
Free IT Book: Why New Systems Fail
This week’s free IT book is Phil Simon’s insider’s guide to successful IT projects, Why New Systems Fail. From the back of the book, “Organizations often lack the necessary framework to minimize the chance of system failure before, during, and after beginning IT projects.” Get the know-how you need to start and successfully deploy your [...]
Answer Question
| February 23, 2012 3:46 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
This week’s free IT book is Phil Simon’s insider’s guide to successful IT projects, Why New Systems Fail. From the back of the book, “Organizations often lack the necessary framework to minimize the chance of system failure before, during, and after beginning IT projects.” Get the know-how you need to start and successfully deploy your [...]
Answer Question
| February 23, 2012 3:46 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…..
Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO “CDAAS”.”INFORMATION” 2 VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”); VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”) * ERROR at line 2: ORA-01722: invalid number
Answer Question
| May 3, 2011 4:27 PM
Oracle 11g, SQL Server, SQL statement
Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO “CDAAS”.”INFORMATION” 2 VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”); VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”) * ERROR at line 2: ORA-01722: invalid number
Answer Question
| May 3, 2011 4:27 PM
Oracle 11g, SQL Server, SQL statement
Installing Windows 2008 recovery console on windows server 2008 server
How do i install the windows 2008 recovery console on a Windows server2008 as a boot option?
Answer Question
| April 15, 2011 7:10 PM
Boot manager, Recovery Manager, Windows Server 2008, Windows Server 2008 Administration, Windows server administration
How do i install the windows 2008 recovery console on a Windows server2008 as a boot option?
Answer Question
| April 15, 2011 7:10 PM
Boot manager, Recovery Manager, Windows Server 2008, Windows Server 2008 Administration, Windows server administration
How to call word file from oracle report/forms 6i
how to call word file from oracle report/forms 6i
Answer Question
| April 12, 2011 5:13 AM
Oracle Forms 6i, Oracle Reports, Oracle Reports 6i
how to call word file from oracle report/forms 6i
Answer Question
| April 12, 2011 5:13 AM
Oracle Forms 6i, Oracle Reports, Oracle Reports 6i
