Write PL/SQL code that use the cursor the highest paid employee from emp table?

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 →

Advertisements

Explain file handling in VB. Explain various types of errors in VB.

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 data control language and schema with example.

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 →

Write a short note –

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 →

Explain classes, instances, objects and OLE.

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 scroll bars and their types. What are the different types of dialog boxes? Explain about ActiveX control.

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 →

What types of connectivity can be used to connect MS-access data base to VB form? Explain with step connectivity.

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 →

Define loop. How many types loops are used in VB? Explain with example.

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 →

What are different data type supposed by VB? How they can have declared? Also mention their uses?

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 →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: