/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

1 vote104 views1 answer
Sql sort column by date
SQL
1 vote98 views1 answer
Sql not equal multiple columns
SQL
0 vote95 views2 answers
Sql count number of rows after group by
SQL
3 votes102 views4 answers
Order by desc postgres
SQL
23 votes104 views4 answers
How to show all users in mysql
SQL
1 vote100 views1 answer
Postgres set column equal to another
SQL
0 vote101 views1 answer
Sql convert float to string
SQL
4 votes96 views1 answer
Mysql ip address
SQL
-1 vote94 views3 answers
Compute age mysql
SQL
3 votes97 views1 answer
Insert into table from another table mysql
SQL