Oracle SQL news, help and research


	Oracle SQL


	Home > Oracle Topics > Oracle development languages > Oracle SQL > Expert Technical Advice

Oracle Topics:

EMAIL THIS

TOPICS HOME

BROWSE ALL ORACLE TOPICS

ORACLE INFO CENTERS

RESOURCE CENTERS

RSS FEEDS


Oracle SQL



IN THIS TOPIC:	EXPERT TECHNICAL ADVICE (410) , REFERENCE & LEARNING (4) , NEWS (16) , WHITE PAPERS , WEBCASTS (2) , BEST WEB LINKS (11) , DEFINITIONS (9)

Display in sets of:


1 - 10 of 410 in Expert Technical Advice		<< Previous page 1 2 3 ... 39 40 41 Next >>



ORACLE SQL EXPERTS



			Rudy Limeback SQL Consultant ASK A QUESTION


	Counting NULL columns 21 Dec 2007 EXPERT ANSWER - Our SQL expert explains how to count null columns in a row.


	SQL to count values of a status code 21 Dec 2007 EXPERT ANSWER - Our SQL expert answers a question about counting values of a status code.


	Detail rows for accounts that occur three times 06 Dec 2007 EXPERT ANSWER - Our SQL expert answers a tough query using both the IN subquery and derived tables.


	Counting a row's NULL columns 08 Oct 2007 EXPERT ANSWER - How can I count the number of columns in a row that are not null in SQL?


	Three ways SQL can count rows by type 31 Aug 2007 EXPERT ANSWER - I want to get the individual Type field data and their count in SQL.


	Latest transaction if no recent prior transactions 31 Aug 2007 EXPERT ANSWER - I would like to select the latest customer record only if there are not any prior transactions for the previous 180 days. How do I do this in SQL?


	Oracle SQL to test for numerics 30 Aug 2007 EXPERT ANSWER - With reference to your answer to the question "How can SQL test for pure numerics?" I was surprised that since the column is headed "Ask the Oracle Expert" you did not provide an Oracle solution to the question.


	SQL to select only certain times within a date range 30 Aug 2007 EXPERT ANSWER - I have a field in my table which stores dates and times in datetime format. I want to get the data from 10 p.m. to 6 a.m. between 1st July and 31st July. What's the best way to get this data?


	Stringing together columns with UPDATE SQL 24 Aug 2007 EXPERT ANSWER - Is it possible in T-SQL or PL/SQL to string together the values in a column grouped by another column?


	Number of rows in multiple tables 24 Aug 2007 EXPERT ANSWER - I need a query which will give the tablename and the count of the number of rows. Is it possible?


1 - 10 of 410 in Expert Technical Advice		<< Previous page 1 2 3 ... 39 40 41 Next >>

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy