Filtering a table based on multiple values of a single column I have a list of names in a specific column of a table. Is there a way to build a query which can pull out all the attributes of this names? I am a total novice so any help is appreciated

Example: User table

table columns:


User id
attributes
user privileges
1st name
2nd name


The filter has to be applied based on a bunch of user first names.
Sure, you are looking for the IN condition. 

https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions013.htm

SELECT UserID, Attributes, UserPrivileges, 1stName, 2ndName
FROM User
WHERE 1stName IN ('John', 'Jane', 'Joseph', 'Laura');