declare highest number; name char(20); cursor c1 is select ename,salary from emp; z c1%rowtype; begin highest:=0; open c1; fetch c1 into z; for z in c1 loop if salary>highest highest:=salary; name:=ename; fetch c1 into z; end if; end loop; … Continue reading Write PL/SQL code that use the cursor the highest paid employee from emp table?
Answer: - A file is a collection of bytes stored on the disk with a given name (called as filename). Every development tool provides access to these files on the disk. In this chapter, we will understand how to access and manipulate files using Visual Basic. There are three special controls, called as File controls, … Continue reading Explain file handling in VB. Explain various types of errors in VB.
Answer: - A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (Authorization). In particular, it is a component of Structured Query Language (SQL). Examples of DCL commands include: GRANTto allow specified users to perform specified tasks. REVOKEto cancel previously granted or denied permissions. The operations for … Continue reading Explain data control language and schema with example.
Report generation: - A report generator is a computer program whose purpose is to take data from a source such as a database, XML stream or a spreadsheet, and use it to produce a document in a format which satisfies a particular human readership. Report generation functionality is almost always present in database systems, where the source of the data is the … Continue reading Write a short note –
Answer: - Classes are the building blocks of an object-oriented application. A class is a programming construct that represents an object in the system. Designing an application requires designing the objects involved, the information contained by the objects, and what the objects can do. For more information on classes and object-oriented programming, see object-oriented programming … Continue reading Explain classes, instances, objects and OLE.
Answer: - One is the standalone scrollbar control. This one has its own window handle, and consequently can be given focus and all those other fun things you can do with window handles. To manipulate them, pass the handle to the scrollbar control to the appropriate scrollbar function (SetScrollInfo, for example) and pass SB_CTL as … Continue reading Explain scroll bars and their types. What are the different types of dialog boxes? Explain about ActiveX control.
Creating a database: - Before using a database on the form we must create a database. This database work as DAO. This database work similar to Microsoft access. It contains number of data field such as text, memo, number, date/time, currency, auto number, logical and OLE Object. Visual data manager, application that is included with … Continue reading What types of connectivity can be used to connect MS-access data base to VB form? Explain with step connectivity.
Looping statement: - Some statement are used in visual basic programming for repetition. These statement are called looping statement. Visual basic provide a large amount of looping statements. Function of all looping statement are about same. The computer is capable of repeating a group of statement number of times without calling the procedure for each … Continue reading Define loop. How many types loops are used in VB? Explain with example.
Answer: - Selecting the proper data type is important because a variable’s data type determine the amount of memory the variable uses, and the way the variable formats and stored information. It is important to select a data type that is appropriate for a type of information that our program will work with. If we … Continue reading What are different data type supposed by VB? How they can have declared? Also mention their uses?
Answer: - Event driven means an object can be constructed and some additional feature can be added in an event or more than one events at a time. Visual basic is a true event driven programming and multiple facility available in this event driven programming. It supports objects for constructing different types of object. With … Continue reading What do you understand by event driven programming list and explain about some of the events support by VB object?