c.city

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Configuring your Oracle9i database for materialized views

Materialized viewHow can we consider writing a SQL query inside the materialized view?how can it be more efficient?Query 1 – sales and profitability by quarter by product.select t.quarter, p.product_id, p.product_name,sum(f.purchase_price + f.shipping_charge) as Gross_Sales, sum((f.purchase_price + f.shipping_charge)-(p.cost_price + p.shipping_charge)) as Profit, count(purchase_price) as total_sales, count(*) as purchase_count from...

Tags: Sales strategy, Sales force management, Databases, Enterprise software, Oracle9i Database, database, Oracle9i, send.shakthi@..., f.purchase_price, f.product_id, f.time_key, purchase_price, p.cost_price, c.city, time t

Discussion threads 2007-10-24

About materialized view

How can we consider writing a SQL query inside the materialized view?how can it be more efficient?Query 1 – sales and profitability by quarter by product.select t.quarter, p.product_id, p.product_name,sum(f.purchase_price + f.shipping_charge) as Gross_Sales,sum((f.purchase_price + f.shipping_charge)-(p.cost_price + p.shipping_charge)) as Profit, count(purchase_price) as total_sales, count(*) as purchase_countfrom time t, product p, purchases...

Tags: Sales strategy, send.shakthi@..., f.purchase_price, f.product_id, f.time_key, c.city, p.cost_price, purchase_price, time t

Discussion threads 2007-10-24

Additional Resources

Perfect City Icons (zip)

A collection of isometric projection icons depicting various objects of city infrastructure, Perfect City Icons are here to help design the look and feel of a perfect architectural planning or mapping suite. Perfect City Icons make for a perfect city map when assembled together. Landscapers and architects, students and city...

Tags: Icon, Aha-soft, Benefits, Human Resources

Software downloads 2008-06-12

Wireless for the City of Fredericton: Becoming a Smart City Through the Wireless Network

City of Fredericton worked with Cisco to create the "Fred e-Zone." a free WiFi network in the city, to allow residents to connect to internet from anywhere in the city.

Tags: City, Network, Cisco Systems Inc., Wireless Network, Wi-Fi, Wireless

Webcasts 2005-08-30

City of Grapevine Makes Big Strides in GIS

The City of Grapevine, TX is a small, but growing city located on the northern end of the Dallas/Fort Worth Metroplex. In 1999, the City successfully applied for an ESRI Local Government Start-Up Grant. This case study will review how Grapevine was able to leverage the grant and create the...

Tags: Grapevine, GIS, Software

Case studies

Swiss City (widget)

Swiss City, you can see different city from Switzerland. You can customize Swiss City with your own cam. This version is the first release on CNET Download.com.

Tags: City

Software downloads 2007-06-05

City Info Search (xpi)

Get all the information about any city in the USA with a mouse click. City Info Search includes geography, population, ethnic composition, housing, climate, hospitals, and airports. Usage: highlight the name on any US city on a page. Right click the mouse. Choose Get City Info. This version is the...

Tags: City, Mouse, Archibald Packwood, Mice, Hardware, Peripherals

Software downloads 2007-09-20

Montreal (zip)

This screensaver shows images of the beautiful city of Montreal; often called the Paris of North America. Montreal is the third largest French speaking city in the World. The name of the city comes from the mountain Mont Royal. The centre of the city has a lot of modern high...

Tags: Center, Montreal

Software downloads 2006-03-10

The City of New York Automates Services for the City That Never Sleeps With NYC 311

The City of New York has more than 8 million residents and a government consisting of dozens of city departments and agencies. In the past, if a problem or need arose, it wasn't easy to know where to go, who to ask, or what to do. The Mayor made the...

Tags: Oracle Corp., New York, Service, Government, Vertical Industries, Advertising & Promotion, Strategy, Enterprise Software, Software, Marketing, Management

Case studies

3D Snow Rally City Stage (zip)

Fasten your seat belt, zoom over the city stages, whiz by splendid landmarks and cheering crowd, push the limits of your vehicle to win the champion. Snow Rally City Stage is a solid city racing game with the best 3D graphics on mobile and handheld devices offering breathtaking gaming experience...

Tags: 3D, City, Games, Handhelds, Personal Technology, Hardware

Software downloads 2007-12-26

City of Helsinki Enhances Network Security by Ensuring Security Policy Compliance

The City Council of the City of Helsinki provides a variety of governmental services for the approximately 500,000 inhabitants of Helsinki, Finland. To protect its network from security threats such as malware and intruders, the City of Helsinki needed a way to ensure that all computers accessing the network met...

Tags: Network, Compliance, Network Security, Networking, Security

Case studies 2008-01-01

Pitesti City (exe)

Pitesti, City from central part of Romania, Most important tourist attractions presented in 43 high quality photos. Every thing you want to see in this city. Parks, old and new buildings, and museums.

Tags: Romania

Software downloads 2005-12-23

Novell Crafts eGovernment Strategy With the City of Philadelphia, to Improve the Delivery of City Services

Philadelphia, the fifth largest city in the United States, is best known for its part in American history. The City of Philadelphia wanted an eGovernment strategy to serve as a catalyst for city agencies and departments to recognize common interests, enhancing government technology and workforce resources, while increasing inter-department collaboration...

Tags: Novell Inc., Philadelphia, E-government, Government

Case studies

Ploiesti City - ScreenSaver (exe)

Ploiesti, City from central part of Romania, Most important tourist attractions presented in 34 high quality photos. Every thing you want to see in this city. Parks, old and new buildings, museums and other.

Tags: Screensaver

Software downloads 2005-12-23

Oracle Case Study: City of Oklahoma

Oklahoma City is the state capital and Oklahoma's largest city, with a population of approximately 506,000 residents. The city needed a single financial management and human resources information system to streamline and standardize its business processes and to allow for accurate and accessible data storage. The city also wanted to...

Tags: Human Resources, Oracle Corp., Financial, Oklahoma City, Financial Accounting, Finance

Case studies

Standard City Icons (zip)

Create city maps that look good on screen and on paper. Standard City Icons come in a variety of sizes and resolutions, making city plans perfectly legible on any media from PDA screens to poster-size prints. The smallest size is 16x16, but the largest-resolution versions are in 1200x1200 pixels and...

Tags: Size, Aha-soft, PDAs, Advertising & Promotion, Handhelds, Hardware, Marketing

Software downloads 2008-07-25

City of Vienna Deploys Red Hat

As the capital city of Austria, Vienna serves in many ways as a role-model for local councils throughout the country. The IT organization of the capital city has always promoted the use of the most reliable and effective technologies. The fact that the city is also called upon to invite...

Tags: Red Hat Inc., Vienna, Linux, Open Source, Operating Systems, Software

Case studies 2007-01-01

Manchester City RSS Feed (widget)

Manchester City RSS Feed displays the latest headlines from the Manchester City page on the BBC's sports section on the Web site. Clicking the Manchester City bar at the top takes you to the aforementioned page. This version is the first release on CNET Download.com.

Tags: RSS Feed, RSS, Web Site Development, Web Technology, Internet

Software downloads 2007-07-24

Sibiu City - ScreenSaver (exe)

Sibiu, beautiful medieval city from Transylvania - Romania. Over 75 high quality photos from the city, including the most important tourist attractions. palaces, fortress, old buildings, and gothic Cathedrals.

Tags: Screensaver, Romania

Software downloads 2005-12-23

SpatialDirect at the City of Richmond

Strategically located, Richmond, British Columbia is a transportation and economic hub for the Greater Vancouver region. The City has an enterprise GIS system that contains a large amount of valuable data. The main issue was that a large amount of GIS data had to be made available to all City...

Tags: Richmond, City, GIS, Transportation, Software

Case studies