does exist any chance to do in SQL , without using PL/SQL code like it:
select project_type,
decode (project_type,
1, select count(*) from t1,
2, select count(*) from t2,
3, select count(*) from t3,
0) count_prj
from projects
Thanks
2  5978 
Your question is not clear, you need to provide more
requiremets/specifications.
--
Posted via http://dbforums.com
"Julia Sats" <ju********@sympatico.ca> wrote in message news:<2F*******************@news20.bellglobal.com> ... does exist any chance to do in SQL , without using PL/SQL code like it:
select project_type,
decode (project_type,
1, select count(*) from t1,
2, select count(*) from t2,
3, select count(*) from t3,
0) count_prj
from projects
Thanks
sure. you almost had it. you just need some parens --
select project_type,
decode (project_type,
1, (select count(*) from t1),
2, (select count(*) from t2),
3, (select count(*) from t3),
0) count_prj
from projects This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Pavils Jurjans |
last post by:
Hallo,
I am working on multilingual web-application, and I have to be very sure
about how the international characters are encoded and decoded in the
client-server form requests.
There's a...
|
by: richasaraf |
last post by:
Hello everyone,
Please HELP !!!!!
I'm facing problem in converting CASE statements into DECODE. As i have PL/SQL 8i, so it does not handle CASE statements. Please send me the solutions . Then...
|
by: cortukmehmet |
last post by:
Hi everybody
1)how can i get the encoding type a dat file?
2)how can i decode it?
|
by: MP |
last post by:
I have the following command.
SELECT A.STORE_NAME, A.STORE_NUM, A.ZIP_CODE, B.EMPLOYEE_ID, B.GENDER,
B.EMP_LEVEL, C.ITEM_CODE,
DECODE(B.ITEM_CODE,1, 'CHICK_BURGERS') ITEM_DESCR,...
|
by: rsd |
last post by:
Hi,
I'm trying get Samsung YH-920 mp3 player to work with Debian GNU/Linux.
To do that I need to run
http://www.paul.sladen.org/toys/samsung-yh-925/yh-925-db-0.1.py
script, the idea behind the...
|
by: dande |
last post by:
my problem is I have used invoice table, patient table.In Invoice table date,cash,credit, cheque,advance,total is coming.but in patient table having registration type code having gen registraion...
|
by: james.duckworthy |
last post by:
Python programmers may find the application to decoding an encrypted
map
image format known as Memory Map to produce a standard PNG image file
interesting.
Someone obviously very well versed in...
|
by: glacier |
last post by:
I use chinese charactors as an example here.
"'\\xc4\\xe3\\xba\\xc3\\xc2\\xf0'"
My first question is : what strategy does 'decode' use to tell the way
to seperate the words. I mean since s1 is...
|
by: anonymous |
last post by:
1 Objective to write little programs to help me learn German. See code
after numbered comments. //Thanks in advance for any direction or
suggestions.
tk
2 Want keyboard answer input, for...
|
by: John Savage |
last post by:
I save posts from a midi music newsgroup, some are encoded with
yenc encoding. This gave me an opportunity to try out the decoders
in Python. The UU decoder works okay, but my YENC effort gives...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
