crire :
<code sql>
explain plan for
select * from Annuaire;
@p3
</code>
vous écrivez la requête :
<code sql>
select * from Annuaire;
</code>
et vous exécutez la macro p3 (... table :
<code sql>
explain plan for
select * from Annuaire;
@p3
</code>
<code sql>
explain plan for
select * from BigAnnuaire;
@p3
</code>
Pour BigAnnuaire, affic
table :
<code sql>
explain plan for
select * from Annuaire;
@p3
</code>
<code sql>
explain plan for
select * from BigAnnuaire;
@p3
</code>
Pour BigAnnuaire, affic... ode sql>
explain plan for
select distinct nom from BigAnnuaire;
@p3
</code>
<code sql>
explain plan for
select distinct prenom from BigAnnuaire;
@p3
</code>
et ainsi de suite pour
table :
<code sql>
explain plan for
select * from Annuaire;
@p3
</code>
<code sql>
explain plan for
select * from BigAnnuaire;
@p3
</code>
Pour BigAnnuaire, affic... ode sql>
explain plan for
select distinct nom from BigAnnuaire;
@p3
</code>
<code sql>
explain plan for
select distinct prenom from BigAnnuaire;
@p3
</code>
et ainsi de suite pour
if isloggedin>
<code sql>
SELECT distinct color
FROM product
</code>
</showif>
2. La liste des prix d... showif isloggedin>
<code sql>
SELECT unitPrice
FROM product
ORDER BY unitPrice desc
limit 10
</co... oggedin>
<code sql>
SELECT DISTINCT productId
FROM reviews
where rating = 5
</code>
</showif>
4... n>
<code sql>
SELECT customerId, emailAddress
FROM customer
WHERE emailAddress LIKE '%herma
Simple ou BigAnnuaire.**</fc>
<code sql>
select * from BigAnnuaireSimple
where ...
</code>
<code sql>
select * from BigAnnuaire
where ...
</code>
Voici les requêtes... lité ^ intervalle ^
| R1 |<code sql>select * from ...; -- sans WHERE </code>| non | non | non ... |
| AgeInfCompte |<code sql>select count(*) from ... where age < 60; </code>| | | |
*
ère ligne.
<code sql>
explain plan for
select * from J;
@p4
</code>
Combien de pages ont chacune des... num_rows as cardinalite, blocks as nb_pages
from user_tables;
select table_name, num_rows as cardinalite, blocks as nb_pages
from all_tables
where table_name='BIGJOUEUR';
</co... in plan for
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.sa
ère ligne.
<code sql>
explain plan for
select * from J;
@p4
</code>
Combien de pages ont chacune des... num_rows as cardinalite, blocks as nb_pages
from user_tables;
select table_name, num_rows as cardinalite, blocks as nb_pages
from all_tables
where table_name='BIGJOUEUR';
</co... in plan for
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.sa
(Id=0)
<code sql>
--explain plan for
select * from J;
--@p4
</code>
===== Exercice 1 : Jointure en... in plan for
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.sa... in plan for
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.sa... ain plan for
select J.licence, C.division
from C, J
where J.cnum = C.cnum
and C.nom in (
?
<code sql>
set autotrace trace explain
select * from J;
</code>
Quel est le coût d'accès à chaque tabl... *R1**.
<code sql>
select J.licence, C.nom
from J, C
where J.cnum = C.cnum
and J.salaire > ... nt J. Remarque, l'ordre est fixé par la clause ''FROM'' quand on utilise la directive ''ordered''.
<cod... sql>
select /*+ ordered */ J.licence, C.nom
FROM J, C
where J.cnum = C.cnum
and J.salaire >
am that is member of the Wisdom PPF.
He graduated from the Bucharest Polytechnic Institute (engineer deg... dric.cnam.fr/~scholl/|Michel Scholl :]] Graduated from ENST, Paris (1966) , PhD, UCLA (1977) and Docteur... researcher of the Wisdom federation.
He graduated from Institut d'Informatique d'Entreprise
(IIE, engine... ris. He is member of the Wisdom PPF. He graduated from University of Versailles-Saint-Quentin-En-Yveline
tion. The reconstruction of phylomemetic lattices from scientific production is of utmost importance for... p of the evolution of science is also challenging from a computer science point of view. It is the ambit... ting and processing large phylomemetic structures from large document corpora. These structures and meth... ologically ordered list of digitized publications from which the user wants to extract a phylomemetic ne
tion. The reconstruction of phylomemetic lattices from scientific production is of utmost importance for... p of the evolution of science is also challenging from a computer science point of view. It is the ambit... ting and processing large phylomemetic structures from large document corpora. These structures and meth... ologically ordered list of digitized publications from which the user wants to extract a phylomemetic ne
get, level, SYS_CONNECT_BY_PATH(SOURCE, '/') path
FROM myedges
START WITH SOURCE=1
CONNECT BY prior targ... ité de mettre une sous-requête SQL dans la clause FROM d'une requête ou créez une vue). Affichez le nomb... 2(source,target,l)
as (
select source,target,1 from myedges
union all
select r.source, m.target, r.l+1 from R2 r, myedges m where m.source=r.target
)
search