table « MemoSoup

Oracle: using DBMS_METADATA for getting table structure

SET LONG 5000

SELECT dbms_metadata.get_ddl(’TABLE’,'EMP’,'SCOTT’)
FROM dual;

Some other values of the type field for dbms_metadata.get_ddl function:

INDEX
DB_LINK
PACKAGE

(See also “Oracle® Database PL/SQL Packages and [...]

JavaScript: build table dynamically

var the_body = document.getElementsByTagName("body")[0];

<code>var new_table = document.createElement("table");
var new_tbody = document.createElement("tbody");

var new_row, new_col, new_text ;

for(row=1;row<=n_rows;row++) {
new_row = document.createElement("tr");
new_row.className = "tr"+row ;
for(col=1;col<=n_columns;col++) {
new_col = document.createElement("td");
new_col.className = "td"+col ;
new_text = document.createTextNode("text:" + row + ":" + col );

new_col.appendChild(new_text);
new_row.appendChild(new_col);
}
new_tbody.appendChild(new_row);
}

new_table.appendChild(new_tbody);
new_table.setAttribute("border", "2");

the_body.appendChild(new_table);

return new_table ;

}
</script>
<body>
Example:
<script type="text/javascript">
buildTable(4,3)
</script>
</body>

There is also interesting article on oreillynet.com, discussing performance improvement for [...]

Oracle: transpose data table (rows into columns)

CREATE TABLE MAIN_TBL (
magazine VARCHAR2(10),
region VARCHAR2(5),
quantity int );

INSERT INTO MAIN_TBL VALUES ( ‘Playboy’, ’Nord’, 1 );
INSERT INTO MAIN_TBL VALUES ( ‘Playboy’, ’East’, 2 );
INSERT INTO MAIN_TBL VALUES ( ‘AutoWeek’, ‘Nord’, 3 );
INSERT INTO MAIN_TBL VALUES ( ‘AutoWeek’, ‘West’, 4 );
INSERT INTO MAIN_TBL VALUES ( ‘Wired’, ’Nord’, 5 );
INSERT INTO MAIN_TBL VALUES ( [...]

MemoSoup

Meta

Oracle: using DBMS_METADATA for getting table structure

JavaScript: build table dynamically

Oracle: transpose data table (rows into columns)