In Netezza, with in a string every first letter after space will be turned into an upper case and remaining letters will be into lowercase.
In Orcale, it'll converts the very first letter after space or any special symbol into uppercase and remaining letters into lower case.
In Teradata , we don't have this function.
Example:
In Netezza:
Select INITCAP ('ONLINE jOBS');
output: Online Jobs
Select INITCAP ('ONLINE-JOBS') ;
output: Online-jobs
In Oracle:
Select INITCAP ('ONLINE JOBS') from dual;
output: Online Jobs
Select INITCAP ('ONLINE-JOBS') from dual;
output: Online-Jobs
In Orcale, it'll converts the very first letter after space or any special symbol into uppercase and remaining letters into lower case.
In Teradata , we don't have this function.
Example:
In Netezza:
Select INITCAP ('ONLINE jOBS');
output: Online Jobs
Select INITCAP ('ONLINE-JOBS') ;
output: Online-jobs
In Oracle:
Select INITCAP ('ONLINE JOBS') from dual;
output: Online Jobs
Select INITCAP ('ONLINE-JOBS') from dual;
output: Online-Jobs
NETEZZA Online Training
ReplyDeletehttp://www.21cssindia.com/courses/netezza-developer-online-training-21.html
IBM Netezza Overview
Netezza Architecture
Connecting to Netezza
Databases
Tables
Database Objects
Data Distribution
Loading and Unloading Tables
Statistics
Zone Maps
Clustered Base Tables
21st Century providing Online training and support on All Technologies. If you are seeking training and support you can reach me on 91-9000444287. Online training by real time Experts. Call us 001-309-200-3848 for online training
Loading and Unloading Tables - http://www.21cssindia.com/courses/netezza-developer-online-training-21.html
ReplyDeleteStatistics - Zone Maps - Clustered Base Tables - Materialized Views - Groom - Sequences - Transactions - Query and System Optimization - Nz commands - Backup and Restore - Creating user and User management - Query History - Managing Workloads - Managing Events - Employees to learn at their own pace and maintain control of learning “where, when and how” with boundless access 24/7by 21st Century Software Solutions. contact@21cssindia.com ---- Call Us +919000444287
NETEZZA Online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/netezza-developer-online-training-21.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, If you’re serious about a career in IT, 21st Century would like to provide you a guidance don’t hesitate to organize a free demo session. For any further information regarding the courses once go through our website Visit: http://www.21cssindia.com | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
ReplyDelete
ReplyDeleteThis is the information that I was looking for.. Thanks for the efforts you put to gather such a nice content and posted here.
http://www.iqonlinetraining.com/ibm-netezza-online-training/
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in NETEZZA TRAINING, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Sangita Mohanty
MaxMunus
E-mail: sangita@maxmunus.com
Skype id: training_maxmunus
Ph:(0) 9738075708 / 080 - 41103383
http://www.maxmunus.com/