/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 vote305 views1 answer
Mysql docker image arjun
SQL
0 vote315 views1 answer
Mysql change innodb to myisam
SQL
10 votes299 views6 answers
Between sql
SQL
4 votes316 views4 answers
Rollback in sql
SQL
1 vote300 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote288 views1 answer
Forcefully delete a row in mysql which has references
SQL
5 votes314 views3 answers
Mysql update field from one table to another
SQL
2 votes301 views1 answer
Sql server conection string
SQL
3 votes307 views1 answer
Oracle show trigger code
SQL
0 vote293 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL