What happens if variable names collide with table/column names?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
without using count(*) and rownum how can we count total record in a table
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Does a Before form trigger fire when the parameter form is suppressed ?
what is Table ?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
How to install oracle database 10g xe?
Can a parameter be passed to a cursor?
What is the meaning of recursive hints in oracle?
What is oracle rownum?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What are the different pseudo commands? Explain in general?