I think you are using chrome. The problem is the certificate mismatch or the expiration of the certificate.Check your certificate properly. Just visit here for more information.
You’ll have to write the SQL DML yourself explicitly. i.e. UPDATE <table> SET <column> = NULL; Once it has completed you’ll need to commit your updates commit; If you only want to set certain records to NULL use a WHERE clause in your UPDATE statement. As your original question is pretty vague I hope this … Read more
Short of granting access to DBMS_LOCK.sleep, this will work but it’s a horrible hack: IN_TIME INT; –num seconds v_now DATE; — 1) Get the date & time SELECT SYSDATE INTO v_now FROM DUAL; — 2) Loop until the original timestamp plus the amount of seconds <= current date LOOP EXIT WHEN v_now + (IN_TIME * … Read more
It seems that SQL Developer thinks that you are running a plain DML (data manipulation) script, not a DDL (data definition). It also thinks that :new.id is a bindable variable. Why this happens, I don’t know; I can’t reproduce it in Oracle SQL Developer 2.1. Try to open a new SQL worksheet window in the … Read more
There is no difference. Note that BETWEEN is always inclusive and sensitive to the order of the arguments. BETWEEN ‘2010’ AND ‘2005’ will never be TRUE.
In my opinion, a dynamic PL/SQL block is somewhat obscure. While is very flexible, is also hard to tune, hard to debug and hard to figure out what’s up. My vote goes to your first option, EXECUTE IMMEDIATE v_query_str INTO v_num_of_employees USING p_job; Both uses bind variables, but first, for me, is more redeable and … Read more
You’re looking for USER_TAB_COLUMNS – all the columns, and their descriptions in the schema the query is executed in – or ALL_TAB_COLUMNS – the same except for all tables that user has permission to view. A typical query might be: select * from user_tab_columns where table_name=”MY_TABLE” order by column_id column_id is the “order” of the … Read more
You can use SUBSTR function as: select substr(‘TN0001234567890345’,-10) from dual; Output: 4567890345
https://forums.oracle.com/forums/thread.jspa?threadID=447344 The pertinent section reads: There’s no setting to fetch all records. You wouldn’t like SQL Developer to fetch for minutes on big tables anyway. If, for 1 specific table, you want to fetch all records, you can do Control-End in the results pane to go to the last record. You could time the fetching … Read more
the best explanation i’ve found is this: What is the difference betwen INTEGER and NUMBER? When should we use NUMBER and when should we use INTEGER? I just wanted to update my comments here… NUMBER always stores as we entered. Scale is -84 to 127. But INTEGER rounds to whole number. The scale for INTEGER … Read more