Questions tagged [ora-01747]
8 questions
20
votes
3 answers
"date" as a column name
I have a table called calendars.
One of its columns is named 'date'
When I want to select the date column it gives error ORA-01747 namely invalid table.column.
select date from calendars
I guess this happens because 'date' is a reserved word for…
bonsvr
- 2,262
- 5
- 22
- 33
3
votes
4 answers
SQL Query Syntax : Using table alias in a count is invalid? Why?
Could someone please explain to me why the following query is invalid? I'm running this query against an Oracle 10g database.
select count(test.*) from my_table test;
I get the following error: ORA-01747: invalid user.table.column, table.column,…
contactmatt
- 18,116
- 40
- 128
- 186
0
votes
1 answer
i got a error ORA-01747 when insert data into table
i got trouble when insert data using this query :
INSERT ALL
INTO obat ('id_obat','nama_obat','tanggal_kadarluarsa','stock','harga')
VALUES (1, 'Indomethacin', '2023-09-01', 50, 3000)
SELECT * FROM dual;
this is the table query :
CREATE…
Rizal Maulana
- 73
- 1
- 9
0
votes
1 answer
getting error on Merge Statement - ORA-01747
Am new to oracle database(been working on DB2 and cobol). i have a question on Merge Statement. From Javascript, am trying to insert a row into a table in Oracle DB. if the insert fails, then the plan is to update. I have used Merge Statements in…
Sadiq Sikkandhar
- 17
- 3
0
votes
1 answer
PHP - ORA-01747: invalid user.table.column, table.column, or column specification
I'm trying to update a table called RAC_PV at my oracle database but the query is returning that error when i run my application. I thing everyting is right because i run the same query on sqldeveloper (but with manual values) and when i change the…
L. Zen
- 3
- 1
0
votes
2 answers
Oracle 10g - ORA-01747 Error
My procedure:
CREATE OR REPLACE PROCEDURE akcia_nepozicane_s_kurzorom
(denny_poplatok IN NUMBER,
kilometrovy_poplatok IN NUMBER)
AS
my_id_auto NUMBER(5);
my_poplatok_denny NUMBER(4);
my_poplatok_km NUMBER(2);
CURSOR c1 IS
…
Richard Knop
- 81,041
- 149
- 392
- 552
-1
votes
1 answer
PL/SQL: ORA-01747 error: invalid specification user.table.column, table.column or column
I am trying to learn PL/SQL and I have a problem creating procedure.
I want to create a procedure that will automatically increase the commission by 10% after the end of
trial period - 3 months. I need to create a scheduler,
who will activate the…
Kristina
- 15
- 4
-1
votes
1 answer
ORA-01747_invalid user.table.column, table.column, or column specification
I don't have so many experience in this..I've got this error when I tried to insert into table.
Here's code:
CREATE TABLE factory
(idfactory INT NOT NULL,
location_id INT NOT NULL,
owner INT NOT NULL,
CONSTRAINT factory_id_pk PRIMARY…
Dana
- 107
- 9