/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 vote131 views1 answer
Sql create and grant user access to database
SQL
4 votes51 views1 answer
And or sql order of operations
SQL
9 votes106 views2 answers
Convert data type in sql
SQL
-1 vote85 views2 answers
On update cascade
SQL
0 vote96 views1 answer
Sql contains vs like
SQL
11 votes96 views5 answers
How to install sqlite3 python
SQL
-1 vote154 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote113 views1 answer
Update substring in mysql
SQL
0 vote106 views1 answer
How to subquey to do not load in live database in
SQL
3 votes56 views1 answer
If 0 return null else return query mysql
SQL