Returning Multiple Columns : Columns « Query Select « Oracle PL/SQL Tutorial






SQL>
SQL> CREATE TABLE SAT (
  2     StudentID  INT NOT NULL,
  3     ExamID     INT NOT NULL,
  4     Mark       INT,
  5     IfPassed   SMALLINT,
  6     Comments   VARCHAR(255),
  7     CONSTRAINT PK_SAT PRIMARY KEY (StudentID, ExamID)
  8  );

Table created.

SQL>
SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (1,1,55,1,'Satisfactory');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (1,2,73,1,'Good result');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (2,3,44,1,'Hard');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (2,5,39,0,'Simple');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed) VALUES (2,6,63,1);

1 row created.

SQL>
SQL>
SQL>
SQL> SELECT StudentID, ExamID, Comments FROM SAT;

 STUDENTID     EXAMID
---------- ----------
COMMENTS
--------------------------------------------------------------------------------
         1          1
Satisfactory

         1          2
Good result

         2          3
Hard

         2          5
Simple

         2          6



5 rows selected.

SQL>
SQL>
SQL> drop table SAT;

Table dropped.








2.8.Columns
2.8.1.Selecting All Columns from a Table with asterisk character (*)
2.8.2.Count(*) and column renaming
2.8.3.Expression and column renaming
2.8.4.DISTINCT tableName.*
2.8.5.Combined columns and renaming
2.8.6.Format date value and column renaming
2.8.7.Reference one column more than once
2.8.8.Reference renamed column in order by
2.8.9.Rename case when column
2.8.10.Returning Multiple Columns
2.8.11.Table renaming in from clause
2.8.12.Use table name to reference column name