12 replies to this topic

[DougSytems]

Galera, preciso fazer um for em sql, mas não sei as regras. Sou iniciante.
Tipo, em java é for(i=0;i<=100;i++).
E em sql , como seria ????
Preciso fazer com que minha variável i verifique dentro de um loop até 100 , se i é mutiplo de 10, e se for ele devera escrever o valor de i na tela....

vlw !!!

[Paulo André]

A estrutura é mais ou menos assim:

FOR i IN 1..100
LOOP
	 IF [condição] THEN
		[comando]
	 END IF;
END LOOP;

Flws...
Até mais

[DougSytems]

Valew....
sabe como eu faço o mod ???? ahauahua
brigadu !!!

[Paulo André]

mod(x,y)

Flws...
Até mais

[DougSytems]

BLZ AMIGO.. VLW..
JA CONSEGUI....

declare
-- Local variables here
i integer;
begin
-- Test statements here
for i in 1..100 loop
if (i MOD 10 = 0 ) then
DBMS_OUTPUT.PUT_LINE(i);
end if;
end loop;
end;

OBRIGADO...

[LarPhozyHah]

Male Ed Pharmacy cialis Keflex Vaginal Bacteria Need Stendra Low Price Cytotec Marrakech Synthroid Cheapest Prices Online Generic Levitra cialis Keflex What Is
Kitten Amoxicillin Dosage cialis Precio Levitra 4 Comprimidos
Keflex And Drug Test Showing Positive Direct Free Shipping Pyridium Buy Drugs Cash On Delivery Brand Cialis Price
Want To Buy Dutasteride <a href=http://cialtobuy.com>cialis</a> Levitra Generico Online Italia
Propecia Indicaciones cialis Kamagra User Reviews
Amoxicillin Cervical Mucus
Need Perscription Amoxicillin <a href=http://cialtobuy.com>cialis</a> Rx Health Drugs Viagra

[Miguceamma]

Acheter Lasix En France Acheter Du Kamagra En Ligne buy cialis Doxycycline Next Day Delivery Discount Clomid 100mg

[LarPhozyHah]

Slimex Online In Canada cialis Atenolol And Amoxicillin
Cialis Et Consommation D'Alcool cialis Isotretinoin Claravis Carmarthenshire Viagra Vendita Online In Italia Photo Levitra
Propecia Tiempo Tarif Cialis 20mg online pharmacy Para Que Sirve Cialis 20 Mg
Pain Pills Online Prednisone 10 Mg Isotretinoin purchase on line low price overseas Chandler cialis Us Parmacy No Script Needed Viagra Basso Costo Viagra Generico Santiago

[RonsisM]

Kamagra Faq cost of levitra 20mg Acquistare Kamagra Caen Amoxicillin Interaction Viagra Buy Prescription Drugs Online India

[LarPhozyHah]

Discount On Plavix viagra Cialis Online Paypal Option How To Get Viagara In Sydney
Misoprostol Effets Viagra Ohne Rezept Online Kaufen Propecia Caja levitra non prescription Comprar Cialis Get Viagara Online

[LarPhozyHah]

Cialis Dose Recommandee Kamagra Online Bestellen Legal Can I Take Expired Amoxicillin Pills viagra Indian Pharmacies That Accept Paypal
buy now tab isotretinoin isotret mastercard cod Cheapest Viagra On The Internet viagra online Find Cialis Without Prescription Amoxicillin Clavulanic Ta Syn Viagra Con Hipertension
Cialis Original Gunstig Kaufen cialis online Hydrochlorothiazide France Mastercard Accepted Vomex Stendra Avanafil Saturday Delivery

[RonsisM]

Mail Order Prevacid Cialis Cancer De La Prostate cialis online Keflex Kidney Infection Legally Levaquin Levotab Medication Amoxicillin 50 Mg Per Kg

[LarPhozyHah]

Cialis Interacciones Medicamentosas Viagara 40 For 99 viagra online pharmacy Propecia Women Kamagra Doctissimo Buy Cipro In The United States
buy accutane online topix Viagra Falschung Erkennen Propecia Shop Pill sildenafil tadalafil and vardenafil Viagra Frau Nasenspray
Que Es Cialis viagra Buy Wellbutrin 150mg Singapore
Propecia Frontale Kamagra Kaufen Oberhausen viagra Ubungen Zur Levitra Usa Pills Viagra Zithromax Inhaler