Chapter 1 Oracle Application Express ¼Ò°³
1.1.Oracle Application Express ¼Ò°³
1.2.Oracle Application Express Ư¡
1.3.Oracle Application Express ±¸Á¶
1.4.Oracle APEX ¹ßÀü°úÁ¤
1.5.Oracle APEX·Î °³¹ßµÈ ¾ÖÇø®ÄÉÀÌ¼Ç È¸é
Chapter 2 Oracle 12c DB¿Í APEX¼³Ä¡
2.1. ¼³Ä¡ ¿ä±¸»çÇ×
2.2. Oracle 12c DBMS ´Ù¿î·Îµå ¹× ¼³Ä¡
2.3. Oracle APEX ´Ù¿î·Îµå ¹× ¼³Ä¡
Chapter 3 Oracle REST Data Service(ORDS) ¼³Ä¡
3.1. REST¶õ
3.2. Oracle REST Data Service(ORDS)¶õ?
3.3. Oracle APEX¿Í ORDS°£ÀÇ ¿¬°á
3.4. Oracle REST Data Service ´Ù¿î·Îµå
3.5. ORDS Command Line¼³Ä¡ ¹× ±¸¼º
3.6. SQL Developer¸¦ ÀÌ¿ëÇÑ ORDS ¼³Ä¡
3.7. ORDS ¼³Ä¡ÇØÁ¦
3.8. Oracle APEX/ORDS ¼³Ä¡¿À·ù ó¸®
Chapter 4 Oracle APEX ±¸Á¶ ¹× °³³ä
4.1. Oracle Application ±¸Á¶
4.2. APEX Workspace(ÀÛ¾÷¿µ¿ª) ȨÆäÀÌÁö
4.3. °øÀ¯ ±¸¼º ¿ä¼Ò(Shared components)
4.4. ÆäÀÌÁö µðÀÚÀ̳Ê(Page Designer)
4.5. Oracle APEX URL ±¸¹®ÀÌÇØ
Chapter 5 ÀÛ¾÷¿µ¿ª(Workspace) »ý¼º
5.1 Æ©Å丮¾ó(TUTORIAL) °³¿ä.
5.2 ÀÛ¾÷¿µ¿ª(Workspace) »ý¼º
5.3 ÀÛ¾÷¿µ¿ªÀÇ »ç¿ëÀÚ¿Í ±×·ì°ü¸®
5.4 Cloud¿¡¼ ¹«·á APEX üÇèÇϱâ
Chapter 6 ¾ÖÇø®ÄÉÀ̼Ç((Application) »ý¼º
6.1 ¾ÖÇø®ÄÉÀ̼Ç(Application)»ý¼º
6.2 SQL Workshop
Chapter 7 ¸®Æ÷Æ®¿Í ±×¸®µå °³¹ß
7.1 REPORT¿Í GRID °³¿ä
7.2 ´ëÈ½Ä ±×¸®µå(Interactive Grid)
7.3 ´ëÈ½Ä ¸®Æ÷Æ®(Interactive Report)
7.4 Ŭ·¡½Ä ¸®Æ÷Æ®(Classsic Report)
7.5 ¸®Æ÷Æ® ¼Ó¼º º¯°æÇϱâ
7.6 ¸¶¹ý»ç ¾øÀÌ Å¬·¡½Ä ¸®Æ÷Æ® »ý¼º
7.7 °øÀ¯±¸¼º¿ä¼Ò LOV»ý¼ºÇϱâ
7.8 »çÁø À̹ÌÁö Ç¥½ÃÇϱâ
Chapter 8 FORM °³¹ß
8.1 Form °³¿ä
8.2 ¸¶¹ý»ç¸¦ ÀÌ¿ëÇÑ Form ÆäÀÌÁö
8.3 »ç¿ëÀÚÁ¤ÀÇ Form°ú Report
8.4 LIVE TAMPLATE OPTION »ç¿ë¹ý
8.5 °øÀ¯ ±¸¼º¿ä¼ÒÀÇ LOV Àû¿ë
8.6 Link Column
8.7 Button ¹× Process
Chapter 9 ¼½ÄÀÖ´Â ÆíÁý±â(CKEditor) ¼³Á¤ °³¹ß
9.1 CKEditor ±âº»¼³Á¤
9.2 CKEditor °í±Þ¼³Á¤
Chapter 10 Â÷Æ® / Ä«·»´õ / Áöµµ °³¹ß
10.1 Â÷Æ®(Charts)/Ķ¸°´õ/Áöµµ°³¿ä
10.2 ORACLE JET Â÷Æ®
10.3 ´Þ·Â(Calendar) È¸é ¸¸µé±â
10.4 Áöµµ(Map)°ú Plug-in
Chapter 11 ¸¶½ºÅÍ-µðÅ×ÀÏ È¸é °³¹ß
11.1 ¸¶½ºÅÍ-µðÅ×ÀÏ È¸éÀ¯Çü
11.2 ´ÜÀÏÆäÀÌÁö ¸¶½ºÅÍ-µðÅ×ÀÏ
11.3 ¸¶½ºÅÍ-µðÅ×ÀÏ-µðÅ×ÀÏ
11.4 µÎ ÆäÀÌÁö ¸¶½ºÅÍ-µðÅ×ÀÏ
11.5 ¸¶½ºÅÍ-µðÅ×ÀÏ ÆäÀÌÁö Æ©Å丮¾ó Á¤¸®
Chapter 12 Dynamic Action µû¶ó Çϱâ
12.1 Dynamic Action(µ¿Àûµ¿ÀÛ) ÀÌÇØ
12.2 Event Á¾·ù
12.3 True/False½Ã Action
12.4 Dynamic ActionÀ» À§ÇÑ ¿¹Á¦ Page »ý¼º
Chapter 13 µ¿Àû HTML ÄÁÅÙÃ÷ °³¹ß
13.1 PLSQL Web Agent
13.2 ´Ü¼ø ¸®Æ÷Æ® À¯Çü
13.3 Å×ÀÌºí ¸®Æ÷Æ® À¯Çü
Chapter 14 ½ºÇÁ·¹µå ½¬Æ® ÆÄÀÏ·Î APEXÆäÀÌÁö °³¹ß
14.1 ¿¢¼¿ÆÄÀÏÀ» DBÅ×À̺í·Î
14.2 SPREADSHEET·Î ¾ÖÇø®ÄÉÀÌ¼Ç °³¹ß
14.3 ¾ÖÇø®ÄÉÀÌ¼Ç »ý¼º¸¶¹ý»ç
14.4 ¾ÖÇø®ÄÉÀÌ¼Ç ½ÇÇà °á°ú
Chapter 15 DATA LOAD
15.1 Data Load°³¿ä
15.2 Data Load »ý¼º¸¶¹ý»ç
Chapter 16 Navigation menu
16.1 Navigation menu ¼öÁ¤Çϱâ
16.2 DB TableÀ» ÀÌ¿ëÇÑ ¸Þ´º
16.3 ½Å±Ô Navigation menu »ý¼º
Chapter 17 »ç¿ëÀÚ ÀÎÁõ°ú ±ÇÇÑ
17.1 APEX ±âº»ÀÎÁõ
17.2 ¿¹Á¦¸¦ À§ÇÑ SQL ½ºÅ©¸³Æ®
17.3 »ç¿ëÀÚ Á¤ÀÇ ÀÎÁõÀ¯Çü 1
17.4 ¾ÖÇø®ÄÉÀÌ¼Ç ·¹º§ Ç׸ñ ¼±¾ð
17.5 »ç¿ëÀÚ Á¤ÀÇ ÀÌÁõÀ¯Çü 2
17.6 ÆäÀÌÁö Á¢±Ù±ÇÇÑ (Á¢±ÙÁ¦¾î)
Chapter 18 EXPORT / IMPORT
18.1 APEX ¹é¾÷°ú º¹±¸ (Export/Import)
18.2 EXPORT ¹é¾÷
18.3 IMPORTº¹±¸
18.4 »ç¿ëÀÚ Á¤ÀÇ ¹é¾÷
Chapter 19 RESTful Data Services
19.1 RESTful °³³ä
19.2 APEX ¸±¸®Áî 18.x RESTful À¥¼ºñ½º
19.3 APEX ¸±¸®Áî 5.1.4 RESTfulÀ¥¼ºñ½º
19.4 RESTful À¥ ¼ºñ½º ±â¹Ý ¾ÖÇø®ÄÉÀÌ¼Ç °³¹ß
Chapter 20 REST Enabled SQL
20.1 REST Enabled SQL ¼ºñ½º¶õ
20.2 ¿ø°Ý(REMOTE) DB ¼³Á¤
20.3 REST Enabled SQL ¼ºñ½º»ý¼º
20.4 REST Enabled SQL ¼ºñ½º¸¦ ÀÌ¿ëÇÑ °³¹ß¿¹Á¦
Chapter 21 Web Source Module
21.1 Web Source ModuleÀ̶õ.
21.2 ÀÎÁõ ¹× ÀÎÁõ¿À·ù ¹ß»ý½Ã
21.3 Web Source Module »ý¼º¿¹Á¦ - GitHub
Chapter 22 ´ëü ¹®ÀÚ¿
22.1 ´ëü ¹®ÀÚ¿ À¯Çü
22.2 ´ëü ¹®ÀÚ¿ »ç¿ë »ç·Ê
22.3 ºôÆ®-ÀÎ ´ëü ¹®ÀÚ¿ Á¾·ù
- ORACLE APEX (ORACLE Application Express)
Àü¼¼°è APEX °³¹ßÀÚµé°ú ÇÔ²² ±â¼úÀ» °øÀ¯ÇÏ´Â ÄÚµå±â¹Ý °³¹ß¹æ½ÄÀÌ ¾Æ´Ñ, ÄÄÆ÷³ÍÆ® ±â¹Ý °³¹ß¹æ½ÄÀ¸·Î À¥ ¾ÖÇø®ÄÉÀÌ¼Ç °³¹ß ÅøÀÇ È¹±âÀûÀÎ º¯È.
* ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ±â¹Ý À¥ È¸é °³¹ßÀ» À§ÇÑ ¹«·á °³¹ß µµ±¸
* Çѹø °³¹ß·Î ¸ð¹ÙÀÏ Æù(¾Èµå·ÎÀ̵å, IOS), ÅÇ, µ¥½ºÅ©Åé PC ¸ðµÎ Áö¿ø
* PC¿¡ ¼³Ä¡ÇÏÁö ¾ÊÀº 100% ºê¶ó¿ìÀú ±â¹Ý °³¹ßµµ±¸
* Àü¼¼°è APEX °³¹ßÀڵ鰣ÀÇ Æ¯Á¤±â´É ¸ðµâ ¿ÀǼҽº Ç÷¯±×ÀÎÀ¸·Î °øÀ¯
* ¸ðµç °³¹ß¼Ò½º ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀå
* °ú°Å ORACLE FORMS¸¦ ´ë½ÅÇÒ Â÷¼¼´ë À¥ ¾ÖÇø®ÄÉÀÌ¼Ç °³¹ßµµ±¸
* HTML5, CSS3, SQL, PL/SQL, JavaScripts, jQueryµî Áö¿ø