Search results for query: *

Hi not sure you have not provided enough details I would say there is a permission issue on a directory to create a output file on the machine which you are getting the error and the subsequent access to the output file is giving an error as the output file was not created garan

1. Alternatively use TO_CHAR Change the last line in your code as DBMS_OUTPUT.PUT_LINE(to_char(v_full,'DD-MON-YYYY HH24:MI:SS')); 2. If you are using sqldeveloper you can use preference option to permanently set the format Tools->Preferences->Database->NLS: change the Date Format to same...

Hi as conveyed it's more to deal with the display issue I think you made a typo it is NLS_DATE_FORMAT not NL_DATE_FORMAT I don't think you require any special privilege at the session level SQL> create user test1 identified by test1; User created. SQL> grant create session to test1 2...

Hi You are indeed storing data and time but the display it is showing only DD-MON-YYYY This is more to do with the setting of the NLS_DATE_FORMAT I stored your script in a file called x.sql and executed the script as shown below after adjusting NLS_DATE_FORMAT SQL> alter session set...

Hi can somebody throw me a light on the new Features of 12C compared to 11g both from developer perspective as well as DBA perspective garan

Hi All I worked on PowerBuilder Ver 5.0 Long back and did not get a chance to work later. I am interested know the new features of PowerBuilder 12.5 compared to earlier releases Regards garan

Hi HSODBC is little complex for a newbie but still you can do again your oracle server should be running on Windows NT/7/8 so that you can configure ODBC connection. If it is running on Unix there might be additional complexity. This was the old method which we used HSODBC.ORA instead of...

Hi Just a note for speeding up the process 1. When creating a new table you can give UNRECOVERABLE OPTION to bypass the redologs I am assuming the DBA's has export dump of the old_audit_table create new_audit_table as select the_records_you_want_to_keep from old_audit_table...

In other words the BEGIN KEYWORD should immediately follow AS/IS and you have put BEGIN at the wrong place

Hi User eggy168 You have missed BEGIN KEYWORD in your stored procedure STEP 1: DROP TABLE EMP; CREATE TABLE EMP(ID NUMBER); INSERT INTO EMP VALUES(10); COMMIT; SELECT COUNT(*) FROM EMP; -- Will give 1 row STEP 2: CREATE OR REPLACE PROCEDURE SP_TEST IS BEGIN...

Hi please use quotes in EXECUTE IMMEDIATE BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE EMP'; END; Regards garan

Hi I agree creating a link from SQL server to Oracle is one/might be best option. Alternatively You can create a database link from Oracle to SQL server using HSODBC and use the link to access SQL server objects Let's say you want to refresh Table A from SQL server to Table B in Oracle...

Hi Please note that for single row insert you can use INSERT for values clause For Multiple row insert say 4 records you can use INSERT ALL Advantage of INSERT ALL is you can insert records into Multiple Tables Reference : http://www.oratable.com/oracle-insert-all/ insert all into...

Hi Please check the below SQL query SELECT TABLE_NAME,LAST_ANALYZED,NUM_ROWS FROM ALL_TABLES WHERE OWNER_NAME=<OWNER_NAME> AND TABLE_NAME=<TABLE_NAME> If the LAST_ANALYZED shows today's date and SELECT COUNT(*) FROM OWNER_NAME.TABLE_NAME IN question matches with NUM_ROWS...