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  

5 Answers

Learn C Language

Follow 0
Answer

Please enter your answer

A G

Computer Programmer

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

Trainer and Developer :>Selenium Automation & Performance Testing

Select * from table-name;
Comments
Dislike Bookmark

Tuition for school students

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

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

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
Dislike Bookmark

View 3 more Answers

Related Questions

what is the significance of lvalue?
An lvalue (locator value) represents an object that occupies some identifiable location in memory (i.e. has an address).
Abhishek
Can we pass arguments in the main function in C language?
Yes. it is possible to pass arguments into the main function.
Mukesh
0 0
View Comments7
How do I start learning C programming and finish it in one month?
Use a book named "Let us C"by yashwant t kanetkar. Or simply by taking a class from teachers on urbanpro
Pallavi
0 0
View Comments8
Can anybody provide me error free coding for graphic program in C??? Animated Smiley program Rotating Fan progran Sunrise program
#include graphics.h #include conio.h #include stdlib.h #include dos.h main() { int gd = DETECT, gm,area,temp1,temp2,left =25,top=75; void *p; initgraph(&gd,&gm,”C:\TC\BGI”); setcolor(YELLOW); circle(50,100,25); setfillstyle(SOLID_FILL,YELLOW); floodfill(50,100,YELLOW); setcolor(BLACK); setfillstyle(SOLID_FILL,BLACK); fillellipse(44,85,2,6); fillellipse(56,85,2,6); ellipse(50,100.205,335,20,9); ellipse(50,100.205,335,20,10); ellipse(50,100.205,335,20,11); area...
Gayu
0 0
View Comments8
How do we print something, e.g. my name, in C language without using the printf function?
int main() { char str1; char str1; strcpy (str1,"tutorialspoint"); strcpy (str1,"compileonline"); puts(str1); puts(str1); return (0); } Compile and run the above program to produce the following result tutorialspoint compileonline
Praveen
0 0
View Comments6

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

Ask a Question

Related Lessons

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...

Vihanga Embedsoft

0 0
View Comments0
Be prepared to get trained--init
Before starting the training,students must be mentally prepared for acceptance of new knowledge. Students must attend training with open minded forgetting the position they are working.This will help...
S

Smartnub Softsolutions

0 0
View Comments0
Efficient Learning Strategies
Type your notes after class Write your notes onto flashcards - Scrabble -Make posters Review flashcards while walking, at gym, etc. Dog-ear pages in the reading where you can find...

Vijith V T

1 0
View Comments0
Datatypes in C Language
Data types in C Language Data types specify how we enter data into our programs and what type of data we enter. C language has some predefined set of data types to handle various kinds of data that...

Venkateswararao S.

0 0
View Comments0
How do i get best Campus / Off Campus Placement?
Companies are looking for Skilled Freshers. So build your technical skills while doing MCA / BTech / BCA / BSc (IT or CS) into below areas- 1. Strong your programming & debugging skills ...

Amit K.

0 0
View Comments0

Recommended Articles

Brilliant Academy, a reputed B. Tech Tuition...

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: An educational Training...

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 >

Learn Microsoft Excel

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 >

Learn Hadoop and Big Data

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 >

Find C Language Classes near you
C Language Classes in Bangalore
C Language Classes in Hyderabad
C Language Classes in Delhi
C Language Classes in Pune
C Language Classes in Mumbai
C Language Classes in Chennai
C Language Classes in Kolkata
C Language Classes in Ghaziabad
C Language Classes in Noida
C Language Classes in Jaipur

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