/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

12 votes121 views2 answers
Delete all nodes neo4j
SQL
0 vote127 views1 answer
Basic structure of sql expression having clause
SQL
1 vote115 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote119 views1 answer
Remove from table where
SQL
5 votes119 views5 answers
Sqlite install python
SQL
3 votes130 views1 answer
Sql online test questions and answers
SQL
0 vote165 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote129 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote88 views1 answer
Oracle sql replace string in clob
SQL
0 vote133 views1 answer
Reset postgresql password windows
SQL