CREATE VIEW with concatenated fields

Question

I have a table with Last Names, First Names, Hours and GPA's.

How do I create a view that displays a concatenated first name and last name, the StudentID and the GPA of the students who have passed at least 90 hours.

The concatenated names should be separated with one space. The three column headings should be FullName, StudentID and GPA. The rows should be sorted by last names, then first names.

Please help. I am lost as to how to approach this.

What have you tried? What part of the task is causing you a problem? Do you know how to create a view from a query, for example, but don't know how to write this query? Do you know how to write a select statement in general? Are you just trying to understand the syntax for concatenating strings in Oracle SQL? — Justin Cave
– Justin Cave, Commented Jul 1, 2015 at 16:17
The problem is that when I create the view, it doesn't display the real name, it just says FirstNameLastName, it displays the other values correctly but not the concat name — Ana Mar
– Ana Mar, Commented Jul 1, 2015 at 17:16
If it just says literally FirstNameLastName for every row it means you're passing the strings "FirstName" and "LastName" instead of the variables for first name and last name as arguments to concat — C8H10N4O2
– C8H10N4O2, Commented Jul 1, 2015 at 18:50

C8H10N4O2 · Accepted Answer · 2015-07-01 16:23:29Z

2

Use the operator || for concatenation (so you don't have to do nested CONCAT()).

Example:

create view v as 
    select (firstname || ' ' || lastname) "FullName", GPA, StudentId 
    from table
    where Hours>90
    order by lastname, firstname

edited Jul 1, 2015 at 16:23

answered Jul 1, 2015 at 16:17

C8H10N4O2

19.2k10 gold badges106 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ana Mar Over a year ago

Do you know why it shows the full name as FirstNameLastName instead of the real values

C8H10N4O2 Over a year ago

Is it possible that you're passing character strings like "FirstName" instead of variable names like FirstName into your select statement? Check your quotation marks.

Collectives™ on Stack Overflow

CREATE VIEW with concatenated fields

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related