Naruto

Naruto Uzumaki (うずまき　ナルト Uzumaki Naruto) is a fictional character from the Naruto universe created by Masashi Kishimoto as the main protagonist for the series and developed into other media. While creating Naruto, Kishimoto kept in mind to keep the character “simple and stupid” while giving him many attributes of Son Goku from the Dragon Ball [...]

Import or load DBF file to Oracle

I use this package to import data from dbase file – foxpro (dbf) to oracle table, –this is spec CREATE OR REPLACE PACKAGE DBF2ORA AS – PROCEDURE TO A LOAD A TABLE WITH RECORDS – FROM A FOXPRO FILE. – – USES A BFILE TO READ BINARY DATA AND DBMS_SQL – TO DYNAMICALLY INSERT INTO [...]

Unable to verify the certificate – code will be treated as unsigned.

Jinitiator Security Warning Unable to verify the certificate – code will be treated as unsigned. If this error appear, – check formsweb.cfg, if it show up with this line, WebUtilArchive=/forms90/java/frmwebutil.jar, /forms90/java/jacob.jar then use this following command, jarsigner.exe -verify -verbose d:\OraFRSHome\forms90\java\jacob.jar jarsigner.exe -verify -verbose d:\OraFRSHome\forms90\java\frmwebutil.jar jarsigner.exe is generally located in the \jdk\bin directory – make sure [...]

Oracle Report Server could not start

I’m not able to start the report server, then i took the following steps in command line, “rwserver -install rep_server_name” But when i start the service i got no error message, the status was Started, but when i refresh it had stopped. I look the smart agent icon disappears when i move the mouse over [...]

Redownload Lost Podcast Episodes (without resubscribe)

If you have accidentally deleted an episode of podcast show and want to download it again, you can tell iTunes to update the podcast and get the lost episodes back. You still have to re-download the lost episodes, but at least you didn’t have to re-subscribe to the whole podcast. First, make sure that the [...]

ORA-06553: PLS-382: expression is of wrong type

CREATE OR REPLACE FUNCTION GET_BOOL RETURN BOOLEAN IS BEGIN RETURN TRUE; END; SELECT GET_BOOL() FROM DUAL; ORA-06552: PL/SQL: Statement ignored ORA-06553: PLS-382: expression is of wrong type Cause : There is BOOLEAN datatype is supported by PL/SQL and NOT supported by SQL So you cannot use this function in a straight select statement. However, this [...]

Move to another tablespace

1. To move a TABLE TO another TABLESPACE, issue the following command: ALTER TABLE <table_name> MOVE TABLESPACE <new_tablespace>; 2. To move an INDEX, use the following command: ALTER INDEX <index_name> REBUILD TABLESPACE <new_tablespace>; 3. To move the LOB when moving the table, use the following: ALTER TABLE <table_name> MOVE TABLESPACE <new_tablespace> LOB (lob_item) STORE AS [...]

Task Scheduler Error 1717: The interface is unknown

Check Event Log and Remote Procedure Call services are started. Both of these services needed to be run in order to start the Task Scheduler service. Also make sure that account that run Task Scheduler have password. Task Scheduler will not work for accounts that do not have passwords.

Using the dbms_metadata package to extract all the schema ddl with one call

The DBMS_METADATA package provides the API for setting the environment parameters: DBMS_METADATA.SET_TRANSFORM_PARAM() procedure. The private procedure SetEnvironment() contains all the environment setup code. The procedure is called from the package initialization section. Therefore, it only executes once per session which is all you need. You want to set it up once at the very beginning. [...]

First Day and Last Day, First Date and Last Date

SELECT TO_NUMBER (TO_CHAR (TRUNC (LAST_DAY (ADD_MONTHS (SYSDATE, -1)) + 1), ‘DD’)) FIRST, TO_NUMBER (TO_CHAR (LAST_DAY (SYSDATE), ‘DD’)) LAST FROM DUAL SELECT LAST_DAY (ADD_MONTHS (SYSDATE, -1)) + 1 FIRST, LAST_DAY (SYSDATE) LAST FROM DUAL

Happy Chinese New Year

Happy Holiday^_^

REP-1314: Format Trigger ‘xxx’ references column ‘yyy’ at a wrong frequency’

I have 2 queries in report builder Q1 as header Q2 as detail I want to show description column with the condition below, When Q1 has detail in Q2, then my report will display Q2 description. If Q1 has no detail in Q2 then it display Q1 description. When i try modify the field and [...]

FRM-40010: Cannot read form xxx.fmx

Cause: One of the following: 1. You entered a nonexistent form name. 2. You typed an incomplete path or path does not exists 3. You do not have the proper privileges to run the form. 4. You do not have a compiled copy of the form. Action: Retype the form name correctly, provide the proper [...]

FRM-42017: Module name must be specified

Cause: You did not specify a module name. Action: Specify a module name. If this error message appear, you must check the specify module name exist. If exist but error message still received then check that module name located in virtual path that registered on forms90.conf. Look at line that like this, # Virtual path [...]

HotKeys

Windows Hotkeys Ctrl + Escape or Win: Display start menu. Shift + F10 or AppsKey: Display context menu. Win       : Display start menu Win + E: Open Windows Explorer. Win + F: Open Find Dialog. Win + M: Minimize all windows. Win + R: Open Run dialog. Win + U: Open Utility Manager dialog. Win + [...]

Export Oracle dump query result to CSV format

Here the simple procedure to do it, CREATE OR REPLACE FUNCTION DUMP_CSV ( P_QUERY IN VARCHAR2, P_SEPARATOR IN VARCHAR2 DEFAULT ‘,’, P_DIR IN VARCHAR2, P_FILENAME IN VARCHAR2 ) RETURN NUMBER IS L_OUTPUT UTL_FILE.FILE_TYPE; L_THECURSOR INTEGER DEFAULT DBMS_SQL.OPEN_CURSOR; L_COLUMNVALUE VARCHAR2 (2000); L_STATUS INTEGER; L_COLCNT NUMBER DEFAULT 0; L_SEPARATOR VARCHAR2 (10) DEFAULT ”; L_CNT NUMBER DEFAULT 0; [...]

Top 10 Heroes

Strongest Weakest Treant Protector Geomancer Ogre Magi Oblivion Doom Bringer Holy Knight Butcher Phantom Lancer Tidehunter Nerubian Weaver Stone Giant Tormented Soul Ursa Warrior Slayer Pandaren Brewmaster Lich Skeleton King Shadow Shaman Chaos Knight Bone Fletcher Fastest (AS) Slowest (AS) Soul Keeper Undying Phantom Assassin Stone Giant Bounty Hunter Doom Bringer Morphling Enigma Bone Fletcher [...]