advanced code snippet search

Posted By

jaytee on 09/17/08


Tagged


Versions (?)

Test PL/SQL syntax highlighting

 / Published in: PL/SQL
 
Expand | Embed | Plain Text 
  1. DECLARE
  2.   number1 NUMBER(2);
  3.   number2 NUMBER(2)    := 17;
  4.   text1    VARCHAR2(12) := 'Hello world';
  5.   text2    DATE         := SYSDATE;        -- current date and time
  6. BEGIN
  7.   SELECT street_number
  8.   INTO   number1
  9.   FROM   address
  10.   WHERE  name = 'Smith';
  11. END;

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: inventorstechnologies on December 24, 2008

To get n th row in a table :

select * from tt a where &n = (select count(rowid) from tt where rowid

Posted By: inventorstechnologies on December 24, 2008

To get last row in a table :

select * from tt where rowid = (select max(rowid) from tt);

http://www.inventorstechnologies.com

Posted By: inventorstechnologies on December 24, 2008

To get second max sal in a table :

select max(sal) from tt where sal

You need to login to post a comment.