Following a few requests, here are some sites you may find useful for supporting your SQL learning:
General
http://www.stickyminds.com/ http://www.thefreecountry.com/documentation/onlinesql.shtml (free online tutorials)
T-SQL
http://sqlcourse.com/ (free online tutorial)http://www.w3schools.com/sql/default.asp (free online tutorial)http://sqlzoo.net/http://www.sqlservercentral.com/
PL/SQL
http://www.orafusion.com/http://ora-00937.ora-code.com/ (Oracle error codes)
Syntax differences between T-SQL and PL/SQL
http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm
If I come across any others I'll add them
James
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using RSS
hi to all
i am new to oracle
i am trying to make a report,
currently this report shows only the booked information,like booked date,and other related information.
but i have to show the all the date of the month along with the booked dates and its related information, and dates shows from sysdate +60 days.
my code is(submit_button)
************************************************************
declare
qry varchar2(1000);
qry2 varchar2(700);
qry3 varchar2(700);
v_dt number;
v_dt1 date;
cnt number;
cursor cr1 is
select distinct (allotment_vu.br_id),allotment_vu.unit_id,allotment_vu.ga_id,allotment_vu.ga_desc,allotment_vu.booking_from,allotment_vu.booking_upto,allotment_vu.guest_idno,allotment_vu.guest_name,allotment_vu.guest_office,allotment_vu.unit_no from allotment_vu where ga_id=:select.ga_id and booking_from>=sysdate and booking_from<=sysdate+60 order by booking_from asc;
cursor cr2 is
select distinct (allotment_vu.br_id),allotment_vu.unit_id,allotment_vu.ga_id,allotment_vu.ga_desc,allotment_vu.booking_from,allotment_vu.booking_upto,allotment_vu.guest_idno,allotment_vu.guest_name,allotment_vu.guest_office,allotment_vu.unit_no from allotment_vu where ga_id=:select.ga_id and unit_no=:select.unit_no and booking_from>=sysdate and booking_from<=sysdate+60 order by booking_from asc;
begin
if :select.ga_id is not null and:select.unit_no is null then
go_block('allotment_vu');
clear_block(No_Validate);
open cr1;
loop
fetch cr1 into :allotment_vu.br_id,:allotment_vu.unit_id,:allotment_vu.ga_id,:allotment_vu.ga_desc,:allotment_vu.booking_from,:allotment_vu.booking_upto,:allotment_vu.guest_idno,:allotment_vu.guest_name,:allotment_vu.guest_office,:allotment_vu.unit_no;
exit when cr1%notfound;
next_record;
end loop;
close cr1;
ELSIF :select.ga_id is not null and:select.unit_no is not null then
open cr2;
fetch cr2 into :allotment_vu.br_id,:allotment_vu.unit_id,:allotment_vu.ga_id,:allotment_vu.ga_desc,:allotment_vu.booking_from,:allotment_vu.booking_upto,:allotment_vu.guest_idno,:allotment_vu.guest_name,:allotment_vu.guest_office,:allotment_vu.unit_no;
exit when cr2%notfound;
close cr2;
end if;
end;
please help me
Another free online SQL tutorial I can add is http://www.1keydata.com/sql/sql.html
this is a great blog site...the tutorial has really help me a lot...i am a oracle learner..after watching these tutorial and reading all the article of this blog i learned many things... thank you for sharing these so important materials with us...
</p