Union All of two tables based on month of a date in Oracle

I have two tables table_a and table_b as below. column invdate is of date datatype and column amount is of number datatype.

table_a

invdate amount
20-01-2021 50
20-01-2021 100
20-02-2021 50
20-03-2021 50

table_b

invdate amount
01-01-2021 250
01-02-2021 300
01-03-2021 40
01-03-2021 50

I am doing a UNION ALL of both tables to get the sum of the amounts based on only month and year.

SELECT to_char(invdate, 'MM-YYYY') as "Date", sum(amount) as "Total" FROM ( SELECT to_char(invdate, 'MM-YYYY'), amount FROM table_a UNION ALL SELECT to_char(invdate, 'MM-YYYY'), amount FROM table_b ) GROUP BY to_char(invdate, 'MM-YYYY') ORDER BY to_char(invdate, 'MM-YYYY') asc; 

to get the final output like below

Date Total
01-2021 400
02-2021 350
03-2021 140

but it gives me the below error.

ORA-00904: "INVDATE": invalid identifier 00904. 00000 -  "%s: invalid identifier" *Cause:     *Action: Error at Line: 10 Column: 18 

What am I doing wrong here?

Cheap Hosting $1 Month | 1 Dollar Hosting – Raisinghost!

If you are a beginner then there is no need to pay a fortune for web hosting if you’re launching a website for your business. There is only one big task to do is, finding out the best cheaper hosting provider who guarantees for best features with money-back protection. Raisinghost is offering cheap hosting $1 month. Its monthly pricing and having 30 days unconditional money-back guarantee. Also one can raise PayPal dispute if they found anything wrong with our service and it will be settled right away.

1 Dollar hosting is monthly-based plan and having the best web hosting features in the industry. We also offer multiple options for the cpanel and reseller hosting services and everyone can find the best budget plan for their requirement. Our reliable service and 24/7 customer support will help you to achieve perfect results.

Special Promo Offer 60% OFF : RS60OFF

Features of 1 Dollar Hosting :

Double Domain Hosting
Unlimited Web Space
Unlimited Bandwidth
Unlimited Email Accounts
Unlimited Parked Domains
1 Addon Domains
6 MySQL Databases
Unlimited Sub Domains
FREE cPanel Control Panel
FREE PHP MyAdmin
FREE AwStats
FREE Auto SSL
FREE Migration
DDOS Protection
99.99% uptime
Softacolous Supported
Tier 1 Technical Support
Free Migration

More Details: https://raisinghost.com/low-cost-hdd-hosting.php

Thank you.

Amsterdam Hosting | Powerful Netherlands Hosting | $1 Per Month – Hostpoco.com!

Our Netherlands, Amsterdam Shared Hosting packages are great for web hosting needs and can help to boost your website with our available locations. Regardless of you are a great website owner or a developer we offer a great lineup of cool shared hosting features to suit your requirement. Our hosting Cpanel comes with max best features, free migration service, ideal for WordPress sites, unlimited email accounts, etc.

The Netherlands shared servers are proactively maintained with around-the-clock monitoring by our techs, you can rest assured that your websites are in good hands.

Powerful Netherlands Hosting Features:

– 20x Faster Loading Speed
– Unmetered Bandwidth
– No Limits for Email Accounts
– Max Sub Domains
– FREE Online Web Sitebuilder
– Unlimited MySql Databases
– FREE Auto SSL
– FREE DDOS Protection
– Netherlands, France, Germany DC Location
– cPanel as control panel
– Free Lets Encrypt SSL
– Instant Activation
– Free Migration
– Max Domain Hosting
– Free Cloudflare

More Info: https://www.hostpoco.com/amsterdam-hosting.php

Have any questions?
Do not hesitate to drop us a support email at sales@hostpoco.com OR visit our page to chat with our Live Chat Support

Follow us on Twitter: https://twitter.com/HostPoco
Find us on Facebook: https://www.facebook.com/HostPoco/

Thank you.

One Dollar Per Month Hosting, Best Web Hosting, #1 Hosting – Hostpoco!

Tired of the poor uptime and slow speed of your website? Is your current host giving you run-around excuses when you ask them about the server-side issues? If it’s true then a hosting switch is required. Hostpoco is a trusted provider and known for using a strong and stable server. If you see, thousands of customers trust Hostpoco, Get our best delivered Shared Hosting and go to the next level, Improve your site SEO and accessibility. MultiPHP and CloudLinux PHP Selector are the best parts available to us.

Our best web hosting service starting from one dollar per month. It’s Cpanel-based and has reasonable pricing. We have multiple billing cycles, ranges, pricing for our shared and reseller hosting service. Also, have half a dollar per month plan for beginners. We love to help our valuable clients and gain trust, 90% of customers are using our service for years, and their website speed is faster than many other leading providers.

Available DC Location’s: USA, Netherlands, France, Germany

Hostpoco Reliable hosting features :

– We never oversell, quality is the top priority
– Full Access, standard web hosting
– Setup fee: Free
– Daily Backups
– cPanel control panel
– Free Account migration.
– Softaculous Autoinstaller: One-Click Installer for WordPress and other content management system
– 99.9% Uptime guarantee
– 24/7/365 support
– Response to ticket: 5 minutes average.
– 30-Day Money-Back Guarantee
– Payment option: Paypal, Card Payment
– Free SSL
– Free support for WordPress, including coding and optimization
– NO HIDDEN FEE

Visit Now: https://www.hostpoco.com/one-dollar-chea…osting.php

Thank you.

Free❤️‍(1 month access-limited: 2 users left) GSA SER Site Lists/Real-Time Updates/Dropbox Auto-Sync

GSA SER Site List | GSA SER Verified list

❤️‍❤️‍Just another 2 Users can join our 1 month Free Trial. Hurry up…..❤️‍❤️‍

The price after the Trial is $ 24.99/month

3 months Access: $ 69.99

6 months Access: $ 139.99

Hi Guys,
As We are Testing our new scraping system, We want to give Dropbox free access to GSA SER forum`s members.
So if you are interested in checking our site lists which are grouped by Platforms(Using GSA SER Platform Identifier) for free(No joking!) just PM me and send me your Dropbox Email.
I will add your Email in Dropbox in less than 12 hours.

PLEASE SEND US FEEDBACK SO WE CAN IMPROVE THE QUALITY (Number of threads + LPM & VPM Included)

Details:

– Folders:

  • All Scraped URLs
  • Low OBL(outbound links<100)
  • Submitted Targets
  • Verified Targets
  • Contextual Targets Added on 11 March. 2021 

– GSA Captcha Breaker Compatible
– Updating in Real-Time Using Dropbox (set once and forget)
– Dedupe Domains (Not URLs!) each 10 Minutes
– Scraping and Identifying around 1,000,000 Links Each Day

10 March. 2021


18 March. 2021

“All Scraped Urls” Folder Details:
UPDATES are Real-Time

Note: ⚡If you are using our site lists, to get higher LPM & VPM, use “All Scraped Urls” and “Submitted Targets” Folders⚡

Currently we are working on Verified Targets and Contextual Targets(Added on 11 March. 2021) to increase the quantity and quality of those links. So it’s OK if these two folders are small. They will become bigger in two weeks. to get higher LPM & VPM in GSA SER take a look at above Note.

Fast WordPress Hosting Starting From $1 Per Month – Raisinghost!

Raisinghost.com goes beyond offering the traditional web hosting services and deals with the wordpress based on the ssd storage. To provide you with Fast WordPress Hosting support, as well as support for other third party scripts such as XenForo, Joomla and more. Helping you focus your time and energy on your online site business and visitors. Our web hosting packages come with great prices starting from $1 Per Month.

50% Off With Annual billing : SPECIAL50

Main Features:
• cPanel Control Panel
• Softaculous Installer
• Paypal and card payment
• Instant Setup
• Daily Backups
• 24/7 Support
• Los Angeles – USA
• WordPress Support
• Free Website Transfer
• 99.9% Uptime Guarantee
• Free SSL Certificate
• Free Migration Service
• 24×7 Live Chat, Ticket Support
• 30 Day Money Back Guarantee

Visit Today : https://raisinghost.com/best-wordpress-hosting.php

Thank you.

Free❤️‍(1 month access – limited) GSA SER Site Lists / Real-Time Updates / Dropbox Auto-Sync

GSA SER Site List | GSA SER Verified list

❤️‍❤️‍Only 25 users can join our Test Program. Hurry up…..❤️‍❤️‍ Left: 11 Users

Hi Guys,
As We are Testing our new scraping system, We want to give Dropbox free access to GSA SER forum`s members.
So if you are interested in checking our site lists which are grouped by Platforms(Using GSA SER Platform Identifier) for free(No joking!) just PM me and send me your Dropbox Email.
I will add your Email in Dropbox in less than 12 hours.

PLEASE SEND US FEEDBACK SO WE CAN IMPROVE THE QUALITY (Number of threads + LPM & VPM Included)

Details:

– Folders:

  • All Scraped URLs
  • Low OBL(outbound links<100)
  • Submitted Targets
  • Verified Targets
  • Contextual Targets Added on 11 March. 2021 

– GSA Captcha Breaker Compatible
– Updating in Real-Time Using Dropbox (set once and forget)
– Dedupe Domains (Not URLs!) each 10 Minutes
– Scraping and Identifying around 1,000,000 Links Each Day

above picture updated on 10 March. 2021

“All Scraped Urls” Folder Details:
UPDATES are Real-Time

Note: ⚡If you are using our site lists, to get higher LPM & VPM, use “All Scraped Urls” and “Submitted Targets” Folders⚡

Currently we are working on Verified Targets and Contextual Targets(Added on 11 March. 2021) to increase the quantity and quality of those links. So it’s OK if these two folders are small. They will become bigger in two weeks. to get higher LPM & VPM in GSA SER take a look at above Note.

Free(1 month access) GSA SER SiteLists / Updated Hourly / Dropbox Auto-Sync

Hi Guys,
As We are Testing our new scraping system, We want to give Dropbox free access to GSA SER forum`s members.
So if you are interested in checking our site lists which are grouped by Platforms(Using GSA SER Platform Identifier) for free(No joking!) just PM me and send me your Dropbox Email.
I will add your Email in Dropbox in less than 12 hours.

$1 hosting per month | linux hosting $1!

$1 hosting per month | linux hosting $1!

Hostbazzar Hosting is pleased to announce the most cheaper, affordable, quality web hosting plans, starting from $1 per month or half dollar per month. These packages are especially suitable for small and medium webmasters or designers or beginners. We have support techs from different locations of the world to make sure that all tickets can be answered and all problems can be resolved in as short time as possible, we have max hold time of 45 mins.

At any time when the need arises, you can initiate chat or can submit ticket. Also we offer 30 days money back policy for clients who are unhappy after using our service.

Promo Code for 50% off : 50HB

Some key Features of our one dollar hosting :

HDD / SSD Max or Unlimited Space
US / France location Servers
cPanel as control panel 
Softaculous App Installer
Unlimited Bandwidth
Unlimited FTP Accounts
Unlimited Databases
Unlimited Subdomains
Unlimited Domains
Unlimited Email Accounts
Easily install WordPress, and other applications
No Setup Fees
Instant Setup
Free SSL
Free Migration
Fast and Stable Network
Privacy Assured
99.9% Guaranteed Uptime
Free & Instant Set-up
24/7 Support
30 Days Money Back Guarantee
The Best Service at a Fair Price

For Order : https://hostbazzar.com/linux_shared_hosting.php

Thanking you.

Best ssd linux reseller hosting | $3.50 Per Month – Raisinghost!

Raisinghost is providing Business Class Web Hosting Solutions for our clients since years. We pride ourselves in customer relations and reliability along with the guarantee to offer you the best service possible to make your online experience profitable and enjoyable, we also offers 30 days money back guarantee with our shared, reseller services.

Our Linux reseller plans are cheaper yet have high resources also we have two types of storage ie HDD and SSD with our reseller services and SSD reseller services are 20x times faster than regular HDD reseller hosting.

Promo Code to get 50% discount : SPECIAL50

Our Features:

– Instant Setup
– Web host manager
– cPanel as control panel
– 30 Days Money Back Guarantee
– Cloud Linux
– Easy Control Panel
– Free DOMAIN
– Softculous (One Click Installation)
– MariaDB (MySQL)
– 24×7 Support
– FREE Unlimited SSL Certificates
– MultiPHP Selector
– PHPMyAdmin
– Remote daily backups
– Free Websites Migration
And MUCH MORE….

https://www.raisinghost.com/cheap-ssd-li…seller.php

Thank you.