/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 vote202 views2 answers
SQL BULK INSERT
SQL
0 vote158 views1 answer
Mysql count unique in group statement
SQL
0 vote199 views1 answer
Create table with timestamp mysql youtube
SQL
7 votes152 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote156 views1 answer
How much table store postgres
SQL
1 vote176 views1 answer
Psql connect to another database
SQL
0 vote158 views1 answer
Mysql streaming example
SQL
0 vote153 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote157 views2 answers
Mysql: command not found
SQL
-1 vote152 views1 answer
Sql add column bit
SQL