/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

4 votes216 views3 answers
Employee name starting with in sql
SQL
0 vote198 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote200 views1 answer
Create tables from xsd to sql server database c#
SQL
5 votes252 views1 answer
Oracle source query
SQL
0 vote196 views3 answers
Postgresql grant alter table to user
SQL
1 vote221 views2 answers
Mysql extract number from string
SQL
0 vote209 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote212 views1 answer
Insert using condition postgres
SQL
0 vote214 views1 answer
C# get sql min date
SQL
4 votes189 views4 answers
Print pl sql
SQL