Hello Folks,

Hope all doing good.

I have been working for a company where they provide online classes for different technologies. My question is whenever we try to send a data into the database it shows that the info has been added successfully but, While fetching it says results no found. Kindly give me a solution for this.

Thanks

vibhour

• Mar 4th, 2020

Check if the column is redacted/masked. This you may need to check with DBA. So for example companies to protect client data, the masked certain PI columns such as names.

Himanshu Jawla

• Oct 31st, 2018

Make sure you are executing COMMIT; once insertion is done

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 6th, 2009

Synonym is a alias name for an Oracle object. It can be simplified names to access the objects. Example of Synonym and how it is useful Employee is a table is HR Schema A user wants to access the...

waseemvnb

 Profile Answers by waseemvnb Questions by waseemvnb

• Nov 12th, 2007

It is just like Aliasing .. ie giving some name in order to specicifically distinguish it....In other words to simplify the names of tables , column names etc it is used.. Suppose i have a column name...

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Dec 27th, 2009

1- a private synonym is defined in the schema of a user and is available only to the user.2- a public synonym is usually created by dba and is available for use by any database user.

praveena

• Sep 12th, 2005

Two types of synonims.1.public synonim,2.private synoniim.private synonym is confined to a particular user.public can be used by all the user's.

Answer Question  Select Best Answer

Taj_N

• Jul 16th, 2007

An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index

srujana

• Aug 23rd, 2005

It is created in existing table to locate rows more quickly&efficiently. the users cannot see the indexes,they are just used to speed up the queries

Answer Question  Select Best Answer

dhussainpathan

• Apr 9th, 2007

The Redo log files records the changes made  to the database in the form of REDOLOG entries, which are helpful at the time of Database Recovery Process.

rajesh chadalawada

• Dec 2nd, 2006

     Redo Log is ment to trce or note  the modifications that are applied to data buffer cache it will note on folloing situations1)for every 3 seconds2)when redo log buffer reaches to 1MB3)before db_cache writes data to datafiles4)when ever commited

Answer Question  Select Best Answer

A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. Statement rolled back is usually the one which detects the deadlock. Deadlocks are mostly caused by explicit locking because oracle...

Karthikeyan Balakrishnan

 Profile Answers by Karthikeyan Balakrishnan Questions by Karthikeyan Balakrishnan

• May 23rd, 2011

One process waiting for another process which never ends is known as deadlock.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 17th, 2007

 Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically ...

Answer Question  Select Best Answer

Sharfuddin

• Sep 29th, 2011

Select username,default tablespace,temporary tablespace from dba_users;

This query executes only if following queries is run in mount stage
1. @ $ORACLE_HOME/rdbms/admin/catalog.sql
2. @ $ORACLE_HOME/rdbms/admin/catproc.sql
3 connect system/manager
@ $ORACLE_HOME/sqlplus/admin/pupbld.sql

Rajashekar

• Sep 5th, 2011

Suppose if we are in need of the users connected to a tablespace called abcdata 6the how to findut?

SELECT USERNAME, TABLESPACE_NAME FROM DBA_USERS WHERE TABLESPACE_NAME='ABCDATA';

this will display the users connected to the tablespace abcdata.

Answer Question  Select Best Answer

Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns NULL in the value column if you are using pfile and not spfile3) SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL; // if the count is non-zero then the instance is using a spfile, and if the count...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

Select * from v$parameter where name='spfile';

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

show parameter spfile; if the output will be similar to the following, then it means that the instance is using SPFILENAME TYPE VALUE-----------------------...

Answer Question  Select Best Answer

Tony

• Oct 25th, 2006

Thanks for the information!

Chinny

• Sep 28th, 2006

Sharedpool contains 3 memory layers.1.Library cache: 2.Data dictionary cache3.UGA

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

Another suggestion could be: Find the Master Table(s) of the given table and export / import them all.

balakrishna

• May 28th, 2006

If u want to import the table just say constraints=n the movement table got imported then u create constriant on that tables.

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

ORA-1555 error can occur in Oracle 10g also even with UNDO RETENTION GUARANTEE enabled. ORA-1555 happens, when Oracle server process could not find the block-image in UNDO tablespace for the read...

paparao

• Oct 23rd, 2006

This shanshot too old. -> problem occurs generally in 9i only.  Whether in 10g, at the time of tablespace creation, retuntion guarentee is applied it automatically we can supress( by default i...

Answer Question  Select Best Answer

Sriniv@s..

• Jun 8th, 2012

SQLNET.ORA :: It is the optional network configuration file.it contain network configuration details.
LISTINER.ORA : It is the listener file for creating at server side
TNSNAMES.ORA:client side configuration file.it was matched with listener file.it for remote access.

Patrick McShea

• Nov 15th, 2006

SQLNET.ora tells you what path to take in resolving the name of an instance (among other things). In the context of this question, the NAMES.DIRECTORY_PATH parameter specifys the order of the naming methods used for client name resolution lookups. (TNSNAMES, ONAMES...)

Answer Question  Select Best Answer

How to check whether database whether it is opened by pfile/spfile.

Kapil Relan

 Profile Answers by Kapil Relan Questions by Kapil Relan

• Apr 15th, 2011

if you are not aware about what your database has chosen at startup ie PFILE or SPFILE you can simply try the following SQL statement:,which i tried create spfile from pfile;if you get the output that...

clevelcd

 Profile Answers by clevelcd Questions by clevelcd

• Jun 5th, 2008

Another alternative: SHOW PARAMETER SPFILE;

Answer Question  Select Best Answer

There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What does the the 1st user see ( x or y ) ? If x, then where is the value stored?

sviru

 Profile Answers by sviru Questions by sviru

• Jul 12th, 2011

X and that is read from undo segment

sean21

 Profile Answers by sean21 Questions by sean21

• Mar 8th, 2010

There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. ...

Answer Question  Select Best Answer

If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?

SSR

• Jul 20th, 2011

Depends on cardinality, for low cardinality then full scan better

prashanthpadal

 Profile Answers by prashanthpadal Questions by prashanthpadal

• Mar 23rd, 2011

If the query has to get the output more than 5% of the full table then full scan is better than Index scan. Here is the matter of 35% then, it should go though full table scan.

Answer Question  Select Best Answer

If dead lock happened for 2 applications at a time in a banking sector..how to resolve this issues without forcing any one of the application ..we should not have to stop the transaction...

Dharma Kotha

 Profile Answers by Dharma Kotha Questions by Dharma Kotha

• Oct 10th, 2011

A deadlock occurs when data was locked simultaneously by two sessions(users) and waiting for data, this can be resolved by rollback statement.

dharma

• Aug 23rd, 2011

Dead Locks can be resolved by rollback statement.

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 28th, 2007

An Extent is a set of contignous data blocks obtain in a single allocation and used to store specific type of information.

Yoh

• Jul 30th, 2006

Extends are a collection of data blocks

Answer Question  Select Best Answer

csanthoshreddy

 Profile Answers by csanthoshreddy Questions by csanthoshreddy

• Mar 6th, 2012

Datafile is the physical storage location of the database.tablespace is logical.for creation of tablespace one or more datafiles needed.we can define the datafile location with the following parameter

db_create_file_dest

Dharma Kotha

 Profile Answers by Dharma Kotha Questions by Dharma Kotha

• Oct 10th, 2011

Datafiles are physical data location of oracle architecture. Table space contains no.of datafiles.

Answer Question  Select Best Answer

Rahul Gupta

• Aug 8th, 2016

OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT TABLE_OWNER BASE_OBJECT_TYPE TABLE_NAME COLUMN_NAME REFERENCING_NAMES WHEN_CLAUSE STATUS DESCRIPTION ACTION_TYPE TRIGGER_BODY CROSSEDITIO...

ANIL

• Dec 13th, 2011

ABOUT TRIGGERNAME,
OWNER,
TRIGGERTYPE,
TRIGGEREVENT,
TABLEOWNER EXC
information is stored in DBA_TRIGGERS.

Answer Question  Select Best Answer

midhunam

 Profile Answers by midhunam Questions by midhunam

• Mar 7th, 2010

When the startup command enters the mount stage, it opens and reads the control file. The control file is a binary file that tracks important database information, such as the location of the databa...

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jan 4th, 2006

During database mount process, Oracle would check for the existence of controlfiles mentioned in init.ora file but it wont check the contents of the controlfile which is done during the opening of database.

Answer Question  Select Best Answer