SQL and PL/SQL | Forum profile

You can nest aggregate functions. Here is what it says in the SQL Reference . You can nest aggregate functions. For example, the following example calculates the average of the maximum salaries of all the departments in the sample schema hr: SELECT AVG(MAX(salary)) FROM employees GROUP BY department_id; AVG(MAX(SALARY)) 10925 This calculation evaluates the inner aggregate (MAX(salary)) for each group defined by the GROUP BY clause...

Hi, Welcome to the forum! I don't have Oracle 9, so I can't test anything. The Oracle 9 SQL Language manual says nothing about a WHERE clause. In later versions, you can have a WHERE clause, like this: ... WHEN NOT MATCHED THEN INSERT (cus.account_no, cus.third_units) VALUES (adm.account_no, adm.third_units) WHERE 1 = 2 -- That is, NEVER insert ; It could be an undocumented feature, or a mistake in the manual, in Oracle 9. You can...

Hi, why do you need Table medst.subs_t h in your query.I believe you are not selecting anything from it too. If possible find a condition for it to join with other table, if you need cartesian join then you need it.No need to worry. well that my personal opinion Also, just in case if you don't know wm_concat is not a documented function in 10g Cheers!!! Bhushan

Hi and welcome to the forum! Your question has been asked before, see f.i.: http://forums.oracle.com/forums/thread.jspa?messageID=3876721&#3876721 (Do some more searches on this forum to find more examples) Read all about TIMESTAMP, CAST, FROM_TZ @ http://tahiti.oracle.com (the Oracle Documentation). If that doesn't get you going, then please post your DB-version and your efforts sofar.

Karthick_Arp wrote: OP wants both US and UK. Not any one of them i guess. Oh well, ... don't be too picky on monday mornings... only had one cup of coffee... I was answering the un-asked question...

Hi, You would be able to add null values n number of times in the table with foreign key. 009

user12258774 wrote: Hi, guys can anyone help me designing a query which will guve me the names and email addresses of all people who have the identical registered domain names (for example e-mail address ends with “gmail.com” or “yahoo.com”) This will give you an idea on deriving domain from email address: with t as ( select 'joe@gmail.com' email from dual union all select 'jill@gmail.com' email from dual union all...

Yes, you can schedule a job via SQL*Plus. The code I posted works in SQL*Plus or any other tool that can run PL/SQL. And the code I posted works against a 9i database. Justin

Something like this. Note code not tested. UPDATE xxpim_cn_item_attributes_st xcias SET ( attr_group_int_name, attribute_name ) = ( SELECT attribute_group, attr_internal_name FROM xxpim_icc_att_map_ad xiama WHERE xiama.sonetto_transf_name = xcias.attribute_name AND xiama.element_name = xcias.attribute1 AND xiama.sonetto_transf_name IS NOT NULL AND category = rec_distinct_attrs_ext.product_type AND fab_name = rec_distinct_attrs_ext.fab_value...

Add consultantid column to table T and use < (or >) instead of (!=) when comparating consultantid's: WITH T AS ( select firstname, lastname, email, expertiseid, c.consultantid from consultants c, skills s where s.consultantid=c.consultantid) Select t1.firstname, t1.lastname, t1.email, t2.firstname, t2.lastname, t2.email from t t1, t t2 where t1.consultantid<t2.consultantid and t1.expertiseid=t2.expertiseid and...