Oracle is an object-oriented language ...

[Laninha]

Hi guys,

can you take a simple question ???
Oracle is an object-oriented language ???



Thanks,
Laninha: D

[Trevisolli]

Laninha, good afternoon.

In the little I know, at least in earlier versions, I know it's an object-relational bank.

But, there is the topic for personal help us.

[Laninha]

Yeah, thank you Trevisolli !!!

Well, who can help and answer, I'm waiting ...

But as a relational object, why is it a bank ???



Holders,
Laninha

[Cosmo]

Oracle is the name of the database and is not the name of any language.

What you want to know is if the PL \ SQL is OO, the answer is:

Yes, you can deploy until harasses in pl. [[99]
vlw: Wink:

[Adriano_Patrick]

In fact Oracle is a SGBD (database management system) created and maintained by Oracle Corporation, Oracle supports relational, object-relational and XML database. PL \ SQL is an extension of the standard SQL language for the Oracle SGBD and it is not object-oriented but a procedural language that extends (gives more) SQL. In reality it is the most robust SGBD in the market, so you will find numerous other features. I hope I made it clear

[jhonatan]

I disagree with what you talked about the PL / SQL not to be object-oriented, it may not be fully oriented to objects, but it is really possible to program object-oriented in PL / SQL using mainly Types ... See example

Select all

 
CREATE OR REPLACE TYPE PESSOA AS OBJECT ( 
   NOME  VARCHAR2(80), 
   IDADE NUMBER, 
   MEMBER FUNCTION GET_IDADE RETURN NUMBER, 
   MEMBER FUNCTION GET_NOME RETURN VARCHAR2, 
   MEMBER PROCEDURE SET_IDADE(IDADE IN NUMBER), 
   MEMBER PROCEDURE SET_NOME(NOME IN VARCHAR2), 
   MEMBER FUNCTION GET_TYPE RETURN VARCHAR2, 
   CONSTRUCTOR FUNCTION PESSOA(NOME IN VARCHAR2,IDADE IN NUMBER)RETURN SELF AS RESULT 
)NOT FINAL 
/ 
CREATE OR REPLACE TYPE BODY PESSOA IS 
 
   CONSTRUCTOR FUNCTION PESSOA(NOME IN VARCHAR2,IDADE IN NUMBER) 
      RETURN SELF AS RESULT IS 
   BEGIN 
      SELF.SET_IDADE(IDADE); 
      SELF.SET_NOME(NOME); 
      RETURN; 
   END; 
   MEMBER FUNCTION GET_IDADE RETURN NUMBER IS 
   BEGIN 
      RETURN SELF.IDADE; 
   END; 
 
   MEMBER FUNCTION GET_NOME RETURN VARCHAR2 IS 
   BEGIN 
      RETURN SELF.NOME; 
   END; 
 
   MEMBER PROCEDURE SET_IDADE(IDADE IN NUMBER) IS 
   BEGIN 
      SELF.IDADE := IDADE; 
   END; 
 
   MEMBER PROCEDURE SET_NOME(NOME IN VARCHAR2) IS 
   BEGIN 
      SELF.NOME := NOME; 
   END; 
    
   MEMBER FUNCTION GET_TYPE RETURN VARCHAR2 IS 
   BEGIN 
      RETURN 'PESSOA'; 
   END; 
END; 

and a "child" ...

Select all

 
CREATE OR REPLACE TYPE PESSOA_SUB UNDER PESSOA( 
    NR_CPF   NUMBER, 
    MEMBER FUNCTION GET_CPF RETURN NUMBER, 
    MEMBER PROCEDURE SET_CPF(NR_CPF IN NUMBER), 
    OVERRIDING MEMBER FUNCTION GET_NOME RETURN VARCHAR2, 
    OVERRIDING MEMBER FUNCTION GET_TYPE RETURN VARCHAR2, 
    CONSTRUCTOR FUNCTION PESSOA_SUB(NOME IN VARCHAR2,IDADE IN NUMBER,NR_CPF IN NUMBER)RETURN SELF AS RESULT 
) 
/ 
CREATE OR REPLACE TYPE BODY PESSOA_SUB IS 
 
   CONSTRUCTOR FUNCTION PESSOA_SUB(NOME IN VARCHAR2,IDADE IN NUMBER,NR_CPF IN NUMBER) 
      RETURN SELF AS RESULT IS 
   BEGIN 
      SELF.SET_IDADE(IDADE); 
      SELF.SET_NOME(NOME); 
      SELF.SET_CPF(NR_CPF); 
      RETURN; 
   END; 
 
   MEMBER PROCEDURE SET_CPF(NR_CPF IN NUMBER) IS 
   BEGIN 
      SELF.NR_CPF := NR_CPF; 
   END; 
 
   MEMBER FUNCTION GET_CPF RETURN NUMBER IS 
   BEGIN 
      RETURN SELF.NR_CPF; 
   END; 
 
   OVERRIDING MEMBER FUNCTION GET_NOME RETURN VARCHAR2 IS 
   BEGIN 
      RETURN 'pessoa sub '||SELF.NOME; 
   END; 
    
   OVERRIDING MEMBER FUNCTION GET_TYPE RETURN VARCHAR2 IS 
   BEGIN 
      RETURN 'PESSOA SUB'; 
   END; 
END; 

as they can see, it is possible to overwrite methods, and implement Inheritance, and more, as you can see in the code below, you can use polymorphism as well.

Select all

 
DECLARE 
   obj PESSOA; 
   sub PESSOA_SUB; 
   poli PESSOA; 
BEGIN 
   obj:= new PESSOA('Jhonatan',19); 
   dbms_output.put_line('Nome: '||obj.get_nome()||' idade: '||obj.get_idade()); 
   dbms_output.put_line(obj.get_type()); 
   obj.set_nome('Alan'); 
   obj.set_idade(26); 
   dbms_output.put_line('Nome: '||obj.get_nome()||' idade: '||obj.get_idade()); 
   dbms_output.put_line(obj.get_type()); 
    
   sub:= new PESSOA_SUB('Érika',28,1234567809); 
   dbms_output.put_line('Nome: '||sub.get_nome()||' idade: '||sub.get_idade()||' cpf: '||sub.get_cpf()); 
   dbms_output.put_line(sub.get_type()); 
    
   poli := sub; 
   dbms_output.put_line('Nome: '||poli.get_nome()||' idade: '||poli.get_idade()); 
   dbms_output.put_line(poli.get_type()); 
END; 

Does anyone still disagree that the PL / SQL is object oriented? : D Hehehe

[]

Jhonatan Pink
Oracle Developer

[dr_gori]

Cool your example!
is as PHP, has everything to program object oriented, but still optional. (Who wants to do everything procedural, can ...)

[jhonatan]

And more ... the SGBD Oracle, from version 9i, from what I know, it is object-oriented. : -O x) hehehe

[rcoelho_6]

Well I have to agree that PL / SQL was not born to be object oriented, but it is such a powerful language that can implement OO without the slightest problem.

In fact everything is possible in PL / SQL

[alexrsilva]

Implementing OO concepts does not mean that PL / SQL is OO.
Java does not have all the concepts of Oo. If I'm not mistaken only the Smalltalk is totally Oo.
Just because you can implement some concepts of OO does not mean that it is a language OO.

[jhonatan]

In fact ... Java is object-oriented, as well as PL / SQL, C ++, Objective C, Pascal Objective, and so many others.

The difference between them and SmallTalk is:
Smalltalk is a pure Oo language
- The ones I mentioned are hybrid languages.

[] 's

[alexrsilva]

Cited You:

"It may not be completely oriented to objects, but it is really possible to program object-oriented in PL / SQL using mainly Types ... see example".
To be able to program OO does not mean that it is OO. I agree that only SmallTalk is pure.
If we are analyzed from the hybrid language point of view, all languages ??will be OO.
Java is OO because it can provide all the attributes that an OO language has. I can not speak of others. I know Delphi can do the same, being that most procedural program, as well as PL / SQL.
From my point of view, I do not put PL / SQL as OO, even if you can implement some concepts.

[] S

Alex Silva

[jhonatan]

The 4 pillars of object-oriented programming

A language is characterized as object-oriented when it attends these four topics that I will present.
· Abstraction
· Encapsulation
· Inheritance
· Polymorphism

I am sure that PL / SQL implements these 4 pillars of OO!

Continued with my opinion, you agree, or not.

The text above, was withdrawn from: http://www.devmedia.com.br/articles/vie ... ?comp=9264

[dr_gori]

I had a teacher who was a defender of the Smalltalk because it was the only 100% object-oriented language. (well thing of academics that has nothing else to do besides following some crazy philosophy )

in real, I think one should use what the languages ??have the best. if to Make a certain thing is best if you use oo, beleza, uses ... if it's something simple, I do not see proqueural problem.

is the same thing that was spoken much "GOTO" is The devil! Whoever uses goto is ridiculous ... and honestly, sometimes avoiding a gout is much more complicated than simply use it ...

[alexrsilva]

OK,
Then Oracle should change the name of the PL / SQL (acronym for the English expression procedural Language / Structured Query Language).

I will implement you in my packages.

Thanks for the information made available.

[] S

Alex Silva

[dr_gori]

In real, PL / SQL has existed since the 80's. At that time he had nothing related to OO in PLSQL. It was added from Oracle 8. But the name plsql continued the same. (already thought if they change to oolsql? hehehe)

[ricardocmoreno]

Yes, the PL / SQL is OO

ABS