/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 vote112 views1 answer
Error code 1292 mysql workbench
SQL
0 vote108 views1 answer
How to join result table in mysql
SQL
0 vote97 views1 answer
Call function sql oracle with output put line
SQL
0 vote115 views1 answer
Select into table variable
SQL
1 vote117 views1 answer
Oracle compile schema
SQL
0 vote100 views1 answer
Pagination with row_number
SQL
13 votes90 views5 answers
Alter table query sql server change column
SQL
2 votes107 views1 answer
Q operator in oracle
SQL
8 votes124 views4 answers
Reset SQL auto increment
SQL
3 votes107 views1 answer
Two select sql
SQL