emooooooooo

Hi every body please if u can...?!!e :^) i want to import and export excel file to and from oracle DB this by codes behind Forms buttons...e. (h) Gazakom allah 3anna 7'iran

Alter User Scott IDENTIFIED BY new_password Account Unlock dont forget to write ur own new_password

ياريت فعلا تفيدنا بالPROCEDURE ده وجزاك الله عنا خيرا

U MUST USE SELECT STATEMENT WITH INTO CLAUSE IN ANY PL/SQL BLOCK

create or replace function get_SUM_sal return number is empsal number; val1 number; cursor c1 is select salARY from empLOYEES; begin val1 := 0; open c1; loop exit when c1%notfound; fetch c1 into empsal; val1 := VAL1 + empsal; end loop; close c1; return (val1);…

in NVL (expr1, expr3) the two expressions must be the same datatype..

سامحينى... لم افهم ما المشكلة بالظبط but i want to tell u that COUNT group function already not enclude the null values look: !0 select count(COMMISSION_PCT) from employees is diferent from select count(*) from employees so what u mean with using nvl... r u wa…

where here means nothing without the clause WITH CHECK OPTION which help you to restrict the insertion process to insert 50only in the department_id in the values clause .

السلام عليكم if u want 20 employees randomly u can use then : select * from employees where condition1 and condition2 ...etc and rownum<=20 if u want to order the result first then choose the first 20 record u can use: select * from (select * from employees or…