write the code on pl/sql code that when executed fetches the complete record of user entered student registration number from the table. the table created must have at least eight attributes. ten rows and three contrained being implemented.

Asked by Last Modified  

Follow 0
Answer

Please enter your answer

Computer Programmer

We can get the complete details of a table by the SQL code- Select * from table-name;
Comments

Trainer and Developer :>Selenium Automation & Performance Testing

Select * from table-name;
Comments

Tuition for school students

select * from table_name where user reg no(variable entered by student)=student reg no (column name in table);
Comments

select *from tbl_user where std_reg_no=std_no //here std_no is the registration no entered by user.
Comments

Tutor

Create table using create table statement. Constraints used must be of primary key on student registration no. , Age limit can be set using range constraint, list of subjects can be defined for subject field Then insert values statement can be used to insert records. following Select statement will...
read more
Create table using create table statement. Constraints used must be of primary key on student registration no. , Age limit can be set using range constraint, list of subjects can be defined for subject field Then insert values statement can be used to insert records. following Select statement will fetch desired result Select * from tablename where registrationno = user specified registration no. read less
Comments

View 3 more Answers

Related Questions

How much this course?
instead of checking the fee, its good to find a tutor with genuine experience & interest to teach....
Profile Photo
Subramani
What is the meaning of \n and \t in C language?
is new line and \t is for tab
Profile Photo
Priya
0 0
View Comments5
What are pointers in C language?
Hi Imran, Hope you are doing good. Are you looking for short answer or long answer? :) Pointers in C are variables that store memory addresses. They point to the location of another variable, allowing...
Profile Photo
Imran
0 0
View Comments7
What are the toughest topics in C language?
Everything appears easy, but the crucial topics include Pointers, Arrays, 3D Dimensional Arrays, Structures, Functions, and File Handling.
Profile Photo
Kavidassan
0 0
View Comments6
How and where do I start learning C programming?
To start learning C programming, you can follow a structured approach that includes both theoretical knowledge and practical implementation. Begin with understanding the basics of C, including variables,...
Profile Photo
Gaurav
0 0
View Comments7

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

C, Cpp, Java, Python, Javascript Programming Languages
Learning C is as good as Learning a Natural Language(such as English, Hindi, Telugu, Tamil etc) We use Natural Languages to communicate with humans whereas we use Programming Languages such as C, Cpp,...
V

Vamshi

0 0
View Comments0

What is Safety-Critical Software?
A software whose failure may cause death or injuries to the users called Safety-Critical Software.The software present as part of Aeroplanes, or present in Rail as railway signalling software or Automotive...
Profile Photo

Is It Fine To Write “void main()” Or “main()” In C/C++?
The definition: void main() { /* ... */ } Is not and never has been C++, nor has it even been C. See the ISO C++ standard 3.6.1 or the ISO C standard 5.1.2.2.1. A conforming...
Profile Photo

Introduction to Programming Languages
What is a Programming Language? A programming language is a formal computer language or constructed language designed to communicate instructions to a machine, particularly a computer. Programming languages...
Profile Photo

Creating First Program Using C Language
Step 1: Install and setup Turbo C compiler on your computer. Step 2: Open Turbo C from your Desktop or Programs menu. Select “File” from menu bar and select option “New”. Step...
Profile Photo

Recommended Articles

Brilliant Academy is one of the reputed institutes for B.Tech tuition classes. This institute is specialised in delivering quality tuition classes for B.E, Engineering - all streams and Engineering diploma courses. Incorporated in 2012, Brillant Academy is a brainchild of Mr Jagadeesh. The main motto of the academy is to...

Read full article >

Lasya Infotech is a Hyderabad based IT training institute founded in 2016 by O Venkat. Believing in his innovation, passion and persistence and with a diverse blend of experience, he started his brainchild to deliver exemplary professional courses to aspiring candidates by honing their skills. Ever since the institute envisions...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Looking for C Language Classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you