Home » SQL & PL/SQL » SQL & PL/SQL » oracle pl/sql (11g)
oracle pl/sql [message #683360] Mon, 04 January 2021 02:15 Go to next message
thirunakar ramesh
Messages: 1
Registered: January 2021
Junior Member
i want a query to select all rows of employee table by creating procedure.
Re: oracle pl/sql [message #683361 is a reply to message #683360] Mon, 04 January 2021 11:27 Go to previous message
Michel Cadot
Messages: 67839
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

We don't do homework but we will help you to do it.
Post what you already and explain where you are stuck.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Before, Please read How to use [code] tags and make your code easier to read.
Indent the code, make sure that lines of code do not exceed 100 characters.

Also better explain what you want; what is the expected result?
From you post there is no expected result, just a procedure that selects a table (but does nothing about what it selects), then a simple CURSOR LOOP will do the trick.

Previous Topic: Fuzzy Matching S-Q-L Sever Taking Fime for 2.4 millions records
Next Topic: SQL query.
Goto Forum:

Current Time: Thu May 06 14:25:41 CDT 2021