Home » SQL & PL/SQL » SQL & PL/SQL » In SQL/Oracle 'SELECT' command belongs to which category?
In SQL/Oracle 'SELECT' command belongs to which category? [message #196568] Fri, 06 October 2006 00:32 Go to next message
naganath.patil
Messages: 2
Registered: October 2006
Location: Mysore
Junior Member
mine Question is:
In SQL/Oracle 'SELECT' command belongs to which category?
select options:
1.DML
2.DDL
3.TCL
4.DRL
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196571 is a reply to message #196568] Fri, 06 October 2006 00:48 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
What do you think is the answer?

Tip: DRL = Data Retrieval Language.
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196573 is a reply to message #196571] Fri, 06 October 2006 00:50 Go to previous messageGo to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Obviously its not
1.DML
2.DDL
3.TCL

I have not read a term or an acronym defined as DRL in oracle documentation.
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196578 is a reply to message #196573] Fri, 06 October 2006 00:59 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Correct, the term DRL is not used in the Oracle docs. However, it is all over the Internet.
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196582 is a reply to message #196573] Fri, 06 October 2006 01:01 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I've always learnt that SELECT is DML. It is even here in the FAQ, Frank. But at my old university college SELECT has moved to DRL in the course book. It is seen as a subset of DML, so I guess both answers 1 and 4 are correct.

MHE
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196583 is a reply to message #196573] Fri, 06 October 2006 01:01 Go to previous messageGo to next message
naganath.patil
Messages: 2
Registered: October 2006
Location: Mysore
Junior Member
DRL means DATA RETRIVAL LANGUAGE
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196584 is a reply to message #196578] Fri, 06 October 2006 01:03 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Frank Naude wrote on Fri, 06 October 2006 07:59

However, it is all over the Internet.
So it must be true: the internet never lies http://www.orafaq.com/forum/fa/917/0/

(j/k)

MHE
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #196769 is a reply to message #196584] Sat, 07 October 2006 03:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Data Manupulation Language
1.INSERT
2.UPDATE
3.DELETE
4.MERGE
5.SELECT
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #198737 is a reply to message #196568] Wed, 18 October 2006 07:03 Go to previous messageGo to next message
raj.mbr@gmail.com
Messages: 1
Registered: October 2006
Location: bangalore
Junior Member
Hi

SELECT is always a DML(Data Manipulation Language command).

Byee...
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #198740 is a reply to message #198737] Wed, 18 October 2006 07:16 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Agreed. Are there any particular reason why it cannot be a Data Retrieval Language command as well?
Re: In SQL/Oracle 'SELECT' command belongs to which category? [message #198746 is a reply to message #198740] Wed, 18 October 2006 07:30 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Frank Naude wrote on Wed, 18 October 2006 14:16
Agreed. Are there any particular reason why it cannot be a Data Retrieval Language command as well?
No. DRL is a subset of DML so I believe both DML and DRL are correct.

MHE
Previous Topic: case and Grouping
Next Topic: SQL*Plus Question
Goto Forum:
  


Current Time: Thu Dec 08 23:54:44 CST 2016

Total time taken to generate the page: 0.10609 seconds