Run Oracle SQL script and exit from sqlplus.exe via command prompt
Another way is to use this command in the batch file: echo exit | sqlplus user/pass@connect @scriptname
oracle
PLS-00049 bad bind variable While using :OLD
You can save it in a local variable (like: v_deletedate) and then use that variable in your insert command. create or replace trigger dis_sal_his after delete or insert or update on employee for each row declare username varchar2(10); v_deletedate date; begin select user into username from dual; v_deletedate := :old.deletedate; insert into employeehistory values(:old.id,:old.name,:old.age,:old.address,:old.salary,v_deletedate); end;
ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
you’ve used double quotes on “X”. this should be ‘X’. the X object is an function in the MDSYS schema, “ogc_x”, so when you say est.tipo_estatus = “X” instead of the correct est.tipo_estatus = ‘X’ it gets translated (as “” is as an identifier so “X” is the same as just typing X) to est.tipo_estatus = mdsys.ogc_x and of course fails.
Find out the history of SQL queries
An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact problematic SQL query?
ORA-01735: invalid ALTER TABLE option – Toad
In TOAD I suppose, you need to execute it as a script (press F5) rather that running it as a statement.
ORA-01779: cannot modify a column which maps to a non key-preserved table
A DML table expression clause is only useful when you need columns from more than one table. In your case, you can use a regular update with an EXISTS: If you really do need to use columns from both tables you have three options: repeat the join in the SET and the WHERE clause. This is easy to build but … Read more
How do I view the Explain Plan in Oracle Sql developer?
EXPLAIN PLAN FOR In SQL Developer, you don’t have to use EXPLAIN PLAN FOR statement. Press F10 or click the Explain Plan icon. It will be then displayed in the Explain Plan window. If you are using SQL*Plus then use DBMS_XPLAN. For example, See How to create and display Explain Plan
How to copy files into a virtual box oracle box
A nice solution could be to share a directory on your host machine with the virtual machine, so you can copy your files in and out. Look at: How to share your computer files with a virtual machine
How can I set a custom date time format in Oracle SQL Developer?
You can change this in preferences: From Oracle SQL Developer’s menu go to: Tools > Preferences. From the Preferences dialog, select Database > NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field. Save and close the dialog, done! Here is a screenshot:
What is the difference between Views and Materialized Views in Oracle?
Materialized views are disk based and are updated periodically based upon the query definition. Views are virtual only and run the query definition each time they are accessed.