Ora Again
22-08-2011, 07:26
السلام عليكم ورحمة الله وبركاته
معكم اخيكم هاني اقدم لكم شرح الكورس الشهير oracle developer 10g والشرح من اعداد المهندس الممتع تامر نبيل زاده الله علما والان هذا الجذء الاول من الكورس
Part (1) Sql
1-about oracle (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%34%30%32%33%35%31%35%39%2f%65%64%36%66%38%31%6 2%30%2f%31%2d%5f%69%6e%74%72%6f%64%75%63%74%69%6f% 6e%2e%68%74%6d%6c%3f%64%69%72%50%77%64%56%65%72%69 %66%69%65%64%3d%65%35%36%31%37%62%32%39)
2 - Installation & Preperation (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%36%36%31%37%33%36%32%38%2f%61%37%65%63%38%38%3 9%31%2f%32%2d%49%6e%73%74%61%6c%6c%61%74%69%6f%6e% 5f%5f%50%72%65%70%65%72%61%74%69%6f%6e%2e%68%74%6d %6c%3f%64%69%72%50%77%64%56%65%72%69%66%69%65%64%3 d%65%35%36%31%37%62%32%39)
3-Retrieving data using select statement (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%6d%65%64%69%61%66%69%72%65%2e%63%6f%6d%2f%3f%35 %35%6f%79%6a%71%6e%7a%77%6d%68)
4-Restricting and Sorting data (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%6d%65%64%69%61%66%69%72%65%2e%63%6f%6d%2f%64%6f %77%6e%6c%6f%61%64%2e%70%68%70%3f%79%6d%68%32%6a%7 a%6f%6e%71%74%74)
5-Using Single-Row Functions (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%36%38%30%30%30%34%33%31%2f%66%66%35%39%30%65%3 1%63%2f%55%73%69%6e%67%5f%53%69%6e%67%6c%65%2d%25% 35%42%43%4f%4c%4f%52%3d%25%32%32%42%6c%75%65)
Part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%36%38%30%30%30%34%33%31%2f%66%66%35%39%30%65%3 1%63%2f%55%73%69%6e%67%5f%53%69%6e%67%6c%65%2d%25% 35%42%43%4f%4c%4f%52%3d%25%32%32%42%6c%75%65)
6-Using Single-Row Functions to Customize Output (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%37%32%37%37%32%39%32%34%2f%66%33%30%36%32%33%3 7%32%2f%70%61%72%74%32%2e%68%74%6d%6c%3f%64%69%72% 50%77%64%56%65%72%69%66%69%65%64%3d%65%35%36%31%37 %62%32%39)
- Part 2 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%37%32%37%37%32%39%32%34%2f%66%33%30%36%32%33%3 7%32%2f%70%61%72%74%32%2e%68%74%6d%6c%3f%64%69%72% 50%77%64%56%65%72%69%66%69%65%64%3d%65%35%36%31%37 %62%32%39)
7-Using the Group Functions (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%37%35%32%36%32%39%37%37%2f%62%66%37%32%30%30%3 0%30%2f%37%2d%55%73%69%6e%67%5f%74%68%65%5f%47%72% 6f%75%70%5f%46%75%6e%63%74%69%6f%6e%73%2e%68%74%6d %6c%3f%64%69%72%50%77%64%56%65%72%69%66%69%65%64%3 d%65%35%36%31%37%62%32%39)
8-Displaying Data from Multiple Tables - part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%38%32%39%37%32%37%35%31%2f%32%35%39%39%31%66%6 5%63%2f%38%2d%44%69%73%70%6c%61%79%69%6e%67%5f%44% 61%74%61%5f%66%72%6f%6d%5f%4d%75%6c%74%69%70%6c%65 %5f%54%61%62%6c%65%73%5f%2d%5f%70%61%72%74%5f%31%2 e%68%74%6d%6c%3f%64%69%72%50%77%64%56%65%72%69%66% 69%65%64%3d%65%35%36%31%37%62%32%39)
9-Displaying Data from Multiple Tables - part 2 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%31%35%31%31%30%30%30%2f%33%64%64%33%34%64%3 8%63%2f%30%30%39%2d%44%69%73%70%6c%61%79%69%6e%67% 5f%44%61%74%61%5f%66%72%6f%6d%5f%4d%75%6c%74%69%70 %6c%65%5f%54%61%62%6c%65%73%5f%2d%5f%70%61%72%74%5 f%32%2e%68%74%6d%6c)
10-Using Subqueries to Solve Queries (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%35%34%35%34%32%33%36%2f%31%35%34%63%65%35%3 0%2f%30%31%30%2d%55%73%69%6e%67%5f%53%75%62%71%75% 65%72%69%65%73%5f%74%6f%5f%53%6f%6c%76%65%5f%51%75 %65%72%69%65%73%5f%2e%68%74%6d%6c)
11-Manipulating Data - part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%35%36%35%37%35%38%39%2f%32%38%32%64%31%32%3 6%61%2f%30%31%31%2d%4d%61%6e%69%70%75%6c%61%74%69% 6e%67%5f%44%61%74%61%5f%2d%5f%70%61%72%74%5f%31%2e %68%74%6d%6c)
12-Manipulating Data - part 2 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%37%38%33%30%32%38%31%2f%39%63%62%62%33%31%3 9%64%2f%30%31%32%2d%4d%61%6e%69%70%75%6c%61%74%69% 6e%67%5f%44%61%74%61%5f%2d%5f%70%61%72%74%5f%32%2e %68%74%6d%6c)
13-Using DDL Statements to Create and Manage Tables - Part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%30%37%31%35%33%38%32%32%2f%63%35%31%62%32%6 2%66%30%2f%30%31%33%2d%55%73%69%6e%67%5f%44%44%4c% 5f%53%74%61%74%65%6d%65%6e%74%73%5f%74%6f%5f%43%72 %65%61%74%65%5f%61%6e%64%5f%4d%61%6e%61%67%65%5f%5 4%61%62%6c%65%73%5f%2d%5f%50%61%72%74%5f%31%5f%2e% 68%74%6d%6c)
14-Using DDL Statements to Create and Manage Tables - Part 2.rar (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%31%30%32%32%33%34%33%39%2f%37%66%37%31%61%6 1%66%33%2f%30%31%34%2d%55%73%69%6e%67%5f%44%44%4c% 5f%53%74%61%74%65%6d%65%6e%74%73%5f%74%6f%5f%43%72 %65%61%74%65%5f%61%6e%64%5f%4d%61%6e%61%67%65%5f%5 4%61%62%6c%65%73%5f%2d%5f%50%61%72%74%5f%32%2e%68% 74%6d%6c)
15-Creating Other Schema Objects - part1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%31%34%30%39%37%38%31%39%2f%35%36%38%31%32%3 4%62%2f%30%31%35%2d%43%72%65%61%74%69%6e%67%5f%4f% 74%68%65%72%5f%53%63%68%65%6d%61%5f%4f%62%6a%65%63 %74%73%5f%2d%5f%70%61%72%74%31%5f%2e%68%74%6d%6c)
16-Creating Other Schema Objects (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%32%30%36%33%34%30%37%33%2f%34%39%36%38%37%6 1%63%39%2f%30%31%36%2d%43%72%65%61%74%69%6e%67%5f% 4f%74%68%65%72%5f%53%63%68%65%6d%61%5f%4f%62%6a%65 %63%74%73%5f%2d%5f%70%61%72%74%32%2e%68%74%6d%6c)
معكم اخيكم هاني اقدم لكم شرح الكورس الشهير oracle developer 10g والشرح من اعداد المهندس الممتع تامر نبيل زاده الله علما والان هذا الجذء الاول من الكورس
Part (1) Sql
1-about oracle (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%34%30%32%33%35%31%35%39%2f%65%64%36%66%38%31%6 2%30%2f%31%2d%5f%69%6e%74%72%6f%64%75%63%74%69%6f% 6e%2e%68%74%6d%6c%3f%64%69%72%50%77%64%56%65%72%69 %66%69%65%64%3d%65%35%36%31%37%62%32%39)
2 - Installation & Preperation (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%36%36%31%37%33%36%32%38%2f%61%37%65%63%38%38%3 9%31%2f%32%2d%49%6e%73%74%61%6c%6c%61%74%69%6f%6e% 5f%5f%50%72%65%70%65%72%61%74%69%6f%6e%2e%68%74%6d %6c%3f%64%69%72%50%77%64%56%65%72%69%66%69%65%64%3 d%65%35%36%31%37%62%32%39)
3-Retrieving data using select statement (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%6d%65%64%69%61%66%69%72%65%2e%63%6f%6d%2f%3f%35 %35%6f%79%6a%71%6e%7a%77%6d%68)
4-Restricting and Sorting data (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%6d%65%64%69%61%66%69%72%65%2e%63%6f%6d%2f%64%6f %77%6e%6c%6f%61%64%2e%70%68%70%3f%79%6d%68%32%6a%7 a%6f%6e%71%74%74)
5-Using Single-Row Functions (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%36%38%30%30%30%34%33%31%2f%66%66%35%39%30%65%3 1%63%2f%55%73%69%6e%67%5f%53%69%6e%67%6c%65%2d%25% 35%42%43%4f%4c%4f%52%3d%25%32%32%42%6c%75%65)
Part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%36%38%30%30%30%34%33%31%2f%66%66%35%39%30%65%3 1%63%2f%55%73%69%6e%67%5f%53%69%6e%67%6c%65%2d%25% 35%42%43%4f%4c%4f%52%3d%25%32%32%42%6c%75%65)
6-Using Single-Row Functions to Customize Output (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%37%32%37%37%32%39%32%34%2f%66%33%30%36%32%33%3 7%32%2f%70%61%72%74%32%2e%68%74%6d%6c%3f%64%69%72% 50%77%64%56%65%72%69%66%69%65%64%3d%65%35%36%31%37 %62%32%39)
- Part 2 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%37%32%37%37%32%39%32%34%2f%66%33%30%36%32%33%3 7%32%2f%70%61%72%74%32%2e%68%74%6d%6c%3f%64%69%72% 50%77%64%56%65%72%69%66%69%65%64%3d%65%35%36%31%37 %62%32%39)
7-Using the Group Functions (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%37%35%32%36%32%39%37%37%2f%62%66%37%32%30%30%3 0%30%2f%37%2d%55%73%69%6e%67%5f%74%68%65%5f%47%72% 6f%75%70%5f%46%75%6e%63%74%69%6f%6e%73%2e%68%74%6d %6c%3f%64%69%72%50%77%64%56%65%72%69%66%69%65%64%3 d%65%35%36%31%37%62%32%39)
8-Displaying Data from Multiple Tables - part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%38%32%39%37%32%37%35%31%2f%32%35%39%39%31%66%6 5%63%2f%38%2d%44%69%73%70%6c%61%79%69%6e%67%5f%44% 61%74%61%5f%66%72%6f%6d%5f%4d%75%6c%74%69%70%6c%65 %5f%54%61%62%6c%65%73%5f%2d%5f%70%61%72%74%5f%31%2 e%68%74%6d%6c%3f%64%69%72%50%77%64%56%65%72%69%66% 69%65%64%3d%65%35%36%31%37%62%32%39)
9-Displaying Data from Multiple Tables - part 2 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%31%35%31%31%30%30%30%2f%33%64%64%33%34%64%3 8%63%2f%30%30%39%2d%44%69%73%70%6c%61%79%69%6e%67% 5f%44%61%74%61%5f%66%72%6f%6d%5f%4d%75%6c%74%69%70 %6c%65%5f%54%61%62%6c%65%73%5f%2d%5f%70%61%72%74%5 f%32%2e%68%74%6d%6c)
10-Using Subqueries to Solve Queries (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%35%34%35%34%32%33%36%2f%31%35%34%63%65%35%3 0%2f%30%31%30%2d%55%73%69%6e%67%5f%53%75%62%71%75% 65%72%69%65%73%5f%74%6f%5f%53%6f%6c%76%65%5f%51%75 %65%72%69%65%73%5f%2e%68%74%6d%6c)
11-Manipulating Data - part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%35%36%35%37%35%38%39%2f%32%38%32%64%31%32%3 6%61%2f%30%31%31%2d%4d%61%6e%69%70%75%6c%61%74%69% 6e%67%5f%44%61%74%61%5f%2d%5f%70%61%72%74%5f%31%2e %68%74%6d%6c)
12-Manipulating Data - part 2 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%39%37%38%33%30%32%38%31%2f%39%63%62%62%33%31%3 9%64%2f%30%31%32%2d%4d%61%6e%69%70%75%6c%61%74%69% 6e%67%5f%44%61%74%61%5f%2d%5f%70%61%72%74%5f%32%2e %68%74%6d%6c)
13-Using DDL Statements to Create and Manage Tables - Part 1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%30%37%31%35%33%38%32%32%2f%63%35%31%62%32%6 2%66%30%2f%30%31%33%2d%55%73%69%6e%67%5f%44%44%4c% 5f%53%74%61%74%65%6d%65%6e%74%73%5f%74%6f%5f%43%72 %65%61%74%65%5f%61%6e%64%5f%4d%61%6e%61%67%65%5f%5 4%61%62%6c%65%73%5f%2d%5f%50%61%72%74%5f%31%5f%2e% 68%74%6d%6c)
14-Using DDL Statements to Create and Manage Tables - Part 2.rar (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%31%30%32%32%33%34%33%39%2f%37%66%37%31%61%6 1%66%33%2f%30%31%34%2d%55%73%69%6e%67%5f%44%44%4c% 5f%53%74%61%74%65%6d%65%6e%74%73%5f%74%6f%5f%43%72 %65%61%74%65%5f%61%6e%64%5f%4d%61%6e%61%67%65%5f%5 4%61%62%6c%65%73%5f%2d%5f%50%61%72%74%5f%32%2e%68% 74%6d%6c)
15-Creating Other Schema Objects - part1 (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%31%34%30%39%37%38%31%39%2f%35%36%38%31%32%3 4%62%2f%30%31%35%2d%43%72%65%61%74%69%6e%67%5f%4f% 74%68%65%72%5f%53%63%68%65%6d%61%5f%4f%62%6a%65%63 %74%73%5f%2d%5f%70%61%72%74%31%5f%2e%68%74%6d%6c)
16-Creating Other Schema Objects (https://www.almassrawy.com/forum/redirector.php?url=%68%74%74%70%3a%2f%2f%77%77%77% 2e%34%73%68%61%72%65%64%2e%63%6f%6d%2f%66%69%6c%65 %2f%31%32%30%36%33%34%30%37%33%2f%34%39%36%38%37%6 1%63%39%2f%30%31%36%2d%43%72%65%61%74%69%6e%67%5f% 4f%74%68%65%72%5f%53%63%68%65%6d%61%5f%4f%62%6a%65 %63%74%73%5f%2d%5f%70%61%72%74%32%2e%68%74%6d%6c)