/SQL/How to do a function to return row type from a table in pl/sql

How to do a function to return row type from a table in pl/sql

CREATE TABLE account1 (
 account_id INT,
 name       VARCHAR2(20)
);

INSERT INTO account1 VALUES ( 1, 'Bob' );

CREATE OR REPLACE FUNCTION get_accounts(
  Acc_id IN Account1.account_id%TYPE
) RETURN account1%ROWTYPE
AS
  l_cust_record account1%ROWTYPE;
BEGIN
  SELECT *
  INTO   l_cust_record
  FROM   account1
  WHERE  account_id = Acc_id;

  RETURN l_cust_record;
END;
/

Source: stackoverflow.com

Similar codes

3 votes210 views2 answers
Get current year sql
SQL
0 vote212 views1 answer
Sql last time database was accessed
SQL
0 vote222 views1 answer
Get only one row in mysql
SQL
0 vote219 views1 answer
Sql get highest date from 3 tabels
SQL
50 votes224 views6 answers
Sql duplicate rows
SQL
0 vote218 views1 answer
Implicit inner join table alias
SQL
1 vote209 views1 answer
Mysql current time
SQL
-1 vote198 views1 answer
Window functions in sql
SQL
1 vote330 views3 answers
Uninstall postgresql mac
SQL
5 votes212 views1 answer
Oracle sysdate - 1 month
SQL