/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 vote160 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
5 votes151 views6 answers
In operator sql
SQL
-1 vote167 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
1 vote149 views1 answer
Sql server insert into temp table
SQL
0 vote146 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote164 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote147 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote130 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
6 votes141 views1 answer
Update left join mysql
SQL
0 vote233 views1 answer
Drop check command
SQL