OraFAQ Forum: Training & Certification » queries

Home » Other » Training & Certification » queries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

queries [message #255367]

Tue, 31 July 2007 09:44

sandeep1018
Messages: 1
Registered: July 2007
Location: hyderabd

Junior Member

hello friends i just registered this forum today itself
can any one of you have any queries,
i mean only queries not the questions
under only SQL QUERIES ONLY
if so plzzzzzzzzzzzzzz can u send to my id
kumar.sandeeep@gmail.com
hope for the response

Report message to a moderator

Re: queries [message #255375 is a reply to message #255367]

Tue, 31 July 2007 10:45

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Welcome to the forum.
Please follow the rules:
Read How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).
Post with a meaningful title.
Don't speak IM (avoid plz german postal code).

I have about 100000 SQL queries, I will be glad to fill your mailbox with them.

Regards
Michel

Report message to a moderator

Re: queries [message #255402 is a reply to message #255367]

Tue, 31 July 2007 12:34

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Here's one:

select sysdate from dual;

And you can now probably expect to have inadvertently opened up that mailbox to spamming.

[Updated on: Tue, 31 July 2007 12:35]

Report message to a moderator

Re: queries [message #255453 is a reply to message #255402]

Tue, 31 July 2007 23:48

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

select * from emp
where sal >
( select sal from emp
where upper(ename)='FORD')
ORDER BY SAL

Report message to a moderator

Re: queries [message #255454 is a reply to message #255453]

Tue, 31 July 2007 23:49

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

SELECT EMPNO , ENAME
FROM EMP
WHERE (DEPTNO , SAL) IN
( SELECT DEPTNO , SAL
FROM EMP
WHERE UPPER(ENAME)='SMITH')
AND ENAME != 'SMITH'
ORDER BY SAL
/

Report message to a moderator

Re: queries [message #255493 is a reply to message #255367]

Wed, 01 August 2007 01:10

Maaher
Messages: 7065
Registered: December 2001

Senior Member

sandeep1018 wrote on Tue, 31 July 2007 16:44

hello friends i just registered this forum today itself

Welcome! The first thing to do would be to look around and read threads.

sandeep1018 wrote on Tue, 31 July 2007 16:44

if so plzzzzzzzzzzzzzz can u send to my id <blabla>

Syntax error.

http://www.orafaq.com/forum/fa/448/0/

Anyway, this one's closed. Moved to Homework, Training and Certification.

@sispk6: the same goes for you, use code tags.

MHE

[Updated on: Wed, 01 August 2007 01:11]

Report message to a moderator

Previous Topic:	Query Help regarding finding relationships.
Next Topic:	materialized view to refresh every saturday

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 16:05:39 CDT 2024