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.
Technical FAQ All FAQs related to programming languages grouped under category for each language
 | | 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
|
