In this blog I will post all FAQs, code snippets, real time problems and solutions and any other links which I feel every one needs and can take advantage of.
Freshers Category targeted to all fresher FAQs which they need to know before going for an interview. Covers both technical and non-technical aspects of interview.
 | | Use this logic to select alternative records from a table -
SQL> ed
Wrote file afiedt.buf
1 select * from
2 (select rownum row_num,exec_date from clob_test)
3* where mod(row_num,2)=1
SQL> /
ROW_NUM EXEC_DATE
---------- ---------
1 13-OCT-08
3 13-OCT-08
5 13-OCT-08
7 13-OCT-08
9 13-OCT-08
11 13-OCT-08
6 rows selected.... | Super Moderator | |
Comments 0
 |
| | This can be a very handy script if you want to convert a SQL query output into a HTML table.
Execute following anonymous pl/sql block in your SQL*Plus editor -
* Sorry for bad formatting
declare
c number;
d number;
col_cnt integer;
f boolean;
rec_tab dbms_sql.desc_tab;
col_num number;
column_value varchar2(32767);
col_index integer;
sql_query varchar2(32767);... | Super Moderator | |
| Comments 0
|
Freshers
(2)