Home » Other » Training & Certification » queries
queries [message #255367] Tue, 31 July 2007 09:44 Go to next message
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
Re: queries [message #255375 is a reply to message #255367] Tue, 31 July 2007 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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

Re: queries [message #255402 is a reply to message #255367] Tue, 31 July 2007 12:34 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous messageGo to next message
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
Re: queries [message #255454 is a reply to message #255453] Tue, 31 July 2007 23:49 Go to previous messageGo to next message
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
/
Re: queries [message #255493 is a reply to message #255367] Wed, 01 August 2007 01:10 Go to previous message
Maaher
Messages: 7062
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:
  


Current Time: Sat Dec 03 13:58:04 CST 2016

Total time taken to generate the page: 0.05335 seconds