How to Insert, Navigate and Delete Records in Oracle Forms ?

I have already described in my previous posts about creating oracle forms using wizards and creating list of values (LOVs). In this post I am going to describe How to create buttons for Inserting, Saving, Navigating and Deleting records in oracle forms. Insertion, Deletion and Navigation functions are necessary for manipulating data within forms whether it is greed line view or form view or any other format. You can add those buttons by simply adding push buttons from toolbox to the form and adding PL/SQL query in the button trigger using PL/SQL editor. Here are some steps for adding buttons on the form.

 Steps for creating Insertion, Navigational and Deletion Buttons 

1. At first create a form as given in the post "How to Create Oracle Forms by Using Wizard ?"  then start to add the buttons on the form as given in the image below.

2. Add push buttons in the form area from toolbox by clicking on it and drawing on the form. Then give a new name and label name as given in the image below from the Property Palette. You can open the Property Palette by right clicking on the button and clicking on Property Palette option.

3. After renaming and labeling the buttons, go to Object Navigator and expand the button name by clicking on the plus sign, then click on Triggers option and click on + sign above to add new trigger. Find and select "WHEN-BUTTON-PRESSED" option and click on OK.

4. A new PL/SQL editor window will appear as given below. Type the required query, save it and exit from the window. Repeat the same process for all the buttons you have created. The query commit; given in the image below is for saving records in the database.

5. Add the following PL/SQL queries in the PL/SQL editor for respected buttons.

• Show Record:       execute_query;
• Previous Record:  previous_record;
• Next Record:        next_record;
• First Record:        first_record;
• Last Record:         last_record;
• Insert Record:      create_query;
• Condition:            enter_query;
• Save:                    commit;
• Delete:                 delete_record;
• Exit Form:           exit_form;

6. After completing all the steps, run that form and test the buttons whether or not they are working.

 

Related Posts:

• How to Create Oracle Forms by Using Wizard ?
• How to Create LOV in Oracle Forms Using Wizard ?
• How To Create Simple Menu Using CSS ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

How to Create LOV in Oracle Forms Using Wizard ?

LOV (List of Values) in Oracle Forms are used to display the associated values while inserting values in forms. It makes the user easier to enter data on the forms. You can assign values in LOV statically or dynamically and can be displayed on the form manually or automatically. Filters can also be added on LOV to filter before display the list. Here I am writing some easy steps for creating List of Values in Oracle Forms using wizard. It may help you to learn the process of creating LOV in your Oracle Form.

Steps for Creating LOV in Oracle Forms Using Wizard

1. To add a new List of Values, at first go to Object Navigator and click on LOVs option and click on + sign above, then the following dialog box will appear.

2. Select the option "Use the LOV Wizard" to create from Wizard.

 3. Select the option "New Record Group base on query" to create new record group or select "Existing Record Group" to use existing Record Group and got to next.

4. Click on Build SQL Query button, give User Name, Passport and Database name and connect to the Database. Select the required Table from where you want to take the values.

5. Select the Columns which you want to display in the list and click on OK. Select all the columns on the LOV columns and go to next.

6. Give the title what you would like to display in LOV window. Also select width, height and position of the LOV window.

7. Give the no of rows you want to display in LOV and select the check box having "Let the user filter records before displaying them", if you want to display the records with filter. Go to next and finish the wizard. Now the LOV is successfully created.

How to Assign Value of LOV to the Column ?

1. Right click on LOV name and go to property palette.

2. Under functional property go to column mapping properties, select the required column and click on browse and select the column to assign.

How to Display LOV Automatically on the Form ?

1. Under functional property of property palette, go to "Automatic Display" option and change to "Yes".

2. Go to "Automatic Skip" option and change to "Yes" to go to the next navigation automatically. 

Related Posts:

 

•  How to Create Oracle Forms by Using Wizard ?
• How To Create Simple Menu Using CSS ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

How to Create Oracle Forms by Using Wizard ?

Oracle Forms is a technology developed by Oracle to develop database driven web applications quickly and easily. It is a component of Oracle Fusion Middleware Technology of Oracle corporation. By using Oracle Forms you can develop even advanced web applications more easily. While developing web applications, you can use graphical methods such as wizards for faster development. Here are some easy steps with screenshots for developing oracle forms by using wizard.

Steps for Creating Oracle Forms by Using Wizard

1. At first start Weblogic Server by clicking on Start Weblogic Server option under Oracle Forms of Oracle Instance from start menu.

2. Give your weblogic username and password.

3. Start form builder application from the start menu, which is located under Developer Tools of oracle instance folder.

4. After opening form builder application, Click on data block option and click on + sign above under forms module of Object Navigator.

 

 5. Click on "Use the Data Block Wizard" option to create a form by using wizard.

  6. Click on "Table or View" option to create from Table or View.

7. Click on "Browse" button to open Table or View. Give User name, Password and Database name to connect to the database.

8. After configuring the Data Block, Click on "Create the data block, then call the Layout Wizard" option and finish the wizard.

9. Select "New Canvas" option from the combo box to create New Canvas to locate data blocks physically.

10. Specify the required Width and Height of the fields.

 

 11. Give the Title of the Frame, Number of Records to be Displayed and the Distance Between Records.

 12. After completing the wizard click on Finish to finish the wizard. Then you can view the design view as below.

 13. Run the form to view this form in browser.

Related Posts:

• How to Create LOV in Oracle Forms Using Wizard ?
• How To Create Simple Menu Using CSS ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

How To Make Simple CSS Stylesheet for a Website ?

CSS language is used to simplify the process of making web pages presentable. It handles the look and feel part of a web page. Not only it makes the web development process more fast and saves the time but also makes the page loading time more faster and easier for maintenance. So today's almost all of the websites are designed by using CSS. You can design and link the CSS file very easily to the web page. In this post I am telling you on "How To Make Simple CSS Style Sheet for a Website ?" by using very simple steps and ideas. I hope that after reading this post you will able to make simple design for your web page using CSS. The format of the HTML page will be as in the image on right side.

Steps To Make Simple CSS Style Sheet for a Website

1. At first create a HTML file by using any text editor like notepad. On the HTML file write the following code and save it on the ".html" format.

<html>
<head>
<title>How To Make Simple CSS StyleSheet for a Website ?</title>
<link rel="Stylesheet" type="text/css" href="style.css">
</head>
<body>
<div id="wrapper">
<div id="banner">
<p>This is banner</p>
</div>

<div id="navigation">

</div>

<div id="content_area">
<p> This is content area</p>

</div>

<div id="sidebar">
<p> This is sidebar</p>
</div>

<div id="footer">
<p> this is footer</p>

</div>
</div>
</body>
</html>

Here I have used "id" selector for css, you can also use class selector as <div class="wrapper"> etc.

2. Then create a CSS file by using any text editor like notepad. On the CSS file write the following code and save it on the ".css" extension format.

#wrapper {
 width:1080px;
 margin:0 auto;
 padding:10px;
 border:5px solid #dedede;
 background-color:#fff;
 }

#banner {
 height:150px;
 border:3px solid #e3e3e3;
 background-size:cover;
 background-image: url("banner.jpg");
 background-repeat: no-repeat;
 }

#navigation {
 height:50px;
 border:3px solid #e3e3e3;
 margin-top:20px;
 width:auto;
 background-image: url("nav.jpg");
 
 }

#content_area{
 float:left;
 width:755px;
 margin:20px 0 20px 0;
 padding:10px;
 border: 3px solid #e3e3e3;
 text-align:justify;
 }

#sidebar {
 float:right;
 width:250px;
 height:388px;
 border:3px solid #e3e3e3;
 margin-top:26px;
 }

#footer {
 clear:both;
 width:auto;
 height:40px;
 margin-top:20px;
 background-image: url("footer.jpg");
 border:3px solid #e3e3e3;
 text-align:center;
 color:#fff;
 }

Replace the image url i.e. "banner.jpg" by your image path on the css code above.

Replace the stylesheet name "style.css" by your saved stylesheet name on the HTML code above. The stylesheet file should be on the same folder or should give the full path.

For "class" selector, you have to write the css code as the format .wrapper{ } etc.

You can add the menu items on navigation by adding HTML codes and CSS codes on HTML and CSS files copying from the previous post: How To Create Simple Menu Using CSS ?

You can add the contents on "content_area", "sidebar" and "footer" by using different HTML Tags like <p> </p> etc.

Related Posts:

• How To Create Simple Menu Using CSS ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

How To Create Simple Menu Using CSS ?

By using CSS codes we can create websites menus more easily with very simple and small number of codes. So uses of CSS menus on websites makes your website lighter and faster, also runs on almost all of the browsers. Here I have given some useful steps and codes for creating simple menu using CSS. It may help you to make simple, attractive and awesome menu for your own website by using the following steps and codes.

To Create Simple Menu Using CSS

# At first create the following HTML codes on your webpage.

Replace the "#" with your link URL included in the HTML code below.

<div id="navigation">
 <ul id="nav">
 <li><a href="#">Home</a></li>
 <li><a href="#">Item1</a>
  <ul>
   <li><a href="#">SubItem1</a></li>   
   <li><a href="#">SubItem2</a></li>
   <li><a href="#">SubItem3</a></li>
   <li><a href="#">SubItem4</a></li>
  </ul>
 </li>
    
 <li><a href="#">Item2</a></li>
 <li><a href="#">Item3</a></li>
 </ul>
</div>

# Create a CSS file with the following codes.

Replace the 'back.jpg' with your image file included in the css code below.

#navigation{
  width:auto;
  height:30px;
  float:left;
  background-image: url('back.jpg');  
  border:none;
  margin-top:20px;
  margin-left:0px;
 }

#nav{
 list-style: none;
 padding:0px;
 display:block;
 margin-top:2px;

}

#nav li{
 font-size:20px;
 float:left;
 position:relative;
 width:180px;
 hight:50px;
 display:block;
 align:center;
 padding-left:10px;
 
}

#nav ul{
 list-style:none;
 margin:0;
 padding:0;
 width: auto;
 display:none;

}

#nav li:hover{
 background-image:url('back.jpg');
 background-repeat:no-repeat;
 background-size:cover;
}

#nav li:hover>ul{
 display:block;
 position:absolute;
 
}


#nav li ul{
 left:0px;
 margin-top:0px;
 padding-top:0px;
}

#nav li ul li{
 background-image:url('back.jpg');
 background-repeat:no-repeat;
 background-size:cover;
 border:1px solid #e3e3e3;
 padding-left:10px;
 width:178px;
}


#nav a:link, #nav a:active, #nav a:visited{
 display:block;
 color:#ff00aa;
 text-decoration:none;
}

# Link CSS file to the web page.

Add the following code to link CSS file to the web page between <head> tags.

<head>

<link rel="Stylesheet" type="text/css" href="style.css">

</head>

Preview of  CSS Menu

• Home
• Item1
  • SubItem1
  • SubItem2
  • SubItem3
  • SubItem4
• Item2
• Item3

Related Posts:

• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

Solved MCQ of Network Architecture set-1

1. ............................ specifies a complete set of rules for the connections and interactions of its physical and logical components for providing and utilizing communication services.

Mapa mental do TCP/IP (Photo credit: Wikipedia)

A) Computer Architecture

B) Communication Architecture

C) Network Architecture

D) Internet Architecture



2. The two most important network architecture or reference model are ...............

i) Layered reference model

ii) OSI reference model

iii) DSL reference model

iv) TCP/IP reference model


A) i and ii

B) ii and iii

C) iii and iv

D) ii and iv




3. The Open System Interconnection(OSI) reference model includes ................... layers.

A) five

B) six

C) seven

D) eight



4. ..................... is used to manage and synchronize conversation between two systems.

A) Physical Layer

B) Data Link Layer

C) Session Layer

D) Transport Layer



5. Which of the following is not the function of physical layer?

A) Converting the digital bits into electrical signal

B) Detecting and correcting errors

C) Defining voltages and data rates needed for transmission.

D) Activating, maintaining and deactivating the physical connection




6. ...................... divides the outgoing messages into packets and assembles incoming packets into messages for the higher levels.

A) Physical Layer

B) Data Link Layer

C) Network Layer

D) Transport Layer



7. The TCP/IP reference model was used earlier by ....................., before being used in the Internet.

A) ARPANET

B) PARPANET

C) USDNET

D) DODNET



8. Which of the following are True for TCP/IP reference model?

i) The TCP protocol divide large message into a sequence of packets into an IP packet.


ii) The IP protocol is used to put a message into packet.

iii) It is necessary for all the packets in a single message to take the same route each time it is sent.

iv) The packets are passed from one network to another until they reach their destination.

A) i and iv only

B) i, ii and iv only

C) i, ii and iii only

D) All i, ii, iii and iv



9. Which of the following is not the layer of TCP/IP model?

A) Internet Layer

B) Application Layer

C) Transport Layer

D) Presentation Layer



10. State whether the following statements are True or False.

i) In TCP/IP model transport layer guarantees delivery of packets.

ii) Network layer of OSI model provides both connectionless and connection oriented service.

iv) The TCP/IP model does not fit any other protocol stack.

A) i-True, ii-False, iii-False

B) i-False, ii-True, iii-True

C) i-False, ii-False, iii-True

D) i-True, ii-True, iii-False

Answers:

1. ............................ specifies a complete set of rules for the connections and interactions of its physical and logical components for providing and utilizing communication services.

C) Network Architecture


2. The two most important network architecture or reference model are ...............

i) Layered reference model

ii) OSI reference model

iii) DSL reference model

iv) TCP/IP reference model

D) ii and iv


3. The Open System Interconnection(OSI) reference model includes ................... layers.

C) seven


4. ..................... is used to manage and synchronize conversation between two systems.

C) Session Layer


5. Which of the following is not the function of physical layer?

B) Detecting and correcting errors


6. ...................... divides the outgoing messages into packets and assembles incoming packets into messages for the higher levels.

C) Network Layer


7. The TCP/IP reference model was used earlier by ....................., before being used in the Internet.

A) ARPANET


8. Which of the following are True for TCP/IP reference model?

i) The TCP protocol divide large message into a sequence of packets into an IP packet.

ii) The IP protocol is used to put a message into packet.

iii) It is necessary for all the packets in a single message to take the same route each time it is sent.

iv) The packets are passed from one network to another until they reach their destination.

B) i, ii and iv only


9. Which of the following is not the layer of TCP/IP model?

D) Presentation Layer


10. State whether the following statements are True or False.

i) In TCP/IP model transport layer guarantees delivery of packets.

ii) Network layer of OSI model provides both connectionless and connection oriented service.

iii) The TCP/IP model does not fit any other protocol stack.

B) i-False, ii-True, iii-True

Related Posts:

• Solved MCQ of Computer networking set-1
• MCQ of Computer Networking with answer set-2
• Solved MCQ of Computer networking set-3
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Computer Networking set-5
• Solved MCQ of Computer Networking test set-6
• MCQ of Computer networking test with answer set-7
• Computer Networks MCQ Interview Questions set-8
• Solved MCQ of Client Server Computing set-1
• Solved MCQ of Internet Security set-1
• MCQ of Internet Security with answer set-2

JDBC MCQ Interview Questions with Answers set-2

1. A Java program cannot directly communicate with an ODBC driver because .......

ODBC Administrator (Photo credit: Wikipedia)

A) ODBC written in C language

B) ODBC written in C# language

C) ODBC written in C++ language

D) ODBC written in Basic language



2.The JDBC-ODBC Bridge driver translates the JDBC API to the ODBC API and used with .......


A) JDBC drivers

B) ODBC drivers

C) Both A and B

D) None of the above



3. The ............................. package contains classes that help in connecting to a database, sending SQL statements to the database, and processing the query results.

A) connection.sql

B) db.sql

C) pkg.sql

D) java.sql



4. The ................................ method executes a simple query and returns a single Result Set object.

A) executeUpdate()

B) executeQuery()

C) execute()

D) noexecute()



5. The ......................... method executes an SQL statement that may return multiple results.

A) executeUpdate()

B) executeQuery()

C) execute()

D) noexecute()




6. The ........................ object allows you to execute parametrized queries.

A) ResultSet

B) Parametrized

C) PreparedStatement

D) Condition



7. The .................. object provides you with methods to access data from the table.

A) ResultSet

B) Parametrized

C) TableStatement

D) Condition



8. The parameters of the PreparedStatement object are ...................... when the user clicks on the Query button.

A) initialized

B) started

C) paused

D) stopped



9. The ...................... method sets the query parameters of the PreparedStatement Object.

A) putString()

B) insertString()

C) setString()

D) setToString()



10. Connection object can be initialized using the ............................ method of the Driver Manager class.

A) putConnection()

B) setConnection()

C) Connection()

D) getConnetion()

Answers:

1. A Java program cannot directly communicate with an ODBC driver because .......

A) ODBC written in C language

2.The JDBC-ODBC Bridge driver translates the JDBC API to the ODBC API and used with .......

B) ODBC drivers

3. The ............................. package contains classes that help in connecting to a database, sending SQL statements to the database, and processing the query results.

D) java.sql

4. The ................................ method executes a simple query and returns a single Result Set object.

B) executeQuery()

5. The ......................... method executes an SQL statement that may return multiple results.

C) execute()

6. The ........................ object allows you to execute parametrized queries.

C) PreparedStatement

7. The .................. object provides you with methods to access data from the table.

A) ResultSet

8. The parameters of the PreparedStatement object are ...................... when the user clicks on the Query button.

A) initialized

9. The ...................... method sets the query parameters of the PreparedStatement Object.

C) setString()

10. Connection object can be initialized using the ............................ method of the Driver Manager class.

D) getConnetion()

Related Posts:

• Solved MCQ of Java Set-1
• MCQ of Java with answer set-2
• Solved MCQ of Java for Java Proficiency test set-3
• Solved MCQ of Java set-4
• Java MCQ Questions and Answers set-5
• Java Multiple Choice Questions With Answers set-6
• MCQ of Java With Answer set-7
• Java Multiple Choice Questions With Answers set-8
• Java Objective Questions with Answers set-9
• Java MCQ Interview Questions With Answers set-10
• Solved MCQ of JDBC and JSP set-1
• Solved MCQ of Java Beans set-1