/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 vote287 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote331 views1 answer
Setval in postgres
SQL
2 votes278 views2 answers
Mysql get last character of string
SQL
10 votes349 views3 answers
Sql select between two dates
SQL
0 vote334 views1 answer
Create bdd mysql
SQL
6 votes327 views1 answer
Oracle list primary key
SQL
0 vote309 views1 answer
Oracle search in date columns
SQL
0 vote340 views1 answer
Mysql a from on this page has
SQL
1 vote344 views4 answers
Psql check tables command
SQL
2 votes312 views1 answer
Drop table if exists in postgres
SQL