top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: Is the query below allowed?

+1 vote
274 views

Is the query below allowed :

Select    sal
               ,ename
    Into     x
 From     emp 
Where   ename = 'KING'

(Where x is a record of Number(4) and Char(15))

posted Dec 30, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Yes, allowed

answer Dec 31, 2014 by Arun Gowda
Similar Questions
+1 vote
oracle: Is the assignment given below allowed ?

Is the assignment given below allowed :

   ABC = PQR (Where ABC and PQR are records)
+2 votes
Oracle: Below were the interview questions which was held by IBM.

1) Is this for loop allowed :For x in &Start..&End Loop

2) Which symbol preceeds the path to the table in the remote database?

3) Are views automatically updated when base tables are updated?

4) Can a trigger written for a view?

5) If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record ?

Please have a look at and find the answers.

+3 votes
Oracle: Why is the query not fetching the records for the date I wanted?

SELECT EMP_NAME, SSN FROM EMP WHERE HIER_DATE = TO_DATE('03-NOV-1999','DD-MON-YYYY');

...