/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 vote310 views1 answer
Play framework connection via windows sql server
SQL
0 vote181 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote227 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote184 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote226 views1 answer
What is between keyword used for
SQL
0 vote227 views2 answers
How covert into int in maria db
SQL
0 vote202 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote239 views2 answers
Plpgsql
SQL
16 votes228 views6 answers
Install sqlite3 python
SQL
0 vote220 views2 answers
Get top 1 row of each group
SQL