Sysdate complicated

[dr_gori]

From time to time I find a SELECT so to get sysdate:

Select all

SELECT SYSDATE 
INTO variavel 
FROM DUAL; 

maybe the person did not know that just put sysdate anywhere in the SQL or PLSQL that the date comes without problems ...

Select all

variavel := SYSDATE; 

Below, I leave a case again in real programs!
This cursor managed to overcome the SELECT above!

Select all

DECLARE 
  CURSOR CDT IS 
    SELECT SYSDATE DAT 
    FROM DUAL; 
  VDATA  DATE; 
BEGIN 
  OPEN  CDT; 
  FETCH CDT INTO VDATA; 
  CLOSE CDT; 
END; 

was made a cursor to just know the date!

[NaPraia]

This cursor killed the dick
as the first Select I had ever seen.

[rodfbar]

this already saw muito ... I worked with a guy who said that in the forms if he did not have the select into pro sysdate he returned the local time of the machine, and not the server time ...

[dr_gori]

Once I rode a trace that had some sysdates.
From what I remember, the Forms implicitly makes a Select from dual. (I may be wrong with that, but that I remember it does just that).

That is, the time is from the server.
But the case is that it is not necessary to do a SELECT from dual in the forms ... only pollute the code!

[gpilger]

And why not use it? There are people who lend themselves to give an open, fetch, and close, create a thousand variables when one is simplifies everything ..


Using Fetch Into

Select all

 
declare 
 
  cursor c_cur is 
    select 'Ivoti', 'Novo Hamburgo', 'Dois Irmãos' from dual; 
 
  v_cid_nome1 varchar2(30); 
  v_cid_nome2 varchar2(30); 
  v_cid_nome3 varchar2(30); 
 
begin 
 
  open c_cur; 
  loop 
    fetch c_cur 
      into v_cid_nome1, v_cid_nome2, v_cid_nome3; 
   
    update cidades set nome = v_cid_nome1 where codigo = 1; 
    update cidades set nome = v_cid_nome2 where codigo = 2; 
    update cidades set nome = v_cid_nome3 where codigo = 3; 
   
    exit when c_cur%NOTFOUND; 
   
  end loop; 
  close c_cur; 
 
  commit; 
 
end; 

using

Select all

 
declare 
begin 
 
  for r_cur in (select 'Ivoti' cid1, 'Novo Hamburgo' cid2, 'Dois Irmãos' cid3 from dual) 
  loop 
   
    update cidades set nome = r_cur.cid1 where codigo = 1; 
    update cidades set nome = r_cur.cid2 where codigo = 2; 
    update cidades set nome = r_cur.cid3 where codigo = 3; 
 
  end loop; 
  commit; 
 
end; 

But of course the two work, but let alone It gets a lot more clean.

Hugs

[ricards]

Speak personal beleza?

in Forms 6i and Reports 6i We have the problem of sysdate Using the machine date and time is a tool bug, with this the idea is always to create a function in the BD and use them in the Forms and Reports.

From the new version this problem has been fixed.

I had this problem in a company I worked with Forms 6i.