![]() Next, add the data listed to the WLSLOG table. The WLSLOG table gets listed, as shown in Figure 19.ĭouble-click the WLSLOG table to display its Structure, as shown in Figure 20.įigure 20: WLSLOG table Structure Adding Table Data In Filter Tables, specify Filter as WLSLOG% and click OK, as shown in Figure 18. To list only the new table, right-click Tables and select Filter, as shown in Figure 17. The new table gets listed in the Tables node. OK may be selected from either the Table tab or the DDL tab. The DDL tab displays the DDL used to create the new table (see Figure 16). All the columns added are shown in Figure 15. Click Add Column, as shown in Figure 14, to add another column.Īdd one column at a time. Select the Not Null checkbox to make the column as not nullable. Select Data Type as VARCHAR2 and set Size (255). Modify the default column COLUMN1 to TIME_STAMP, as shown in Figure 14, and set the column as a primary key column. Next, create a new table called WLSLOG with columns TIME_STAMP,CATEGORY,TYPE,SERVERNAME,CODE and MSG. The Create Table wizard gets launched, as shown in Figure 13. To create a new table, right-click the Tables node and select New Table, as shown in Figure 12. The Tables node for the connection lists the tables in the database (see Figure 11). Two options are available to create a new table: In the Preferences dialog, select Database>Advanced, as shown in Figure 10, and select the Autocommit checkbox if not already selected.įigure 10: Autocommit setting Creating a Table This tutorial has the following sections:ĭownload and install the following software: In two tutorials, we shall discuss using JDeveloper with Oracle Database 11g. Oracle Database is the most commonly used relational database management system (RDBMS). JDeveloper also provides support for several other features, including the Application Development Framework (ADF), JDBC database connectivity, and XML processing. Oracle JDeveloper is an integrated development environment (IDE) for Java. ![]() We may make money when you click on links to our partners. content and product recommendations are editorially independent.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |