I think using .* is the least of his problem if he does not understand the structuring of a union query. He obviously has not even glanced at the BOL doco for union so expecting him to understand a more subtle issue of using * is probably asking a little too much.
Never underestimate the power of human stupidity
If you're going to use SELECT * FROM ... rather than an explicit list of columns, you should be aware of this potential problem with views[^]: any changes to the underlying table will not be reflected in the view unless you explicitly refresh it.
Since your application is likely to expect a specific list of columns, it's always better to selected them explicitly. The SELECT * FROM ... syntax should only be used for temporary ad-hoc queries when you're exploring the data.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
in mysql database i implemented simple query on1likeselect * from dbo.company limit 2 .it taking tomuch time.except that table remaning all tables are working well.
in that table records also very less.i try to editing,droping,deleting any thing it isnot responding.any one know answer Please give answer.
Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done in the table thats modified? Can anyone help me whit this?
The problem is that i am new at this and i need all the help i can get i have tried with program that compares and execute the changes but i need help qith some script so i can make a bat file that excutes every hour i am fresh at this and need all the help i can get. I can c++, java and some sql but i nned help with oracle.
-- run every 5 MINUTES
schedule_name => 'INTERVAL_EVERY_5_MINUTES',
start_date => trunc(sysdate)+18/24,
repeat_interval => 'freq=MINUTELY;interval=5',
comments => 'Runtime: Every day all 5 minutes');
-- Call a procedure of a database package
program_type=> '???????', HERE IS MY PROBLEM IS IT POSIBLE TO MAKE A DBLINK TO CONNECTO TO THE OTHER DB AND RETRIEVE INFORMATION FROM A TABLE AND PAST IT ON TO SIMILAR TABLE ON THIS DB. AND PUT A FIELD DNM_SINC TO 'YES' WHEN IN DEFAULT IS NO?
comments=>'Procedure to collect session information'
-- Connect both dbms_scheduler parts by creating the final job
(job_name => 'JOB_COLLECT_SESS_DATA',
comments=>'Job to collect data about session values every 5 minutes');