Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PLS-00428: an INTO clause is expected in this SELECT statement



PLS-00428: an INTO clause is expected in this SELECT statement..

Answer / guest

Cause: The INTO clause of a SELECT INTO statement was
omitted. For example, the code might look like SELECT
deptno, dname, loc FROM dept WHERE ... instead of SELECT
deptno, dname, loc INTO dept_rec FROM dept WHERE ... In
PL/SQL, only a subquery is written without an INTO clause.

Action: Add the required INTO clause.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02315: incorrect number of arguments for default constructor

1 Answers  


ORA-00131: network protocol does not support registration 'string'

1 Answers  


RMAN-08582: channel string: starting archive copy

1 Answers  


ORA-29367: object string does not exist

1 Answers  


ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.

1 Answers  


NNL-00298: No cache dump currently scheduled

1 Answers  


ORA-27204: skgfpqr: sbtpcqueryrestore returned error

1 Answers  


ORA-39955: invalid PL/SQL warning message number

1 Answers  


ORA-00253: character limit string exceeded by archive destination string string

1 Answers  


SQL*Loader-00272: Table level OPTIONS statement ignored.

1 Answers  


ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.

1 Answers  


ORA-00341: log string of thread string, wrong log # string in header

1 Answers  


Categories