/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

0 vote163 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote182 views1 answer
How to find total working hour in sql
SQL
0 vote178 views1 answer
Look at running processes redshift
SQL
2 votes155 views2 answers
How to create an empty table from an existing table
SQL
1 vote163 views1 answer
Mysql get character set
SQL
0 vote189 views4 answers
Sql server date format yyyy-mm-dd
SQL
1 vote171 views1 answer
Load sql into mamp
SQL
0 vote198 views1 answer
Mysql export data with a where clause
SQL
1 vote175 views3 answers
Epoch to datetime
SQL
1 vote173 views2 answers
Mysql select tables with name like
SQL